网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()

  • A、A DBA can check specific tables with the DMU
  • B、The database to be migrated must be opened read-only.
  • C、The release of the database to be converted can be any release since 9.2.0.8.
  • D、The DMU can report columns that are too long in the converted characterset.
  • E、The DMU can report columns that are not represented in the converted characterset.

参考答案

更多 “Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()A、A DBA can check specific tables with the DMUB、The database to be migrated must be opened read-only.C、The release of the database to be converted can be any release since 9.2.0.8.D、The DMU can report columns that are too long in the converted characterset.E、The DMU can report columns that are not represented in the converted characterset.” 相关考题
考题 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?() A. The database must have multiplexed redo log filesB. The database must be in the MOUNT state to execute the commandC. The database must be in the NOMOUNT state to execute the commandD. The database must be opened in RESTRICTED mode before this operationE. The database must be opened with the RESETLOGS option after the flashback operation

考题 You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?() A. The database must have multiplexed redo logs for the flashback to succeed.B. The database must be MOUNTED for the flashback to succeed.C. The database must use block change tracking for the flashback to succeed.D. The database must be opened in restricted mode for the flashback to succeed.E. The database must be opened with the RESETLOGS option after the flashback is complete.F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

考题 Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?() A. A DBA can check specific tables with the DMUB. The database to be migrated must be opened read-only.C. The release of the database to be converted can be any release since 9.2.0.8.D. The DMU can report columns that are too long in the converted characterset.E. The DMU can report columns that are not represented in the converted characterset.

考题 Which three statements are true about using flashback database in a multitenant container database(CDB)?() A. The root container can be flashed back without flashing back the pluggable databases (PDBs).B. To enable flashback database, the CDB must be mounted.C. Individual PDBs can be flashed back without flashing back the entire cdb.D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

考题 Which three statements are true concerning unplugging a pluggable database (PDB)?() A. The PDB must be open in read only mode.B. The PDB must be dosed.C. The unplugged PDB becomes a non-cdb.D. The unplugged PDB can be plugged into the same multitenant container database (CDB)E. The unplugged PDB can be plugged into another cdb.F. The PDB data files are automatically removed from disk.

考题 Which two statements are true about the RMAN validate database command?()A、It checks the database for intrablock corruptions.B、It can detect corrupt pfiles.C、It can detect corrupt spfiles.D、It checks the database for interblock corruptions.E、It can detect corrupt block change tracking files.

考题 Which three statements regarding the server parameter file (SPFILE) are true()A、An SPFILE is a binary file.B、An SPFILE cannot reside on a client.C、An SPFILE cannot contain static parameters.D、An SPFILE can store changes persistently across instance restarts.E、An SPFILE can be read by the database server, but it is not written to by the server.F、An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database.

考题 Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario?()A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

考题 Which  statements are true regarding listeners()A、Listeners use only the TCP/IP protocol.B、Multiple listener processes can run simultaneously on a host.C、Multiple database instances can be registered with a single listener.D、The listener-related errors can be traced only at the administrative level.E、Only one database instance can be registered with a single listener at any time

考题 Which three statements are true about using flashback database in a multitenant container database(CDB)?()A、The root container can be flashed back without flashing back the pluggable databases (PDBs).B、To enable flashback database, the CDB must be mounted.C、Individual PDBs can be flashed back without flashing back the entire cdb.D、The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.E、A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

考题 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?()A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation

考题 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?()A、The destination must be global only.B、A maximum of five destinations can be assigned.C、A maximum of ten different destinations can be assigned.D、All the destinations are determined by the server automatically.E、The destination may be local or remote for a Standby Database.F、The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

考题 You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C、 The control file must be recreated.D、 The database must be opened with the RESETLOGS option.

考题 Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()A、You can perform online whole database backups.B、You can performofflinewhole database backups.C、You cannot perform schema-level export/import operations.D、You can perform the backup of only the SYSTEM tablespace when the database is open.

考题 Which  statements are true regarding the Oracle Data Pump export and import operations()A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported

考题 Which  statements regarding the server parameter file (SPFILE) are true()A、An SPFILE is a binary file.B、An SPFILE cannot reside on a client.C、An SPFILE cannot contain static parameters.D、An SPFILE can store changes persistently across instance restarts.E、An SPFILE can be read by the database server, but it is not written to by the server.F、An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database

考题 Which three statements are true concerning unplugging a pluggable database (PDB)?()A、The PDB must be open in read only mode.B、The PDB must be dosed.C、The unplugged PDB becomes a non-cdb.D、The unplugged PDB can be plugged into the same multitenant container database (CDB)E、The unplugged PDB can be plugged into another cdb.F、The PDB data files are automatically removed from disk.

考题 Which two statements are true regarding the Oracle Data Pump export and import operations()A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported.

考题 Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()A、Change in the Oracle Database versionB、Change in your network infrastructureC、Change in the hardware configuration of the database serverD、Migration of database storage from non-ASM to ASM storageE、Database and operating system upgrade

考题 Which two statements are true regarding listeners()A、Listeners use only the TCP/IP protocol.B、Multiple listener processes can run simultaneously on a host.C、Multiple database instances can be registered with a single listener.D、The listener-related errors can be traced only at the administrative level.E、Only one database instance can be registered with a single listener at any time.

考题 Which three statements are true regarding the logical structure of the Oracle database?()A、Each segment contains one or more extents.B、Multiple tablespaces can share single data file.C、A data block is the smallest unit of I/O for data files.D、It is possible to have tablespaces of different block sizes in a database.E、Each data block in the database always corresponds to one OS block.

考题 多选题Which  statements regarding the server parameter file (SPFILE) are true()AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server, but it is not written to by the server.FAn SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database

考题 多选题Which three statements are true regarding the logical structure of the Oracle database?()AEach segment contains one or more extents.BMultiple tablespaces can share single data file.CA data block is the smallest unit of I/O for data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one OS block.

考题 多选题Which three statements regarding the server parameter file (SPFILE) are true()AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server, but it is not written to by the server.FAn SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database.

考题 多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.

考题 多选题Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()AA DBA can check specific tables with the DMUBThe database to be migrated must be opened read-only.CThe release of the database to be converted can be any release since 9.2.0.8.DThe DMU can report columns that are too long in the converted characterset.EThe DMU can report columns that are not represented in the converted characterset.

考题 多选题Which two statements are true regarding the database in ARCHIVELOG mode?()AYou have to shut down the database to perform the backups.BArchiving information is written to the data files and redo log files.CYou can perform complete database backups without closing the database.DOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.EAll the previous database backups become invalid after you configure the database to ARCHIVELOG mode.