1Z0-062 Online Practice Questions and Answers

To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:

SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.

Identify the reason the instance failed to start.

A. The PGA_AGGREGATE_TARGET parameter is set to zero.

B. The STATISTICS_LEVEL parameter is set to BASIC.

C. Both the SGA_TARGET and MEMORY_TARGET parameters are set.

D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

A. The PDB must be open in read-only mode.

B. The PDB must be in mount state.

C. The PDB must be unplugged.

D. The PDB data files are always removed from disk.

E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.

Which statement is true?

A. The ORACLE_BASE base parameter is not set.

B. The installation is being performed by the root user.

C. The operating system group that is specified should have the root user as its member.

D. The operating system group that is specified must have permission to write to the inventory directory.

You enabled an audit policy by issuing the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

For which database users and for which executions is the audit policy now active? Select two.

A. SYS, SYSTEM

B. SCOTT

C. Only for successful executions

D. Only for failed executions

E. Both successful and failed executions

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)

A. System privileges apply only to the PDB in which they are used.

B. Local users cannot use local system privileges on the schema of a common user.

C. The granter of system privileges must possess the set container privilege.

D. Common users connected to a PDB can exercise privileges across other PDBs.

E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM).

How would you achieve this?

A. by using a transportable database

B. by using the Database Upgrade Assistant (DBUA)

C. by using Data Pump

D. by using RMAN

In your database, USERS is the default permanent tablespace. Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)

A. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.

B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

C. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

D. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.

E. The MYTAB table is owned by the SYS user.

Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the

following command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

A. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.

B. It fails because DB_CACHE_SIZE is a static initialization parameter.

C. It fails because ASMM is enabled and individual SGA components cannot be sized.

D. It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next instance startup.

You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c.

Which three tasks should be performed before a manual upgrade? (Choose three.)

A. running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file

B. running utlu121s.sql from the new Oracle home to display information about the required initialization parameters

C. copying the initialization parameter file to the new Oracle home

D. copying the password file to the new Oracle home

E. copying net configuration files to the new Oracle home

Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

A. A schedule can be specified to a single job only.

B. A scheduler job can point to a chain instead of pointing to a single program object.

C. A job may get started automatically when a window opens.

D. A program and job can be specified as part of a schedule definition.

E. A job is specified as part of a program specification.

F. A program can be used in the definition of multiple jobs.

G. A program and schedule can be specified as part of a job definition.

You install Oracle Grid Infrastructure for a standalone server.

Which two components are automatically included in the Oracle Restart configuration? (Choose two.)

A. A pre-existing Oracle Net Listener

B. Oracle Notification services

C. A pre-existing database

D. A pre-existing Oracle management agent

E. Oracle CSSD service

Examine the command: SQL> CONNECT hr/hr@orcl

Which two configurations allow this command to execute successfully? (Choose two.)

A. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name.

B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.

C. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.

D. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host.

E. The TNS_ADMIN environment variable should be set to orcl on the client.

Which statement is true regarding the DEFAULT profile?

A. The values assigned to the resource limits and password parameters in the default profile can be altered.

B. A different DEFAULT profile can be created before each user in a database.

C. It can be dropped and recreated.

D. it must be explicitly assigned to the user.

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)

A. backup pieces

B. copies of all parameter files

C. trace file generated using BACKUP CONTROLFILE TO TRACE

D. control file autobackups

An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is

uncommitted.

Which two types of lock are held by the transaction? (Choose two.)

A. a row level lock on the row being updated

B. a null lock on the row being updated

C. a row shared lock on the EMPLOYEES table

D. an exclusive lock on the EMPLOYEES table

E. a null lock on the EMPLOYEES table