当前分类： Oracle认证考试
问题：Which two statements...
查看答案
问题：Which two statements are true ab...
问题：You notice a performance change...
问题：对于以下SQL语句说法正确的是（） SELECT ename ...
问题：You configured automa...
问题：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...
问题：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...
问题：Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）A、 Cursor cacheB、 Stored outlineC、 SQL Tuning SetD、 Automatic Workload Repository （AWR） snapshots...
问题：Which three statemen...
问题：Examine the details of the Top 5...
问题：In your test d...
问题：Which three are true regarding the use of outer joins?（）A、You cannot use IN operator in a condition that involves an outerjoin.B、You use (+) on both sides of the WHERE condition to perform an outerjoin.C、You use (*) on both sides of the WHERE condition to...
问题：Which three types of files can b...
问题：Which statements are...
问题：Note the following structures in your database server： 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest（）A、2，5，1，4，3B、1，2，3，4，5C、5，2，1，3，4D、2，1，...
问题：Which one of t...
问题：You want to use&...
问题：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...
问题：当ORACLE9.2数据库服务器安装后，将自动创建两个具有超级权限的用户，并且要求设定这两个用户的口令，这两个用户是（）A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER...
