2022 Updated Verified Pass 1z0-062 Study Guides & Best Courses [Q175-Q198]

Q175. Examine these two statements:

Which three are true about the MRKT tablespace?

Q176. You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
– Version: Oracle Database 12c Releases 1 64-bit
– Character set: WE8ISO8859P15
– National character set: AL16UTF16
– O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
– Version: Oracle Database 12c Release 1 64-bit
– Character set: AL32UTF8
– O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

Q177. Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)

Q178. Which two statements are true about initialization parameter files? (Choose two.)

Q179. Which two statements are true about the Oracle Direct Network File system (DNFS)?
(Choose two.)

Q180. You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?

Q181. Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

Q182. Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

Q183. You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
– Applications will connect to the database via a middle tier.
– The number of concurrent user connections will be high.
– The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?

Q184. You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB.
You execute the following command on the PRODDB database server:

What should you do to resolve the error?

Q185. Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:

And then grant OPS$GUEST_USERthe CREATE SESSIONprivilege.
Which two statements are true? (Choose two.)

Q186. Which component resides in the System Global Area (SGA) of a database instance only in shared server
connections?

Q187. What is the effect of specifying the “ENABLE PLUGGABLE DATABASE” clause in a
“CREATE DATABASE” statement?

Q188. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
(Choose two.)

Q189. You want to prevent a group of users in your database from performing long-running transactions that consume huge
amounts of space in the undo tablespace. If the quota for these users is exceeded during execution of a data
manipulation language (DML) statement, the operation should abort and return an error. However, queries should
still be allowed, even if users have exceeded the undo space limitation.
How would you achieve this?

Q190. You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During
this operation, you want to ensure the following:
-Long-running queries are not affected.
-No extra space is used.
-Data manipulation language (DML) operations on the table succeed at all times throughout the process.
-Unused space is reclaimed both above and below the high water mark.
Which ALTER TABLE option would you recommend?

Q191. Your database is configured in ARCHIVELOGmode, and a daily full database backup is taken by using
RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)

Q192. You want to reduce fragmentation and reclaim unused space for the SALEStable but not its dependent objects.
During this operation, you want to ensure the following:
– Long-running queries are not affected.
– No extra space is used.
– Data manipulation language (DML) operations on the table succeed at all times throughout the process.
– Unused space is reclaimed both above and below the high water mark.
Which ALTER TABLEoption would you recommend?

Q193. DAILY_ORDS_LSTis created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.

Which two are true? (Choose two.)

Q194. Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:
$ make -fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
Which two steps should you perform before executing this command? (Choose two.)

Q195. In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute
the following commands in the root container:

Which two statements are true? (Choose two.)

Q196. Examine the details of the uncompressed, non-partitioned heap table CITIES.

Examine the command:
SQL> ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?

Q197. Which two statements are true about standard database auditing? (Choose two.)

Q198. In which situations does the Database Writer process (DBWn) write to data files? (choose two).