单选题Which statement is true regarding the VALIDATE DATABASE command?()A It checks the database for intrablock corruptions only.B It checks for block corruption in the valid backups of the database.C It checks the database for both intrablock and interblock corruptions.D It checks for only those corrupted blocks that are associated with data files.

单选题
Which statement is true regarding the VALIDATE DATABASE command?()
A

 It checks the database for intrablock corruptions only.

B

 It checks for block corruption in the valid backups of the database.

C

 It checks the database for both intrablock and interblock corruptions.

D

 It checks for only those corrupted blocks that are associated with data files.


参考解析

解析: 暂无解析

相关考题:

Which statement is true regarding the VALIDATE DATABASE command?() A. It checks the database for intrablock corruptions only.B. It checks for block corruption in the valid backups of the database.C. It checks the database for both intrablock and interblock corruptions.D. It checks for only those corrupted blocks that are associated with data files.

Which two statements are true about the RMAN validate database command?() A. It checks the database for intrablock corruptions.B. It can detect corrupt pfiles.C. It can detect corrupt spfiles.D. It checks the database for interblock corruptions.E. It can detect corrupt block change tracking files.

Which statement is true regarding Backup tasks in Cisco UCS?()A、 They are created automatically and stored on the FIB、 They are created manually and exported to a remote serverC、 They are automatically scheduled to run every 24 hoursD、 They are manually scheduled and stored on the FI

Which two statements are true about the RMAN validate database command?()A、It checks the database for intrablock corruptions.B、It can detect corrupt pfiles.C、It can detect corrupt spfiles.D、It checks the database for interblock corruptions.E、It can detect corrupt block change tracking files.

Which one of the following answer choices below is true regarding the OSPF topology database?()A、All entries in the topology database will be included on each router.B、All routers in the same OSPF area will have one topology database.C、The Dijkstra algorithm is used in the creation of the topology database.D、LSA packets are used to update and maintain the topology database.

You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?()A、The instance would hang.B、The instance needs to be shut down.C、The instance would be in the open state.D、The instance would abort in such cases.E、The instance would be in the open and invalid state.F、The instance would in the open state, but all the background processes will be restarted.

Which statement is true regarding RMAN components?()A、Each target database requires its own recover catalog. B、RMAN scripts can be stored in the recovery catalog or the target control file. C、A channel is a stream of data to a device type and corresponds to one server session. D、The RMAN executable interprets sever session commands and establishes connections to the target database.

You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C、 The control file must be recreated.D、 The database must be opened with the RESETLOGS option.

Which statement regarding the contents of the V$PARAMETER view is true?()A、displays only the list of default valuesB、displays only the list of all basic parametersC、displays the currently in effect parameter valuesD、displays only the list of all advanced parametersE、displays the list of all the parameter files of a database

Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement regarding the status of the database is true?()A、The database remains open.B、The database gets dismounted.C、The database becomes read only.D、The database instance gets aborted.E、The database gets shut down automatically.F、The status of the database depends on the status of the USERS tablespace.

Which statement is true regarding the VALIDATE DATABASE command?()A、It checks the database for intrablock corruptions only.B、It checks for block corruption in the valid backups of the database.C、It checks the database for both intrablock and interblock corruptions.D、It checks for only those corrupted blocks that are associated with data files.

Examine the following statement that is used to modify the constraint on the SALES table: SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE; Which three statements are true regarding the above command()A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint, but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A、 You do not need to restore all the data files.B、 You do not need to open the database with the RESETLOGS operationC、 You do not need to perform a full backup after the RESETLOGS operation.D、 You do not need to recover all the data files to the same system change number (SCN).

单选题You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.

单选题Which statement is true regarding RMAN components?()AEach target database requires its own recover catalog. BRMAN scripts can be stored in the recovery catalog or the target control file. CA channel is a stream of data to a device type and corresponds to one server session. DThe RMAN executable interprets sever session commands and establishes connections to the target database.

多选题You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()AEvery SQL statement in the STS is considered only once for executionBThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsCThe execution plan and execution statistics are computed for each SQL statement in the STSDThe effects of DDL and DML are considered to produce the execution plan and execution statistics

单选题Which statement regarding the contents of the V$PARAMETER view is true?()Adisplays only the list of default valuesBdisplays only the list of all basic parametersCdisplays the currently in effect parameter valuesDdisplays only the list of all advanced parametersEdisplays the list of all the parameter files of a database

单选题In your database, UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true? ()AUndo data is retained until the next full database backup.BNo committed undo data will be overwritten for 10 minutes.CCommitted undo data will be kept forever if not overwritten within 600 seconds.DGuarantees that requested undo information are available until the instance is shut down.

单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()AYou can perform online whole database backups.BYou can performofflinewhole database backups.CYou cannot perform schema-level export/import operations.DYou can perform the backup of only the SYSTEM tablespace when the database is open.

单选题You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?()AThe instance would hang.BThe instance needs to be shut down.CThe instance would be in the open state.DThe instance would abort in such cases.EThe instance would be in the open and invalid state.FThe instance would in the open state, but all the background processes will be restarted.

多选题Which two statements are true about the RMAN validate database command?()AIt checks the database for intrablock corruptions.BIt can detect corrupt pfiles.CIt can detect corrupt spfiles.DIt checks the database for interblock corruptions.EIt can detect corrupt block change tracking files.

单选题Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?()A The RMAN backup fails because the TOOLS tablespace is read-onlyB The RMAN skips the backup of the tablespace because backup optimization is enabledC The RMAN makes backup because optimization can be enabled only for backups to diskD The RMAN makes the backup because no backup of the tablespace exists within the seven day window

单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A You do not need to restore all the data files.B You do not need to open the database with the RESETLOGS operationC You do not need to perform a full backup after the RESETLOGS operation.D You do not need to recover all the data files to the same system change number (SCN).

单选题Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement regarding the status of the database is true?()AThe database remains open.BThe database gets dismounted.CThe database becomes read only.DThe database instance gets aborted.EThe database gets shut down automatically.FThe status of the database depends on the status of the USERS tablespace.

单选题Which statement is true regarding synonyms?()ASynonyms can be created only for a table BSynonyms are used to reference only those tables that are owned by another user CA public synonym and a private synonym can exist with the same name for the same table DThe DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid

多选题You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario?()AThe database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.BRDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.CThe RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.DASM compatibility controls which features for the ASM will be enabled.

单选题Which statement is true regarding remote archive log file destinations?()AOnly two destinations per remote database can be specified.BDestination is an Oracle Net alias specified by using the SERVICE keyword.CThe REOPEN attribute must be used when using remote archive log file destinations.DThe service name is resolved by searching sqlnet.ora file for the remote database name.