A DBA can check specific tables with the DMU
The database to be migrated must be opened read-only.
The release of the database to be converted can be any release since 9.2.0.8.
The DMU can report columns that are too long in the converted characterset.
The DMU can report columns that are not represented in the converted characterset.
第1题:
Which three statements regarding the server parameter file (SPFILE) are true()
第2题:
Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()
第3题:
You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()
第4题:
Which statements regarding the server parameter file (SPFILE) are true()
第5题:
Which two statements are true regarding listeners()
第6题:
The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
第7题:
Listeners use only the TCP/IP protocol.
Multiple listener processes can run simultaneously on a host.
Multiple database instances can be registered with a single listener.
The listener-related errors can be traced only at the administrative level.
Only one database instance can be registered with a single listener at any time
第8题:
You cannot export data from a remote database.
You can rename tables during an import operation.
You can overwrite existing dump files during an export operation.
You can compress the data during export but not the metadata because it is not supported.
第9题:
An SPFILE is a binary file.
An SPFILE cannot reside on a client.
An SPFILE cannot contain static parameters.
An SPFILE can store changes persistently across instance restarts.
An SPFILE can be read by the database server, but it is not written to by the server.
An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database.
第10题:
The root container can be flashed back without flashing back the pluggable databases (PDBs).
To enable flashback database, the CDB must be mounted.
Individual PDBs can be flashed back without flashing back the entire cdb.
The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
第11题:
You cannot export data from a remote database.
You can rename tables during an import operation.
You can overwrite existing dump files during an export operation.
You can compress the data during export but not the metadata because it is not supported
第12题:
The database must have multiplexed redo logs for the flashback to succeed.
The database must be MOUNTED for the flashback to succeed.
The database must use block change tracking for the flashback to succeed.
The database must be opened in restricted mode for the flashback to succeed.
The database must be opened with the RESETLOGS option after the flashback is complete.
The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
第13题:
Which statements are true regarding listeners()
第14题:
Which three statements are true about using flashback database in a multitenant container database(CDB)?()
第15题:
Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true?()
第16题:
Which three statements are true concerning unplugging a pluggable database (PDB)?()
第17题:
Which three statements are true regarding the logical structure of the Oracle database?()
第18题:
An SPFILE is a binary file.
An SPFILE cannot reside on a client.
An SPFILE cannot contain static parameters.
An SPFILE can store changes persistently across instance restarts.
An SPFILE can be read by the database server, but it is not written to by the server.
An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database
第19题:
Each segment contains one or more extents.
Multiple tablespaces can share single data file.
A data block is the smallest unit of I/O for data files.
It is possible to have tablespaces of different block sizes in a database.
Each data block in the database always corresponds to one OS block.
第20题:
The destination must be global only.
A maximum of five destinations can be assigned.
A maximum of ten different destinations can be assigned.
All the destinations are determined by the server automatically.
The destination may be local or remote for a Standby Database.
The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
第21题:
The PDB must be open in read only mode.
The PDB must be dosed.
The unplugged PDB becomes a non-cdb.
The unplugged PDB can be plugged into the same multitenant container database (CDB)
The unplugged PDB can be plugged into another cdb.
The PDB data files are automatically removed from disk.
第22题:
Listeners use only the TCP/IP protocol.
Multiple listener processes can run simultaneously on a host.
Multiple database instances can be registered with a single listener.
The listener-related errors can be traced only at the administrative level.
Only one database instance can be registered with a single listener at any time.
第23题:
You have to shut down the database to perform the backups.
Archiving information is written to the data files and redo log files.
You can perform complete database backups without closing the database.
Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.