itgle.com

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

题目

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.
相似考题

1.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

2.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.

3.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.

4.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”相关问题

  • 第1题：

    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.


    参考答案：B, D, E

  • 第2题：

    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.

    正确答案:A,B,D

  • 第3题：

    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

    正确答案:B,C

  • 第4题：

    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 files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第5题：

    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.

    正确答案:C

  • 第6题：

    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

    正确答案:B,C

  • 第7题：

    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.

    正确答案:B,D,E

  • 第8题：

    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 version
    • B、Change in your network infrastructure
    • C、Change in the hardware configuration of the database server
    • D、Migration of database storage from non-ASM to ASM storage
    • E、Database and operating system upgrade

    正确答案:A,C,E

  • 第9题：

    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.

    正确答案:A,C,D

  • 第10题：

    多选题
    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.


    正确答案： A,B
    解析： 暂无解析

  • 第11题：

    多选题
    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.


    正确答案： A,E
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements are true regarding the database in ARCHIVELOG mode？（）
    A

    You have to shut down the database to perform the backups.

    B

    Archiving information is written to the data files and redo log files.

    C

    You can perform complete database backups without closing the database.

    D

    Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

    E

    All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.


    正确答案： E,C
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:A,C

  • 第14题：

    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.

    正确答案:A,E

  • 第15题：

    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.

    正确答案:B,C,D

  • 第16题：

    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.

    正确答案:C,E

  • 第17题：

    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.

    正确答案:B

  • 第18题：

    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

    正确答案:A,B,D

  • 第19题：

    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.

    正确答案:B,C

  • 第20题：

    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.

    正确答案:B,C

  • 第21题：

    多选题
    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


    正确答案： F,D
    解析： 暂无解析

  • 第22题：

    多选题
    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.


    正确答案： A,B,D
    解析： 暂无解析

  • 第23题：

    多选题
    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.


    正确答案： B,C
    解析： 暂无解析

相关内容