Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 31:

  You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.

  In which three ways can you re-create the lost disk group and restore the data? (Choose three.)

  A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as input parameter and use RMAN to restore the data.
  B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
  C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
  D. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
  E. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
  B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
  C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
  E. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

• Question 32:

  You enabled an audit policy by issuing the following statements:

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

  For which database users and for which executions is the audit policy now active? Select two.

  A. SYS, SYSTEM
  B. SCOTT
  C. Only for successful executions
  D. Only for failed executions
  E. Both successful and failed executions
  A. SYS, SYSTEM
  E. Both successful and failed executions

  ---

  * The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

• Question 33:

  Examine the portion of this Active Session History (ASH) report that is marked with a red rectangle: Which two inferences can be drawn from the report?

  

  A. Sessions attempting to modify blocks images in the buffer cache are waiting while other sessions are reading the same block images.
  B. Sessions are waiting to find free buffers in the buffer cache.
  C. Sessions are waiting for writes of modified block images in the buffer cache to complete
  D. Sessions are attempting to read blocks images in the buffer cache are waiting while other sessions are reading the same block images.
  E. Sessions attempting to read blocks images in the buffer cache are waiting while other sessions are modifying the same block images.
  A. Sessions attempting to modify blocks images in the buffer cache are waiting while other sessions are reading the same block images.
  C. Sessions are waiting for writes of modified block images in the buffer cache to complete

• Question 34:

  Which three functions are performed by the SQL Tuning Advisor?

  A. Building and implementing SQL profiles
  B. Recommending the optimization of materialized views
  C. Checking query objects for missing and stale statistics
  D. Recommending bitmap, function-based, and B-tree indexes
  E. Recommending the restructuring of SQL queries that are using bad plans
  A. Building and implementing SQL profiles
  C. Checking query objects for missing and stale statistics
  E. Recommending the restructuring of SQL queries that are using bad plans

  ---

  The SQL Tuning Advisor takes one or more SQL statements as an input and invokes the Automatic Tuning Optimizer to perform SQL tuning on the statements. The output of the SQL Tuning Advisor is in the form of an advice or recommendations, along with a rationale for each recommendation and its expected benefit. The recommendation relates to collection of statistics on objects (C), creation of new indexes, restructuring of the SQL statement (E), or creation of a SQL profile (A). You can choose to accept the recommendation to complete the tuning of the SQL statements.

• Question 35:

  You Execute the Following command to create a password file in the database server: $ orapwd file = `+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12' Which two statements are true about the password file? (Choose two.)

  A. It records the usernames and passwords of users when granted the DBA role.
  B. It contains the usernames and passwords of users for whom auditing is enabled.
  C. Is used by Oracle to authenticate users for remote database administration.
  D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
  E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
  C. Is used by Oracle to authenticate users for remote database administration.
  E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

• Question 36:

  You configured the Fast Recovery Area (FRA) for your database, which is in ARCHIVELOG mode.

  The default location for the archived log files is the Fast Recovery Area.

  There are no guaranteed restore points defined in the database.

  Which two file types are removed automatically based on RMAN retention policy settings, if there is pressure for space in the FRA? (Choose two.)

  A. obsolete RMAN backups
  B. flashback log files
  C. user-managed backups of control files
  D. expired RMAN backups
  E. archived redo log duplexed to another destination but not yet backed up
  F. user-managed backups of data files
  B. flashback log files
  D. expired RMAN backups

• Question 37:

  You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advice given by the segment advisor? (Choose three.)

  A. It may advise the use of online table redefinition for tables in dictionary-managed tablespaces.
  B. It may advise the use of segment shrink for tables in dictionary-managed tablespaces it the no chained rows.
  C. It may advise the use of online table redefinition for tables in locally managed tablespaces.
  D. It will detect and advise about chained rows.
  E. It may advise the use of segment shrink for freelist managed tables.
  A. It may advise the use of online table redefinition for tables in dictionary-managed tablespaces.
  C. It may advise the use of online table redefinition for tables in locally managed tablespaces.
  D. It will detect and advise about chained rows.

  ---

  http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm#CBBBIADA

• Question 38:

  On your Oracle 12c database, you invoked SQL*Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:

  $> sqlldr hr/hr@pdb table=employees

  Which two statements are true regarding the command? (Choose two.)

  A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
  B. It fails because no SQL *Loader data file location is specified.
  C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
  D. It fails because no SQL *Loader control file location is specified.
  A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
  C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

  ---

  Note:

  * SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.

• Question 39:

  Examine this command:

  SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false');

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

  A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
  B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
  C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
  D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
  E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
  C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
  D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
  E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

  ---

  *

  SET_TABLE_PREFS Procedure

  This procedure is used to set the statistics preferences of the specified table in the specified schema.

  *

  Example: Using Pending Statistics

  Assume many modifications have been made to the employees table since the last time statistics were gathered. To ensure that the cost-based optimizer is still picking the best plan, statistics should be gathered once again; however, the

  user is concerned that new statistics will cause the optimizer to choose bad plans when the current ones are acceptable. The user can do the following:

  EXEC DBMS_STATS.SET_TABLE_PREFS('hr', 'employees', 'PUBLISH', 'false');

  By setting the employees tables publish preference to FALSE, any statistics gather from now on will not be automatically published. The newly gathered statistics will be marked as pending.

• Question 40:

  Examine the following command:

  ALTER SYSTEM SET enable_ddl_logging = TRUE;

  Which statement is true?

  A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
  B. All DDL commands are logged in the alert log file.
  C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
  D. Only DDL commands that resulted in the creation of new segments are logged.
  E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
  C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

  ---

  The log files are created only in $ADR_HOME/log in alert log only alter system is catched.Sun Mar 30 23:30:04 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30 23:32:41 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30

  23:39:35 2014ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=BOTH;[oracle@ovs trace]$

  only in diag/rdbms/.../../log/ two files are capturing this. The xml file is capturing full details and text file having only the commands.

  [oracle@ovs log]$ pwd/oraclebase/diag/rdbms/ora12c1/ora12c1/log[oracle@ovs log]$ cat ddl/*

  create table testing2(a number)

  create table testing3( aa number)

  [oracle@ovs log]$ cat ddl_ora12c1.logSun Mar 30 23:33:26 2014diag_adl:create table testing2(a number)diag_adl:create table testing3( aa number)

  Reference: https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302