当前分类： Oracle认证考试
问题：Examine the details of the Top 5...
查看答案
问题：Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold fo...
问题：Your database operate...
问题：In your test d...
问题：You executed the&ensp...
问题：Examine the following command: ...
问题：Your database block&...
问题：Which two statements are true about encrypting RMAN backup?（） (Choose two.)A、The transparent encryption of backups uses the encryption walletB、The database uses the same encryption key for every encrypted backupC、The password encryption of backups only us...
问题：用于删除表中所有数据行的命令是（）。A、DELETE TABLEB、TRUNCATE TABLEC、DROP TABLED、ALTER TABLE...
问题：You configured automa...
问题：What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with t...
问题：From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would ...
问题：Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database...
问题：Examine the structure if the EM...
问题：You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have bee...
问题：You notice a performance change...
问题：当ORACLE9.2数据库服务器安装后，将自动创建两个具有超级权限的用户，并且要求设定这两个用户的口令，这两个用户是（）A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER...
问题：The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（） 1. Shot down and start up the former primary instance witho...
问题：对于以下SQL语句说法正确的是（） SELECT ename ...
问题：Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）A、SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;B、SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;C、SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dua...
