单项选择题You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file:  DB_BLOCK_CHECKING = TRUE;  What will be the result of setting this parameter?()

A. Only data blocks of the SYSTEM tablespace will be checked.
B. Only data blocks of the SYSAUX tablespace will be checked.
C. A checksum will occur only on the checkpoint.
D. A checksum will occur every time a block is modified.


您可能感兴趣的试卷

你可能感兴趣的试题

3.单项选择题What will be the result of using the SQL> DROP USER SCOTT CASCADE; command?()

A. The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and the objects that are  already in the Recycle Bin are dropped.
B. The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and all the objects in the Recycle Bin, belonging to the user Scott, are not dropped.
C. The user, Scott, is dropped, all the objects in the Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin, belonging to the user, Scott, are not dropped.
D. The user, Scott, is dropped, all the objects in Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin are dropped.

4.单项选择题

You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table: 
SQL> FLASHBACK TABLE ORDERS TO SCN 771513;  
What is the prerequisite to perform Flashback Table?()

A. You must configure OMF in your database.
B. You must enable block change tracking feature in your database.
C. You must enable ROW MOVEMENT feature on the ORDERS table.
D. You must use the Flashback Version Query before using the Flashback Table feature.

5.单项选择题

You are working as a DBA at NetFx Corporation. A user, Scott, is maintaining the records of all the employees in the EMPLOYEEtable. Initially, the salary of the employee, ’E0025’, was $1800. On 1 May 2004, the salary of the employee, ’E0025’, was increased by $200.  
The user, Scott, issued the following statement to modify the record of the employee, ’E0025’:  
SQL>UPDATE EMPLOYEE  SET SALARY = 2000  
WHERE EMPNO = ’E0025’;  
SQL>COMMIT;  
On December 1, 2004, the salary of the employee, ’E0025’, was increased by $400. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’:  
SQL>UPDATE EMPLOYEE  SET SALARY = 2400  
WHERE EMPNO = ’E0025’; 
 SQL>COMMIT;  
On July 1, 2005, the salary of the employee, ’E0025’, was increased by $500. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’  
SQL>UPDATE EMPLOYEE  SET SALARY = 2900  
WHERE EMPNO = ’E0025’;  
SQL>COMMIT;  
On July 5, 2005, the HR manager asked you to generate the increment report of the employee, ’E0025’, for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report?()

A. Flashback Drop
B. Flashback Table
C. Flashback Database
D.Flashback Version Query

9.单项选择题

You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace.  The following dependent objects have been defined on the dropped table:

  
  
Due to limited space, some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement: SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP;  
What will be the implication of executing this statement?()

A. Only the WAREHOUSE_DETAILS table is recovered, and none of the dependent objects are recovered.
B. The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints, primary key constraint, and the referential integrity constraints.
C. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.
D. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.

最新试题

You lost the index tablespace in your database. You are not able to use tablespace point­in­time recovery on the index tablespace. What could be the reason for this?()

题型:单项选择题

Your database operates in ARCHIVELOG mode. User­managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m. as follows: SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9:00 a.m. on the same table as follows: SQL> SELECT * FROM cust_ord;SELECT * FROM cust_ord* ERROR at line 1: ORA­00942: table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?()

题型:单项选择题

One of the tablespaces is read­only in your database. The loss of all control files forced you to re­create the control file. Which operation do you need to perform after re­creating the control file and opening the database?()

题型:单项选择题

In which case would you use the Flashback Database feature to perform a recovery?()

题型:单项选择题

In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: In what sequence would you use this process to perform the recovery?()

题型:单项选择题

For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()

题型:多项选择题

You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re­create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re­create the indexes?()

题型:多项选择题

On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use?()

题型:单项选择题

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?() 

题型:单项选择题

In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()

题型:多项选择题