当前分类： Oracle认证考试
问题：Which two statements about subqueries are true?（）A、A single row subquery can retrieve data from only one table.B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FRO...
查看答案
问题：You want to create the Recovery ...
问题：A common approach...
问题：Which three tasks can be perform...
问题：Which of the f...
问题：You created a ...
问题：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...
问题：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...
问题：You notice a performance change...
问题：You are developing&#...
问题：Examine the details of the Top 5...
问题：当ORACLE9.2数据库服务器安装后，将自动创建两个具有超级权限的用户，并且要求设定这两个用户的口令，这两个用户是（）A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER...
问题：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...
问题：对于以下SQL语句说法正确的是（） SELECT ename ...
问题：You are maintaining&e...
问题：Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL ALTER SYSTEM SET DB_8K_CACHE_SIZE=140...
问题：下面的时间函数，（）用于返回当前Oracle会话时区中的日期信息。A、DATE（）B、current_timestamp（）C、current_date（）D、DBTIMEZONE...
问题：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...
问题：In your test d...
