Online Access Free 1z1-497 Exam Questions

Which four items exist in the root of a CDB, but not in the PDBs?

• A.non-shared local metadata
• B.application tablespaces
• C.local temporary tablespaces
• D.CDB views providing information across PDBs
• E.local users and local roles
• F.shared UNDO and default database temporary tablespace
• G.Oracle-supplied metadata
• H.shared Oracle-supplied data

Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?

• A.The DML operations re-create the bitmap index blocks.
• B.The bitmap index is rebuilt automatically after a DML operation.
• C.The smallest amount of a bitmap that can be locked is a bitmap segment.
• D.Additional time is taken to remove NULL values from the bitmap index alter a DML operation.

Which two statements about PDBs and CDBs are true?

• A.There is only one SYSTEM tablespace per CDB.
• B.There is only one UNDO tablespace per CDB.
• C.There is a set of redo log files per PDB.
• D.There is only one instance per PD
• E.There is one SYSAUXtablespace per PDB.

Your database instance is down because there was a user-initiated shutdown. Which option represents the actions performed, in the correct order, if you start up the instance?
a - The control file is read.
b - Memory is allocated.
c - Background processes pre started.
d -The initialization parameter file is read,
e- Redo log files and data files are opened.

• A.b, c, a
• B.d, a, e
• C.a, e, d, b
• D.c, b, d, a, e
• E.d, b, c, a, e

You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?

• A.Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
• B.A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
• C.You should not install the Oracle Database software into an existing Oracle home from a different release.
• D.You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.
• E.Oracle recommends that you back up the root. sh script after you complete the installation.