当前分类： Oracle认证考试
问题：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...
查看答案
问题：Examine the details of the Top 5...
问题：What is true regarding subqueries?（）A、The inner query always sorts the results of the outer queryB、The outer query always sorts the results of the inner queryC、The outer query must return a value to the outer queryD、The inner query returns a value to the ...
问题：You have enabledQ...
问题：当ORACLE9.2数据库服务器安装后，将自动创建两个具有超级权限的用户，并且要求设定这两个用户的口令，这两个用户是（）A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER...
问题：You decided to ...
问题：You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）A、 The backup contains data files， the server parameter file，and the control file even if the control file autobackup is disabled.B、 The KEE...
问题：You want to perform an RMAN back...
问题：You notice a performance change...
问题：对于以下SQL语句说法正确的是（） SELECT ename ...
问题：Which two statements are true ab...
问题：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...
问题：You need to perf...
问题：Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? （）A、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;B、SELECT TO_CHA...
问题：Your alert log f...
问题：You configured automa...
问题：回滚段的PCTINCREASE参数值为下列哪一个（）A、0B、10C、20D、50E、100...
问题：In your test d...
问题：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...
问题：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 appli...
