1z1-497 無料問題集「Oracle Database 12c Essentials」

（A）The database is mounted but not opened.

（B）The database is opened and finally mounted.

（C）Nothing else happens.

（D）The database is mounted and finally opened.

（A）Oracle Data Guard monitor

（B）Oracle Data Guard Broker Manager

（C）Oracle Enterprise Manager Cloud Control

（D）Oracle Data Guard command-line interface (DGMGRL)

（A）ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements

（B）ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword

（C）D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements

（D）ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword

（A）Row-level security

（B）Database vault

（C）Index

（D）Triggers

（E）Partitioning

（A）SGA contains shared memory structures for all Oracle processes running on a single server.

（B）SGA is allocated automatically when a database is mounted.

（C）Each server process has its own SGA.

（D）SGA is allocated automatically when a database is started.

（E）SGA is read and written by server and background processes.

（F）SGA is used to speed up queries by caching data blocks, program data, information about database objects, and query results

（A）Moving a data file online can be performed if the data file is in OFFLINE mode.

（B）Flashing back a database to a point in time before a data file had been renamed online retains the new name.

（C）Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.

（D）Moving a data file online prevents DML operations on segments stored in the data file.

（A）Oracle recommends that you back up the root. sh script after you complete the installation.

（B）You should not install the Oracle Database software into an existing Oracle home from a different release.

（C）A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.

（D）You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

（E）Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.

（A）In a newly created non-CDB that does not yet contain user data, the data dictionary contains only system metadata. When application users create their own objects, this metadata is mixed with the system metadata. In a CDB, the data dictionary metadata is split between the root and the PDBs. The data dictionary in the PDB contains pointers to the data dictionary in the root.

（B）A container database has exactly one seed PDB, and a non-container database has no seed PDB.

（C）You are allowed to create only a single HR user in a non-CDB database. This restriction is identical for a CDB database.

（D）New views are introduced. Next to DBA_views, AIL_-views, and USER_-views, there are CDB_-views. Both CDB and non-CDB databases can access this information.

（E）Every PDB in a CDB has its own control file. A non-CDB, which has no containers, needs only one control file.

（A）The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.

（B）The root is opened.

（C）The PDBs are mounted.

（D）The CDB control files are opened for the instance.

（E）The instance is started.

（F）The root is mounted.

（G）The PDBs are mounted, and the seed is opened in READ ONLY mode.

（A）In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.

（B）Consolidating separate databases into a single CDB requires the same amount of storage allocation.

（C）You can consolidate shared database memory by combining multiple PDBs in a single CD

（D）You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.

（E）Patching individual PDBs requires the same amount of time as patching individual databases.