Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 181:

  Which two statements are true about using SQL*Loader? (Choose two.)

  A. It can load data from external files by using the direct path only.

  B. It can load data into multiple tables using the same load statement.

  C. It can load data into only one table at a time.

  D. It can generate unique sequential key values in specified columns.

  E. It can load data from external files by using the conventional path only.

  Correct Answer: AC

• Question 182:

  The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command:

  SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;

  TOM then executes this command to grant privileges to the user JIM:

  SQL> GRANT SELECT ON hr.bonuses TO jim;

  Which statement is true?

  A. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.

  B. HR can revoke the SELECT ON HR.BONUSES privilege from JIM.

  C. JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them.

  D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.

  Correct Answer: D

• Question 183:

  Your database is running in NOARCHIVLOG mode. Examine the following parameters:

  

  You execute the following command after performing a STARTUP MOUNT:

  SQL> ALTER DATABASE ARCHIVELOG;

  Which statement is true about the execution of the command?

  A. It executes successfully and sets the Fast Recovery Area as the local archive destination.

  B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.

  C. It fails and returns an error about LOG_ARCHIVE_DEST not being set.

  D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.

  Correct Answer: A

• Question 184:

  Which set of statements is true about data dictionary views?

  1.

  They are stored in the SYSTEM tablespace.

  2.

  They are based on virtual tables.

  3.

  They are owned by the SYS user.

  4.

  They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.

  5.

  The V$FIXED_TABLE view can be queried to list the names of these views.

  6.

  They are owned by the SYSTEM user.

  A. 2, 5, and 6

  B. 1, 2, and 3

  C. 1 and 3

  D. 2, 3, 4, and 5

  Correct Answer: C

  References: https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT002

• Question 185:

  What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

  A. It provides a summary of the upgrade results.

  B. It recompiles all invalid PL/SQL and Java code.

  C. It generates a log file containing the fixes that can be made to the source database.

  D. It provides parallel upgrade options to finish the upgrade process with a reduced down time.

  E. It generates fix-up scripts to be run on the source database before upgrade.

  Correct Answer: D

  References: https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD52860

• Question 186:

  Which statement is true about redo log files during instance recovery?

  A. All current, online, and archived redo logs are required to complete instance recovery.

  B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.

  C. All redo log entries in the current log are applied to data files until the checkpoint position is reached.

  D. All current, active, and inactive redo logs are required to complete instance recovery.

  Correct Answer: C

  References: https://docs.oracle.com/cd/A58617_01/server.804/a58396/ch2.htm

• Question 187:

  A user establishes a connection to a database instance by using an Oracle Net.

  You want to ensure that:

  1.

  The user account must be locked after five consecutive unsuccessful login attempts.

  2.

  Data read per session must be limited for the user.

  3.

  The user cannot have more than three simultaneous sessions.

  4.

  The user must have a maximum of 10 minutes session idle time before being logged off automatically.

  Which two would you do to implement this? (Choose two.)

  A. by alerting the appropriate user attributes with an ALTER USER command

  B. by using appropriate PASSWORD parameters set in the profile assigned to the user

  C. by implementing Database Resource Manager and assign it a profile for the user

  D. by implementing Database Resource Manager and assign it a role for the user

  E. by using appropriate KERNEL parameters set in the profile assigned to the user

  Correct Answer: AD

• Question 188:

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

  A. The DEGREE_OF_PARALLELISM parameter is set to AUTO.

  B. You cannot have multiple SQL *Loader data files.

  C. If no data file is specified, it assumes the data file to be .dat in the current directory and uses it.

  D. You can have multiple bad files created when loading in parallel.

  E. You can selectively load rows into a table based on a filter.

  Correct Answer: AC

  References: https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D-8BF32312893A67D7.htm#SUTIL3951

• Question 189:

  You install "Oracle Grid Infrastructure for a standalone server" on a host on which the ORCL1 and ORCL2 databases both have their instances running.

  Which two statements are true? (Choose two.)

  A. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

  B. The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.

  C. Both ORCL1 and ORCL2 are automatically added to the Oracle Restart configuration.

  D. All database listeners running from the database home are automatically added to the Oracle Restart configuration.

  E. The crsctl start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.

  Correct Answer: BD

• Question 190:

  Which statement is true about unified auditing?

  A. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.

  B. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS.

  C. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE.

  D. The unified audit trail contains audit records only from unified audit policies and AUDIT settings.

  Correct Answer: A

  References: https://docs.oracle.com/database/121/DBSEG/audit_admin.htm#DBSEG370