IBM(000-020)
单选题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
题目
A preexisting database user may be used but a new database has to be created during installation.
A preexisting database may be used but a new database user has to be created during installation.
A preexisting database and user may be used or a new database and user are created during installation.
A preexisting database and user cannot be used； a new database and user are created during installation.
相似问题和答案
第1题：
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 backup
B. It contains all data from target database until the current time
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target database
第2题：
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.
第3题：
A. The data files of the read-only tablespaces in the target database are not duplicated
B. The read-only tablespaces in the target database are still defined in new the database
C. The read-only tablespaces in the target database are changed to online after duplication
D. The data files of the read-only tablespaces in the target database get duplicated
E. The read-only tablespaces in the target database are not defined in the new database
第4题：
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
第5题：
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
第6题：
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.
第7题：
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
第8题：
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
第9题：
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
第10题：
How many database instances are used during a database-duplication process？（）
- A、 One
- B、 Two
- C、 Three
- D、 Four
- E、 Five
正确答案:B