Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 301:

  Your database is open and the listener LISTENER is up. You issue the command:

  LSNRCTL> RELOAD

  What is the effect of reload on sessions that were originally established by listener?

  A. Only sessions based on static listener registrations are disconnected.
  B. Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.
  C. The sessions are not affected and continue to function normally.
  D. All the sessions are terminated and active transactions are rolled back.
  C. The sessions are not affected and continue to function normally.

• Question 302:

  On your Oracle 12c database, you Issue the following commands to create indexes

  SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;

  SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);

  Which two statements are correct? (Choose two.)

  A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
  B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
  C. Only the ORD_CUSTOMER_IX1 index is created.
  D. Only the ORD_CUSTOMER_IX2 index is created.
  E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
  A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
  E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

  ---

  11G has a new feature called Invisible Indexes. An invisible index is invisible to the optimizer as default. Using this feature we can test a new index without effecting the execution plans of the existing sql statements or we can test the effect of dropping an index without dropping it.

• Question 303:

  SMD is a bigfile tablespace.

  The SH user receives this error while inserting data into the non-partitioned SALES table:

  ERROR at line 1:

  ORA-01653: unable to extend table SH.SALES by 128 in tablespace SMD.

  Which three actions could correct the problem? (Choose three.)

  A. shrinking segments in the SMD tablespace
  B. adding a data file to the SMD tablespace
  C. increasing the space quota for user SH on the SMD tablespace
  D. setting the SMD tablespace datafile to autoextend
  E. adding new rows for the table segment in a different tablespace
  A. shrinking segments in the SMD tablespace
  C. increasing the space quota for user SH on the SMD tablespace
  D. setting the SMD tablespace datafile to autoextend

• Question 304:

  Identify three situations in which messages are written to the alert log file. (Choose three.)

  A. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block # 50)"
  B. Creating a table returns "ORA-00955: name is already in used by an existing object"
  C. Inserting a value into a table returns "ORA-01722: invalid number"
  D. Updating a record in a table returns "ORA-00060: deadlock detected while waiting for resource"
  E. Inserting a value into a table returns "ORA-00001: unique constraint (SYS.PK_XXXX) violated"
  F. Running a query on a table returns "ORA-01578: ORACLE data block corrupted (file # 4, block # 131)"
  A. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block # 50)"
  D. Updating a record in a table returns "ORA-00060: deadlock detected while waiting for resource"
  F. Running a query on a table returns "ORA-01578: ORACLE data block corrupted (file # 4, block # 131)"

• Question 305:

  Examine these statements: Which two are true about the result and effects of executing these commands? (Choose two.)

  

  A. CREATE SESSION is only revoked from role DEV1.
  B. CREATE SESSION is only revoked from user JOHN.
  C. User JOHN is not permitted to connect to the database.
  D. User JOHN is permitted to connect to the database.
  E. CREATE SESSION is revoked from both the role DEV1 and JOHN.
  A. CREATE SESSION is only revoked from role DEV1.
  D. User JOHN is permitted to connect to the database.

• Question 306:

  Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

  A. You cannot specify how partitioned tables should be handled during an import operation.
  B. Only data can be compressed during an export operation.
  C. Existing dump files can be overwritten during an export operation.
  D. Tables cannot be renamed during an import operation.
  E. Metadata that is exported and imported can be filtered based on objects and object types.
  A. You cannot specify how partitioned tables should be handled during an import operation.
  E. Metadata that is exported and imported can be filtered based on objects and object types.

  ---

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28300/expimp.htm#UPGRD12560

• Question 307:

  Which two can be used to create and populate a table from the contents of a textual flat file? (Choose two.)

  A. Use CREATE TABLE ... AS SELECT from an ORACLE LOADER type external table.
  B. Use SQL*LOADER conventional path load.
  C. Use SQL*LOADER direct path load.
  D. Use DATAPUMP import.
  E. Use CREATE TABLE ... AS SELECT from an ORACLE DATAPUMP type external table.
  B. Use SQL*LOADER conventional path load.
  C. Use SQL*LOADER direct path load.

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_concepts.htm

• Question 308:

  You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.

  The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.

  What must you do first in this situation to attempt to fix this problem?

  A. Run catuppst.sql to perform revalidation actions
  B. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.
  C. Run preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues.
  D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.
  D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

• Question 309:

  Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  A. It calls SQL advisors automatically if required.
  B. It provides recommendations only for poorly performing SQL statements.
  C. Its results are stored in AWR.
  D. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.
  E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.
  C. Its results are stored in AWR.
  E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.

• Question 310:

  Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

  A. execution of SQL statements by users connected with the SYSDBA privilege
  B. creation of a fine-grained audit policy
  C. configuration of unified auditing mode
  D. usage of the AUDIT statement
  A. execution of SQL statements by users connected with the SYSDBA privilege

  ---

  References: https://docs.oracle.com/cd/B28359_01/network.111/b28531/auditing.htm#DBSEG0622