A.Subqueries can contain GROUP BY and ORDER BY clauses
B.Main query and subquery can get data from different tables
C.Main query and subquery must get data from the same tables
D.Subqueries can contain ORDER BY but not the GROUP BY clause
E.Only one column or expression can be compared between the main query and subquery
F. Multiple columns or expressions can be compared between the main query and subquery
您可能感兴趣的试卷
你可能感兴趣的试题
A. SET_ATTRIBUTE_NULL
B. ALTER_JOB
C. ALTER_JOB_PARAMETERS
D. ALTER
E. SET_ATTRIBUTE
A. DBA_SCHEDULER_JOB_RUN_DETAILS
B. DBA_SCHEDULER_RUNNING_JOBS DBA
C. DBA_SCHEDULER_CURRENT_JOBS
D. DBA_SCHEDULER_JOBS DBA
E. DBA_SCHEDULER_EXECUTING_JOBS
A.Synonyms can be created only for a table
B.Synonyms are used to reference only those tables that are owned by another user
C.A public synonym and a private synonym can exist with the same name for the same table
D.The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
A. FREQ
B. BYHOUR
C. RUNDATE
D. INTERVAL
E. BYMINUTE
A.It can be used to join a maximum of three tables
B.It can be used to restrict the number of columns used in a NATURAL join
C.It can be used to access data from tables through equijoins as well as nonequijoins
D.It can be used to join tables that have columns with the same name and compatible data types
A. ENABLE启用
B. ENABLE_PROGRAM
C. VALIDATE_PROGRAM
D. SET_ATTRIBUTE设置属性
E. SET_ENABLED
A. SET_JOB_ARGUMENT_VALUE
B. SET_JOB_VALUE_ANYDATA
C. SET_JOB_ANYDATA_VALUE
D. SET_SPECIAL_JOB_VALUE
E. SET_JOB_ANYTYPE_VALUE
A.All data along with the table structure is deleted
B.The pending transaction in the session is committed
C.All indexes on the table will remain but they are invalidated
D.All views and synonyms will remain but they are invalidated
E.All data in the table are deleted but the table structure will remain
A. A subplan has the PLAN_SUB parameter value set to SUB
B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition
C. There is no difference in the resource-plan definition
D. A subplan always has the CPU_MTH parameter value set to RATIO
E. The string TOP_LEVEL is appended to the name of top-level resource plans
A.The default internal storage of dates is in the numeric format
B.The default internal storage of dates is in the character format
C.The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century
D.The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required
最新试题
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?（）
Examine the parameter setting in your database:Which statement is correct about the database?（）
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.Which method must you use to recover the lost data?（）
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
Which three tasks can be performed using a duplicate database?（）
Which two statements are true about a job chain?（）
Which three functions are performed by the SQL Tuning Advisor? （）
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.What could be a solution to make tape streaming happen during the backup?（）
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?（）
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)？（）