최신Oracle database 10g:Administration I - 1Z0-042무료샘플문제

A. The shared pool size should be increased to accommodate the SQL statements.

B. The users should use bind variables instead of literals in the query.

C. Preparing indexes on the tables used in the SQL statements would improve the library cache performance.

D. The dictionary cache is consuming more space than the library cache.

A. the value of the UNDO_RETENTION parameter

B. the size of an undo block

C. the size of the redo log files

D. undo blocks generated per second

E. the size of the database buffer cache

A. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.

B. One audit record is created for every session when any user successfully drops a table owned by SCOTT.

C. One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

D. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.

E. One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.

A. On startup, SMON coordinates instance recovery.

B. On startup, use RMAN to perform instance recovery.

C. Uncommitted changes will be rolled back after the database is opened.

D. On startup, all the files will be synchronized and you get both committed and uncommitted data.

E. On startup, perform media recovery and then instance recovery.

F. On startup, CKPT coordinates instance recovery.

A. It specifies the base directory of Optimal Flexible Architecture (OFA).

B. It specifies the directory for database files, if not specified explicitly.

C. It specifies the directory containing the Oracle software.

D. It specifies the directory containing the Oracle-Managed Files.

A. a shareable table lock for the table containing the row

B. ROW SHARE lock for the row being updated

C. null lock on the table containing the row

D. shared row-exclusive lock for the row being updated

E. exclusive table-level lock for the table containing the row

F. null lock on the row being updated

G. ROW EXCLUSIVE lock for the row being updated

A. The snapshot retention period for the AWR was increased before the last task.

B. The STATISTICS_LEVEL initialization parameter was changed to BASIC and reset to TYPICAL before the last task.

C. The optimizer statistics was collected manually by using the DBMS_STATS package before the last task.

D. The optimizer statistics for few objects in the database were locked before the last task.

A. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

B. The user must be listed in the password file for the authentication.

C. The user must be granted the database administrator (DBA) privilege.

D. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant the webDba role to the user.

A. The database has to be opened with the resetlogs option after performing Flashback Query.

B. It helps in row-level recovery from user errors.

C. It fails when undo data pertaining to the transaction is overwritten.

D. It is generated by using the redo log files.

E. It can be performed to recover ALTER TABLE statements

A. HR can grant the privilege to JIM because HR is the owner of the view.

B. HR can grant the privilege to JIM but without GRANT OPTION.

C. HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

D. SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.

A. moved the indexes associated with the EMPLOYEES table to the same tablespace where the EMPLOYEES table exists

B. moved the EMPLOYEES table to another location in the same tablespace

C. moved the EMPLOYEES table in to a locally managed tablespace

D. reorganized the associated indexes for the EMPLOYEES table that were in an unusable state

E. analyzed the EMPLOYEES table to collect the current statistics

A. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

B. SCOTT has to reexecute the last command in the transaction after he commits the transaction.

C. The transaction in it is terminated after receiving the error and JIM can continue with his transaction.

D. It is terminated after receiving the error and JIM can continue with his transaction.

A. The shared pool size should be increased to accommodate the SQL statements.

B. The users should use bind variables instead of literals in the query.

C. Preparing indexes on the tables used in the SQL statements would improve the library cache performance.

D. The dictionary cache is consuming more space than the library cache.