niusouti.com

单选题Which statement is true about the database and database-user used during installation of IMS Server？（）A A preexisting database user may be used but a new database has to be created during installation.B A preexisting database may be used but a new data

题目
单选题
Which statement is true about the database and database-user used during installation of IMS Server？（）
A

A preexisting database user may be used but a new database has to be created during installation.

B

A preexisting database may be used but a new database user has to be created during installation.

C

A preexisting database and user may be used or a new database and user are created during installation.

D

A preexisting database and user cannot be used； a new database and user are created during  installation.

相似考题

1.Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? ()A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

2.Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）A. It contains data till the last backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database

3.In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:Which two statements are true?()A. The C # # ROLE1 role is created in the root database and all the PDBs.B. The C # # ROLE1 role is created only in the root database because the container clause is not used.C. Privileges are granted to the C##A_ADMIN user only in the root database.D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.E. The statement for granting a role to a user fails because the CONTAINER clause is not used.

4.You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.What is the reason for performing these activities? （）A. to minimize plan regression due to the use of a new optimizer versionB. to completely avoid the use of new plans generated by a new optimizer versionC. to prevent plan capturing when the SQL statement is executed after the database upgradeD. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

更多“单选题Which statement is true about the database and database-user used during installation of IMS Server？（）A A preexisting database user may be used but a new database has to be created during installation.B A preexisting database may be used but a new data”相关问题

  • 第1题：

    Which two statements are true about Oracle Managed Files (OMF)?()

    A. OMF cannot be used in a database that already has data files created with user-specified directions.

    B. The file system directions that are specified by OMF parameters are created automatically.

    C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

    D. OMF automatically creates unique file names for table spaces and control files.

    E. OMF may affect the location of the redo log files and archived log files.


    参考答案：B, D

  • 第2题：

    Which statement is true about a DB2 user that is to be used as the database user for IBM Tivoli Access Manager for Enterprise Single Sign-On IMS Server？（）

    • A、The database user must be created using DB2 Control Center.
    • B、The database user must be created using the DB2 Command Line Processor.
    • C、The database user may be created using DB2 Control Center or DB2 Command Line Processor.
    • D、The database user must be created by IBM Tivoli Access Manager for Enterprise Single Sign-On V8.0.1 IMS Installer.

    正确答案:C

  • 第3题：

    If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）

    • A、All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.  
    • B、Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.  
    • C、Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.  
    • D、A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.

    正确答案:A

  • 第4题：

    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）

    • A、The backup will consist of used data blocks only.
    • B、The database must be shut down to accomplish the backup.
    • C、The backup can be accomplished without shutting down the database.
    • D、The backup will contain all database files that have never been backed up.

    正确答案:B

  • 第5题：

    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）

    • A、The ASM compatibility attribute controls the format of the disk group metadata.
    • B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
    • C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
    • D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
    • E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

    正确答案:A,B,D

  • 第6题：

    Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）

    • A、the port used by the listener
    • B、the protocol used by the listener
    • C、the server name where the listener runs
    • D、the log file and trace file destination for the listener
    • E、the database services to be registered with the listener

    正确答案:A,B,C

  • 第7题：

    Which three statements are true about database recovery operations？（）

    • A、Damaged or lost data files are restored from backups.
    • B、Redo log file entries are used to roll forward the database.
    • C、Undo segments are used to roll back any uncommitted transactions.
    • D、Transactions that were active when the failure occurred are restarted.
    • E、Transactions that were active when the failure occurred are automatically committed during the recover procedure.

    正确答案:A,B,C

  • 第8题：

    多选题
    When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）
    A

    The database has a subset of the tables in the production server database.

    B

    The database has a copy of selected data from the production database

    C

    The database logs changes for later propagation.

    D

    The database is accessed as read-only to prevent data corruption.

    E

    The database includes all user and order data for offline processing.


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

  • 第9题：

    单选题
    You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）
    A

    to minimize plan regression due to the use of a new optimizer version

    B

    to completely avoid the use of new plans generated by a new optimizer version

    C

    to prevent plan capturing when the SQL statement is executed after the database upgrade

    D

    to keep the plan in the plan history so that it can be used when the older version of the optimizer is used


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

  • 第10题：

    单选题
    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）
    A

    The backup will consist of used data blocks only.

    B

    The database must be shut down to accomplish the backup.

    C

    The backup can be accomplished without shutting down the database.

    D

    The backup will contain all database files that have never been backed up.


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

  • 第11题：

    多选题
    Which two statements are true about Oracle Managed Files (OMF)?（）
    A

    OMF cannot be used in a database that already has data files created with user-specified directions.

    B

    The file system directions that are specified by OMF parameters are created automatically.

    C

    OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

    D

    OMF automatically creates unique file names for table spaces and control files.

    E

    OMF may affect the location of the redo log files and archived log files.


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

  • 第12题：

    多选题
    Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）
    A

    the port used by the listener

    B

    the protocol used by the listener

    C

    the server name where the listener runs

    D

    the log file and trace file destination for the listener

    E

    the database services to be registered with the listener


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

  • 第13题：

    When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）

    • A、The database has a subset of the tables in the production server database.
    • B、The database has a copy of selected data from the production database
    • C、The database logs changes for later propagation.
    • D、The database is accessed as read-only to prevent data corruption.
    • E、The database includes all user and order data for offline processing.

    正确答案:B,C

  • 第14题：

    Which statement is true about the database and database-user used during installation of IMS Server？（）

    • A、A preexisting database user may be used but a new database has to be created during installation.
    • B、A preexisting database may be used but a new database user has to be created during installation.
    • C、A preexisting database and user may be used or a new database and user are created during installation.
    • D、A preexisting database and user cannot be used； a new database and user are created during  installation.

    正确答案:C

  • 第15题：

    How many database instances are used during a database-duplication process？（）

    • A、 One
    • B、 Two
    • C、 Three
    • D、 Four
    • E、 Five

    正确答案:B

  • 第16题：

    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）

    • A、 The statement will be executed successfully， and a new time zone will be set for the database.
    • B、 The statement will be executed successfully， but a new time zone will not be set for the database.
    • C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
    • D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

    正确答案:D

  • 第17题：

    Which three statements are true about Flashback Database?（）

    • A、Flashback logs are written sequentially, and are archived.
    • B、Flashback Database uses a restored control file to recover a database.
    • C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
    • D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
    • E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
    • F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

    正确答案:B,C,F

  • 第18题：

    You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）

    • A、to minimize plan regression due to the use of a new optimizer version
    • B、to completely avoid the use of new plans generated by a new optimizer version
    • C、to prevent plan capturing when the SQL statement is executed after the database upgrade
    • D、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

    正确答案:A

  • 第19题：

    单选题
    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）
    A

     The statement will be executed successfully， and a new time zone will be set for the database.

    B

     The statement will be executed successfully， but a new time zone will not be set for the database.

    C

     The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.

    D

     The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.


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

  • 第20题：

    单选题
    How many database instances are used during a database-duplication process？（）
    A

     One

    B

     Two

    C

     Three

    D

     Four

    E

     Five


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

  • 第21题：

    单选题
    Which statement is true about the database and database-user used during installation of IMS Server？（）
    A

    A preexisting database user may be used but a new database has to be created during installation.

    B

    A preexisting database may be used but a new database user has to be created during installation.

    C

    A preexisting database and user may be used or a new database and user are created during installation.

    D

    A preexisting database and user cannot be used； a new database and user are created during  installation.


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

  • 第22题：

    单选题
    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）
    A

    The backup will consist of used data blocks only.

    B

    The database must be shut down to accomplish the backup.

    C

    The backup can be accomplished without shutting down the database.

    D

    The backup will contain all database files that have never been backed up


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

  • 第23题：

    单选题
    If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）
    A

    All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.  

    B

    Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.  

    C

    Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.  

    D

    A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.


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

  • 第24题：

    单选题
    Which statement is true about a DB2 user that is to be used as the database user for IBM Tivoli Access Manager for Enterprise Single Sign-On IMS Server？（）
    A

    The database user must be created using DB2 Control Center.

    B

    The database user must be created using the DB2 Command Line Processor.

    C

    The database user may be created using DB2 Control Center or DB2 Command Line Processor.

    D

    The database user must be created by IBM Tivoli Access Manager for Enterprise Single Sign-On V8.0.1 IMS Installer.


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

相关内容