Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 221:

  Which two are true about Optimizer Statistics? (Choose two.)

  A. They are automatically updated when DDL statements execute
  B. They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package
  C. They are gathered by the Manageability Monitor (MMON) background process
  D. They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements
  E. They can be used to determine the events on which a database instance waited
  F. They do not persist across instance restarts
  B. They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package
  D. They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements

• Question 222:

  Which three operations require undo data? (Choose three.)

  A. Committing a transaction
  B. Flashing back a transaction
  C. Recovering a failed transaction
  D. Running a read-consistent query
  E. Changing a tablespace status from READ ONLY to READ WRITE
  B. Flashing back a transaction
  C. Recovering a failed transaction
  D. Running a read-consistent query

• Question 223:

  Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?

  A. Run the root.sh script.
  B. Create the oraInst.loc file.
  C. Create the tnsnames.ora file.
  D. Run the oraInstRoot.sh script.
  B. Create the oraInst.loc file.

• Question 224:

  You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to

  accomplish the task in random order:

  1) Shut down the instance.

  2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.

  3) Execute the ALTER DATABASE FLASHBACK OFF command.

  4) Start up the instance and mount the database.

  5) Execute the ALTER DATABASE FLASHBACK ON command.

  6) Open the database.

  Select the correct order in which these tasks need to be performed.

  A. 2, 1, 4, 3, 5, 6
  B. 1, 4, 3, 2, 6, 5
  C. 1, 4, 2, 6, 3, 5
  D. 3, 2, 1, 4, 5, 6
  A. 2, 1, 4, 3, 5, 6

• Question 225:

  You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this. Which data types would you use for the new column?

  A. CLOB
  B. BLOB
  C. BFILE
  D. LONG RAW
  C. BFILE

• Question 226:

  Your DB_RECOVERY_FILE_DEST_SIZE is 8G.

  Currently, 5G of the space is used of which 4G consists of obsolete backups.

  You execute this command:

  SQL> ALTER SYSTEM SET db_recovery_fle_dest_size=2G;

  What is the outcome?

  A. It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletes the obsolete backups.
  B. It changes DB_RECOVERY_FILE_DEST_SIZE to 5G.
  C. It fails because DB_RECOVERY_FILE_DEST_SIZE is a static parameter.
  D. It fails because the new size is less than 5G.
  E. It changes DB_RECOVERY_FILE_DEST_SIZE to 2G without deleting valid backups.
  E. It changes DB_RECOVERY_FILE_DEST_SIZE to 2G without deleting valid backups.

• Question 227:

  Your database is configured in archivelog mode.

  The USERS01 tablespace is currently online.

  You are required to take the tablespace offline.

  Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?

  A. either the NORMAL or the IMMEDIATE clause
  B. only the IMMEDIATE clause
  C. either the NORMAL or the TEMPORARY clause
  D. only the TEMPORARY clause
  E. only the NORMAL clause
  D. only the TEMPORARY clause

• Question 228:

  You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information. The employees submit the expense reports to the accounts payable department. A user of the accounts payable database wants to extract the employee information from the database in the SEMP server for crossverification.

  Which schema object enables the user to access the information from the remote database?

  A. Cluster
  B. Database link
  C. Mapping table
  D. Materialized view
  B. Database link

• Question 229:

  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 230:

  Which of these is true about undo tablespace?

  A. Undo tablespace is a temporary tablespace
  B. Undo tablespace has only one datafile
  C. Undotablespace has a datafile which is reused in cyclic manner
  A. Undo tablespace is a temporary tablespace