搜题

【单项选择题】

Your  database  is&ensp;5GB  and  contain  satable&ensp;named  Sales  History.&ensp;Sales&ensp;informationis&ensp;frequently&ensp;inserted&ensp;and&ensp;updated.&ensp;You&ensp;discover&ensp;that&ensp;excessive&ensp;page&ensp;splitting&ensp;is&ensp;occurring.&ensp;You&ensp;need to&ensp;reduce&ensp;the&ensp;occurr  enceof&ensp;page&ensp;splitting&ensp;in&ensp;the  Sales  History  table.<br /> Which&ensp;code&ensp;segment&ensp;should&ensp;you use?（）<p> Your  database  is&ensp;5GB  and  contain  satable&ensp;named  Sales  History.&ensp;Sales&ensp;informationis&ensp;frequently&ensp;inserted&ensp;and&ensp;updated.&ensp;You&ensp;discover&ensp;that&ensp;excessive&ensp;page&ensp;splitting&ensp;is&ensp;occurring.&ensp;You&ensp;need to&ensp;reduce&ensp;the&ensp;occurr  enceof&ensp;page&ensp;splitting&ensp;in&ensp;the  Sales  History  table.<br /> Which&ensp;code&ensp;segment&ensp;should&e

A、A.ALTER DATABASE Sales MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)

B、B.ALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)

C、C.EXEC sys.sp_configure 'fill factor (%)', '60'

D、D.UPDATE STATISTICS Sales.Sales History(Products) WITH FULLSCAN, NORECOMPUTE

查看正确答案

更多“Your  database  is&ensp;5GB  and  contain  satable&ensp;named  Sales  History.&ensp;Sales&ensp;informationis&ensp;frequently&ensp;inserted&ensp;and&ensp;updated.&ensp;You&ensp;discover&ensp;that&ensp;excessive&ensp;page&ensp;splitting&ensp;is&ensp;occurring.&ensp;You&ensp;need to&ensp;reduce&ensp;the&ensp;occurr  enceof&ensp;page&ensp;splitting&ensp;in&ensp;the  Sales  History  table.<br /> Which&ensp;code&ensp;segment&ensp;should&ensp;you use?（）<p> Your  database  is&ensp;5GB  and  contain  satable&ensp;named  Sales  History.&ensp;Sales&ensp;informationis&ensp;frequently&ensp;inserted&ensp;and&ensp;updated.&ensp;You&ensp;discover&ensp;that&ensp;excessive&ensp;page&ensp;splitting&ensp;is&ensp;occurring.&ensp;You&ensp;need to&ensp;reduce&ensp;the&ensp;occurr  enceof&ensp;page&ensp;splitting&ensp;in&ensp;the  Sales  History  table.<br /> Which&ensp;code&ensp;segment&ensp;should&e”相关的问题

第1题

[单选题] You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming the control files&nbsp;&nbsp;B、dropping a user in your database&nbsp;&nbsp;C、enabling or disabling redo log archiving&nbsp;&nbsp;D、dropping a tablespace in your database&nbsp;&nbsp;E、re-creating the control files， after you lost all the control files in your database&nbsp;&nbsp;

点击查看答案

第2题

[] You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（） You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）

A、A.the time when the last flashback operation in your database was performed&nbsp;&nbsp;B、B.the time when the first flashback operation in your database was performed&nbsp;&nbsp;C、C.a list of flashback operations performed in your database using SCN and time&nbsp;&nbsp;D、D.the approximate time and the lowest system change number （SCN） to which you can flash back your database&nbsp;&nbsp;

点击查看答案

第3题

[] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（） You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、A. You must have change tracking enabled in your database&nbsp;&nbsp;B、B. Your database must be running in NOARCHIVELOG mode&nbsp;&nbsp;C、C. To back up a tablespace, it must be in backup mode&nbsp;&nbsp;D、D. To back up a tablespace, it must first be taken offline&nbsp;&nbsp;

点击查看答案

第4题

[单选题] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、You must have change tracking enabled in your database&nbsp;&nbsp;B、Your database must be running in NOARCHIVELOG mode&nbsp;&nbsp;C、To back up a tablespace, it must be in backup mode&nbsp;&nbsp;D、To back up a tablespace, it must first be taken offline&nbsp;&nbsp;

点击查看答案

第5题

[单选题] A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

A、 backup database all&nbsp;&nbsp;B、 backup compressed database&nbsp;&nbsp;C、 backup as compressed backupset database&nbsp;&nbsp;D、 backup as compressed backup database plus archivelog all&nbsp;&nbsp;E、 backup as compressed backupset database plus compress archivelog all&nbsp;&nbsp;

点击查看答案

第6题

[单选题] You are a network administrator for your company. All servers run Windows Server 2003. You manage a file server named Server8. You need to create a performance baseline for Server8 by using Performance Logs and Alerts. You need to store the performance data in an existing Microsoft SQL Server database on another computer. You create a new counter log, and you select SQL Database as the log file format. When you attempt to save your changes, you receive an error message stating that you must select a data source name. You examine the configuration of the SQL Logs, as shown in the following dialog box. You need to configure the counter log to use a SQL database. What should you do? （）

A、Use the relog command-line utility to configure a connection to your SQL database.&nbsp;&nbsp;B、Use Add or Remove programs to install Connection Point Services. Configure a connection to your SQL database.&nbsp;&nbsp;C、Use the logman command-line utility with the create switch to configure a connection to your SQL database.&nbsp;&nbsp;D、Use Data Sources (ODBC) to configure a connection to your SQL database.&nbsp;&nbsp;

点击查看答案

第7题

[单选题] You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

A、 The time when the last flashback operation in your database was performed.&nbsp;&nbsp;B、 The time when the first flashback operation in your database was performed.&nbsp;&nbsp;C、 A list of flashback operations performed in your database using SCN and time.&nbsp;&nbsp;D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.&nbsp;&nbsp;

点击查看答案

第8题

[] Your database runs in ARCHIVELOG mode， and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database. How can you do this？（） Your database runs in ARCHIVELOG mode， and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database. How can you do this？（）

A、A.A&nbsp;&nbsp;B、B.B&nbsp;&nbsp;C、C.C&nbsp;&nbsp;D、D.D&nbsp;&nbsp;

点击查看答案

第9题

[多选题] You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

A、Reregistering the target database in recovery catalog&nbsp;&nbsp;B、Transporting the new tablespaces to the recovery catalog database&nbsp;&nbsp;C、Syncronizing the recovery catalog with the target database control file&nbsp;&nbsp;D、Performing a fresh backup of the target database to include the new data files in the catalog database&nbsp;&nbsp;

点击查看答案

第10题

[] You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（） You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the product

A、A. Open the database in NORMAL mode&nbsp;&nbsp;B、B. Open the database in read-only mode&nbsp;&nbsp;C、C. Open the database in RESTRICTED mode&nbsp;&nbsp;D、D. Open the database with the RESETLOGS option&nbsp;&nbsp;

点击查看答案

账号：登录

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服