Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 51:

  A database is open READ WRITE and the instance has multiple sessions some of which have active

  transactions.

  You execute this command:

  SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

  Which three are true about the active transactions? (Choose three.)

  A. They may issue COMMIT or ROLLBACK statements

  B. They are suspended and unable to issue any statements

  C. They may continue to issue DML statements

  D. They are rolled back automatically

  E. They may continue to issue queries

  F. They are terminated immediately

  Correct Answer: BDF

• Question 52:

  Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)

  A. A port number for Oracle HTTP Server must be configured

  B. The APEX_PUBLIC_USER role must be granted to SYSMAN

  C. A SYSMAN user with SYSDBA privilege must be created

  D. At least one TCP/IP dispatcher must be configured

  E. The Oracle HTTP Server must be installed

  Correct Answer: BD

• Question 53:

  Which four statements are true about database instance behavior? (Choose four.)

  A. An idle instance is created when a STARTUP NOMOUNT is successful

  B. All dynamic performance views (v$ views) return data when queried from a session connected to an instance in NOMOUNT state

  C. The consistency of redo logs and data files is checked when mounting the database

  D. Redo log files can be renamed in MOUNT state

  E. An SPFILE can be updated when connected to an idle instance

  F. Datafiles can be renamed in MOUNT state

  Correct Answer: CDEF

• Question 54:

  Which three statements are true PFILEs, SPFILEs or both? (Choose three.)

  A. SPFILEs and PFILEs may both be edited with an O/S editing utility

  B. Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause

  C. A SPFILE can be created by an idle instance

  D. A PFILE can be created by an idle instance

  E. All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause

  F. All SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause

  Correct Answer: BDE

• Question 55:

  Examine this command:

  SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;

  Which two statements are true? (Choose two.)

  A. All data definition language (DDL) statements are written to the control file

  B. Some DDL statements are written to an XML file in the ADR home

  C. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home

  D. Some data definition language (DDL) statements are written to the control file

  E. Some DDL statements are written to a text file in the ADR home

  F. The Alert Log still contains some DDL statements

  Correct Answer: DE

• Question 56:

  Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

  A. It loads data faster than conventional SQL*Loader

  B. No data file needs to be specified

  C. It can load data in parallel

  D. It loads data more efficiently than conventional SQL*Loader

  E. It requires Enterprise Manager Express to be configured

  Correct Answer: AC

  Reference: https://www.oracle.com/technetwork/database/enterprise-edition/learnmore/sqlldr-expressmode-wp-1991038.pdf

• Question 57:

  Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? (Choose two.)

  A. Dynamic Registration by the LREG process

  B. Dynamic Registration by the SMON process

  C. Static registration in the listener.ora file using the GLOBAL_DBNAME parameter

  D. Dynamic Registration by the PMON process

  E. Static registration in the listener.ora file using the SERVICE_NAME parameter

  Correct Answer: AE

  Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG298

• Question 58:

  DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.

  

  Which two are true? (Choose two.)

  A. 80% of every data block in daily_ords_list is reserved for row inserts

  B. 20% of each data block in the table is reserved for row updates

  C. PCTFREE can help to minimize row chaining during inserts

  D. PCTFREE can help reduce row migration during updates

  E. PCTFREE eliminates row chaining during inserts

  Correct Answer: BD

• Question 59:

  You ran this command on a source database:

  $> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept

  On the target database, you run this command:

  $> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept

  Which two statements are true? (Choose two.)

  A. The expdp operation exports all rows for tables contained in the defining query of the EMP_DEPT view

  B. The impdp operation creates separate tables for each table contained in the defining query of the EMP_DEPT view

  C. The expdp operation exports all rows that are displayed when querying the EMP_DEPT view with no filter

  D. The impdp operation creates EMP_DEPT as a table

  E. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view.

  F. The impdp operation creates EMP_DEPT as a view

  Correct Answer: DE

• Question 60:

  One of your databases has archive logging enabled and RMAN backups are taken at regular intervals.

  The data file for the USERS tablespace is corrupt.

  Which command must you execute before starting the recovery of this tablespace?

  A. STARTUP FORCE

  B. ALTER TABLESPACE users OFFLINE IMMEDIATE;

  C. SWITCH DATAFILE ALL;

  D. ALTER TABLESPACE users OFFLINE NORMAL;

  E. ALTER TABLESPACE users OFFLINE TEMPORARY;

  Correct Answer: E