1z0-062 Exam Training Practice Tests (Oracle Database 12c: Installation and Administration)]

Question 1

What is the outcome of the SHUTDOWN ABORT command?

A. Uncommitted transactions are rolled back B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively. C. Instance recovery must be requested by the DBA at the next startup D. Pending transactions are committed and the database is closed.

Correct Answer: B

Question 2

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 3

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

A. An SPFILE can be created from a PFILE or from memory. B. A PFILE can be used to start up a database instance even if an SPFILE exists. C. An SPFILE must reside in the ORACLE_HOME/dbs directory. D. An SPFILE can be created only before a database instance is started. E. An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance.

Correct Answer: A,B

Question 4

In your database, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:

Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)

A. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX. B. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL C. These users can never reuse a password D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.

Correct Answer: A,D

Question 5

A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:
1. The user account must be locked after five 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.
How would you accomplish this?

A. by granting a secure application role to the user B. by implementing Database Resource Manager C. by assigning a profile to the user D. by using Oracle Label Security options

Correct Answer: C

Question 6

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
(Choose three.)

A. A DBA can check specific tables with the DMU B. The DMU can report columns that are not represented in the converted characterset. C. The database to be migrated must be opened read-only. D. The release of the database to be converted can be any release since 9.2.0.8. E. The DMU can report columns that are too long in the converted characterset.

Correct Answer: A,B,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

Which statement is true about unified auditing?

A. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS. B. The unified audit trail contains audit records only from unified audit policies and AUDIT settings. C. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE. D. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 8

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c.
Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?

A. Enable real-time database operation monitoring using the
DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the
DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information. B. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view. C. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file. D. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 9

The HR schema exists in databases, BOSTON and DENVER, with the same password, HR.
You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.
DENVER is defined as a service name in the tnsnames.ora of both databases.
You plan to use this command:
CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING 'DENVER'; What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?

A. Change the command to create a public database link in DENVER. B. Execute the command as SYS in both databases. C. Execute the command as SYS in BOSTON. D. Execute the command as HR in BOSTON and SYS in DENVER. E. Execute the command as SYS in DENVER. F. Change the command to create a public database link in BOSTON.

Correct Answer: D

Question 10

Which two would you recommend to an application developer for reducing locking conflicts on tables in an Oracle database? (Choose two.)

A. Avoid coding long-running transactions. B. Enable undo retention guarantee. C. Allow the database to handle locks ln default locking mode. D. Create objects in locally managed tablespaces with manual segment space management enabled. E. Create objects in locally managed tablespaces with Automatic Segment Space Management (ASSM) enabled.

Correct Answer: A,C

Question 11

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 SELET ON hr.bonuses TO jim;
Which statement is true?

A. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM. B. HR can revoke the SELECT ON HR.BONUSES privilege from JIM. C. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM. D. JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them.

Correct Answer: A

Question 12

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

A. It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load. B. It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup. C. It automatically places each disk from an external redundancy diskgroup in its own failure group. D. It divides files into extents and allows an extent to span disks. E. It mounts databases and diskgroups to make ASM files available to database instances.

Correct Answer: A,C

Oracle Database 12c: Installation and Administration - 1z0-062 Exam Practice Test