Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 81:

  USER1 grants SELECT, INSERT, and UPDATE privileges on USER1, EMP to USER2.

  SYS executes this command:

  SQL>REVOKE UPDATE ON user1.emp FROM user1;

  What will be the outcome?

  A. It will succeed and only USER1 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP
  B. It will succeed and only USER2 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP
  C. It will fail because USER1 is the owner of USER1.EMP
  D. It will succeed but neither USER1 nor USER2 will be able to perform SELECT, INSERT, or UPDATE on USER1.EMP
  E. It will succeed and neither USER1 nor USER2 will be able to perform INSERT or UPDATE on USER1.EMP, but both will be able to query USER1.EMP
  C. It will fail because USER1 is the owner of USER1.EMP

• Question 82:

  Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future. What action would you take to achieve this task?

  A. Insert finding directives for ADDM tasks in the future.
  B. Create a baseline on a pair of snapshots spanning the peak-load period.
  C. Decrease the snapshot interval in the AWR to collect more snapshots during the peakload period.
  D. Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.
  B. Create a baseline on a pair of snapshots spanning the peak-load period.

• Question 83:

  You executed the following commands in an RMAN session for your database instance that has failures:

  RMAN> LIST FAILURE;

  After some time, you executed the following command in the same session:

  RMAN> ADVISE FAILURE;

  But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

  A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
  B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
  C. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
  D. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
  A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

• Question 84:

  Which three are true about auditing? (Choose three.)

  A. DDL statements can be audited when they fail to execute.
  B. Audit of the use of system privileges can be enabled for individual database users.
  C. Auditing is active only when the database is OPEN.
  D. All Oracle auditing operations occur by default.
  E. Audit records are always stored in the database.
  F. DML statements can be audited when they execute successfully.
  B. Audit of the use of system privileges can be enabled for individual database users.
  E. Audit records are always stored in the database.
  F. DML statements can be audited when they execute successfully.

• Question 85:

  Which four are true about transaction, table, and row locks in an Oracle Database? (Choose four.)

  A. Transaction locks are released when that transaction executes a COMMIT statement
  B. DML statements lock modified tables in exclusive mode
  C. Transaction locks are released when that transaction executes a ROLLBACK statement
  D. DDL statements never lock the objects that they modify
  E. A table's row-level locks escalate to table locks when a majority of rows in that table are locked in exclusive mode
  F. SELECT statements are never blocked by row-level locks
  G. DML statements lock modified rows in exclusive mode
  B. DML statements lock modified tables in exclusive mode
  C. Transaction locks are released when that transaction executes a ROLLBACK statement
  F. SELECT statements are never blocked by row-level locks
  G. DML statements lock modified rows in exclusive mode

• Question 86:

  Which two events always cause the LGWR to write? (Choose two.)

  A. when a checkpoint occurs
  B. when DBWn writes dirty buffers
  C. when LGWR is notified by a server process that performs a COMMIT OR ROLLBACK
  D. when a log switch occurs
  E. when PMON restarts a server process
  A. when a checkpoint occurs
  D. when a log switch occurs

• Question 87:

  You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.)

  A. You must shut down the database instance to perform the backups.
  B. You must configure the Flash Recovery Area (FRA) for the database.
  C. You can perform complete database backups without closing the database.
  D. All the previous closed database backups including control files become invalid afteryou configure the database to ARCHIVELOG mode.
  C. You can perform complete database backups without closing the database.
  D. All the previous closed database backups including control files become invalid afteryou configure the database to ARCHIVELOG mode.

• Question 88:

  Evaluate the following code:

  

  Which naming method creates the above code?

  A. Local naming
  B. External naming
  C. Directory naming
  D. Easy connect naming
  A. Local naming

• Question 89:

  Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to `/u01/oracle/db01'. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, are not specified. Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.)

  A. RMAN backups
  B. data files
  C. archived redo logs
  D. temp files
  E. control files
  F. audit logs
  G. audit files
  H. redo logs
  B. data files
  E. control files
  F. audit logs
  H. redo logs

• Question 90:

  Which two are true about data dictionary views? (Choose two.)

  A. DBA prefixed views are accessible when a database is in mount state
  B. A user can query the DBA prefixed with DBA or ALL or USER
  C. All data dictionary views are prefixed with DBA or ALL or USER
  D. A user may not necessarily be the owner of all objects that can be viewed by using the ALL prefixed views
  E. ALL or USER prefixed views display output that are subsets of the output from the DBA prefixed data views
  C. All data dictionary views are prefixed with DBA or ALL or USER
  D. A user may not necessarily be the owner of all objects that can be viewed by using the ALL prefixed views