A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）..

第1题

[单选题] 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.

点击查看答案

第2题

[] You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（） You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows

A、A. Transportable database B、B. Transportable tablespace C、C. Data Pump full export / import D、D. The DBMS_PDB package E、E. RMAN

点击查看答案

第3题

[] You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database: Which three are the prerequisites for the successful execution of the above command?（） You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database: Which three are the prerequisites for the successful execution of the above command?（）

A、A. The source database should be open B、B. The target database should be in ARCHIVELOG mode if it is open C、C. RMAN should be connected to both the instances as SYSDBA D、D. The target database backups should be copied to the source database backup directories E、E. The password file must exist for the source database and have the same SYS user password as the target

点击查看答案

第4题

[单选题] You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

A、It must be executed from the Oracle Database 11g environment. B、It must be executed only after the SYSAUX tablespace has been created. C、It must be executed from the environment of the database that is being upgraded. D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

点击查看答案

第5题

[单选题] In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）

A、The CDB must be open. B、The CDB must be in the mount stage. C、The CDB must be in the nomount stage. D、Alt existing PDBs must be closed.

点击查看答案

第6题

[多选题] You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）

A、the CONVERT command of RMAN B、Data Pump Export and Import into the same database C、conventional export and import into the same database D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

点击查看答案

第7题

[多选题] You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）

A、the CONVERT command of RMAN B、Data Pump Export and Import into the same database C、conventional export and import into the same database D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

点击查看答案

第8题

[多选题] You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

A、Corrupted blocks, if any, are repaired. B、Checks are performed for physical corruptions. C、Checks are performed for logical corruptions. D、Checks are performed to confirm whether all database files exist in correct locations E、Backup sets containing both data files and archive logs are created.

点击查看答案

第9题

[单选题] While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows: 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.（）

A、2，3，5 B、1，2，4 C、1，2，4，5 D、1, 2, 3, 4, 5

点击查看答案

第10题

[单选题] While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:（） 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.

A、2, 3, 5 B、1, 2, 4 C、1, 2, 4, 5 D、1, 2, 3, 4, 5

点击查看答案

请使用微信扫码支付