Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 91:

  Which command is used to display files that no longer conform to the backup retention policy?

  A. CROSSCHECK BACKUP
  B. SHOW DATAFILE BACKUP COPIES
  C. LIST EXPIRED BACKUP
  D. REPORT OBSOLETE
  B. SHOW DATAFILE BACKUP COPIES

• Question 92:

  The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:

  

  Which statement is true after HR issues the REVOKE command?

  A. The command fails because SCOTT still has privileges.
  B. The command succeeds and privileges are revoked from JIM.
  C. The command fails because HR cannot revoke the privileges from JIM.
  D. The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.
  C. The command fails because HR cannot revoke the privileges from JIM.

• Question 93:

  You executed the following commands to find the location of the alert log file:

  

  Where is the alert log file stored? (Choose all that apply.)

  A. in the BACKGROUND_DUMP_DEST location; in text format
  B. in the BACKGROUND_DUMP_DEST location; in XML format
  C. in the BACKGROUND_DUMP_DEST location; in both text and XML format
  D. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format
  E. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format
  F. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format
  A. in the BACKGROUND_DUMP_DEST location; in text format
  E. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format

• Question 94:

  Note the following points describing various utilities in Oracle Database 11g:

  1.

  It enables the high-speed transfer of data from one database to another

  2.

  It provides a complete solution for the backup, restoration and recovery needs of the entire database

  3.

  It enables the loading of data from an external file into table of an Oracle Database

  4.

  It provides a tape backup management for the Oracle ecosystem Which point describes Oracle Secure Backup?

  A. 1
  B. 2
  C. 3
  D. 4
  E. 1,2 and 4
  F. 1,2,3, and 4
  D. 4

• Question 95:

  You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:

  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;

  Which two statements are true about the effect of the command? (Choose two.)

  A. No flashback is possible to bring back the ITEM table.
  B. The ORDERS table is dropped along with the ITEM table.
  C. The dependent referential integrity constraints in the ORDERS table are disabled.
  D. The dependent referential integrity constraints in the ORDERS table are removed.
  E. The table definition of the ITEM table and associated indexes are placed in the recycle bin.
  A. No flashback is possible to bring back the ITEM table.
  D. The dependent referential integrity constraints in the ORDERS table are removed.

• Question 96:

  View the Exhibit to examine the output for the CROSSCHECK BACKUP command.

  

  Which statement is true about the output of the command?

  A. The backup piece is expired as the new backup is available
  B. The backup piece is expired because the operating-system file was not found
  C. The backup piece is expired because the retention period for the backup has expired
  D. The backup piece is expired because the backup set to which it belongs is not complete
  B. The backup piece is expired because the operating-system file was not found

• Question 97:

  The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server: Which statement is true regarding the archived redo log files?

  

  A. It will be created on the local file system.
  B. It will be created only in the Flash Recovery Area.
  C. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs.
  D. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter.
  A. It will be created on the local file system.

• Question 98:

  Which two are true about the Data Recovery Advisor? (Choose two.)

  A. It can be used when a database IS MOUNTED
  B. It can be used when a database IS OPEN
  C. It can be used only with databases that are running in ARCHIVELOG mode
  D. It can repair only databases for which RMAN backups exist
  E. It can be used to take RMAN backups
  F. It can be used to validate RMAN backups
  D. It can repair only databases for which RMAN backups exist
  F. It can be used to validate RMAN backups

• Question 99:

  View the Exhibit.

  

  You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB. Which configuration could have enabled the block selection of 16 KB?

  A. Choosing the extent allocation type to uniform
  B. Choosing the Segment Space Management option to manual
  C. Setting autoextension on for the data file mentioned for the tablespace
  D. Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
  D. Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

• Question 100:

  Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the

  following command:

  SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

  Which statement is true in this scenario?

  A. The minimum memory size for the database buffer cache is set to 100 MB.
  B. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.
  C. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.
  D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.
  A. The minimum memory size for the database buffer cache is set to 100 MB.