Oracle Oracle Database Application Development 1Z0-062 Questions & Answers

• Question 1:

  A database runs in NOARCHIVELOG mode.

  Backup scheduling for this database must be automated before upgrading to a new version of the

  database.

  Which two tools or utilities can do this? (Choose two.)

  A. Oracle Enterprise Manager Database Express (EM Express)

  B. Database Upgrade Assistant (DBUA)

  C. SQL Developer

  D. Database Configuration Assistant (DBCA)

  E. Oracle Enterprise Manager Cloud Control

  Correct Answer: AB

• Question 2:

  Which three naming methods or connection types enable clients to connect to database instances successfully without client or server side configuration in sqlnet.ora or tnsnames.ora? (Choose three.)

  A. using the easy connect method from a remote terminal

  B. using CONNECT / AS SYSDBA from a local terminal

  C. using the easy connect method from a local terminal

  D. using the directory naming method from a remote terminal

  E. using the local naming method from a local terminal

  F. using CONNECT / AS SYSDBA from a remote terminal

  G. using the directory naming method from a local terminal

  Correct Answer: CEF

• Question 3:

  A database runs in ARCHIVELOG mode.

  Dally full database backups are taken with RMAN which is configured to perform control file autobackup.

  The control file and redo log files are multiplexed.

  In which two cases is media recovery required? (Choose two.)

  A. loss of a data file that belongs to the active undo tablespace

  B. physical corruption of data

  C. loss of one copy of the control file

  D. loss of one member of the active redo log group

  E. loss of all members of an inactive redo log group

  Correct Answer: CD

• Question 4:

  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

  Correct Answer: ACD

• Question 5:

  Examine this command which executes successfully:

  SQL> ALTER TABLE cities SHRINK SPACE;

  Which two are true? (Choose two.)

  A. The CITIES table has no CLOB columns.

  B. The CITIES table has no LONG columns.

  C. CITIES may be an Index Organized table (IOT).

  D. Row movement must have been enabled for CITIES.

  E. Row movement must have been enabled for CITIES.

  Correct Answer: CD

  Reference: https://docs.oracle.com/cd/E18283_01/server.112/e17120/schema003.htm

• Question 6:

  Examine this configuration for one of your databases:

  1.

  UNDO_RETENTION parameter is 1000

  2.

  retention is not guaranteed

  3.

  The undo tablespace is fixed size Which two statements are true? (Choose two.)

  A. Inactive undo is retained for at least 1000 seconds if free undo space is available.

  B. Active undo never becomes expired.

  C. Active undo is retained for only for 1000 seconds.

  D. Expired undo is retained for 1000 seconds even if transactions fail due to lack of space in the undo tablespace.

  E. Inactive undo is retained for 1000 seconds even if transactions fail due to lack of space in the undo tablespace.

  Correct Answer: CE

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm

• Question 7:

  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.

  Correct Answer: BC

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

• Question 8:

  You must upgrade your Oracle 11g to Database to Oracle 12c R2. Which method can you use?

  A. Perform a rolling upgrade.

  B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

  C. Use Enterprise Manager Express.

  D. Use SQL*Developer

  E. Use the Database Creation Assistant (DBCA) to upgrade

  Correct Answer: B

  Reference: https://oracle-base.com/articles/12c/upgrading-to-12c

• Question 9:

  You must create a table, DAILY_ORDERS, for a DSS application.

  Data should be compressed when using direct-path INSERT.

  The table will also be used for occasional DSS queries.

  Load performance is critical.

  Which compression option satisfies these requirements?

  A. COLUMN STORE COMPRESS FOR QUERY LOW

  B. COLUMN STORE COMPRESS FOR QUERY HIGH

  C. COLUMN STORE COMPRESS FOR ARCHIVE LOW

  D. ROW STORE COMPRESS ADVANCED

  E. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

  Correct Answer: D

• Question 10:

  Which three statements are true about the SQL Tuning Advisor? (Choose three.)

  A. It can get input from the Automatic Workload Repository (AWR).

  B. It can run while a maintenance window is open.

  C. It can recommend creation of SQL plan baselines.

  D. It can rebuild indexes.

  E. It prevents regression of SQL statement performance.

  F. It can get input from SQL Scripts in flat files.

  Correct Answer: ABE

  Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL543