Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? （）A、ORDER BY SALARY > 5000B、GROUP BY SALARY > 5000C、HAVING SALARY > 5000D、WHERE SALARY > 5000

第1题：

第2题：

In which three cases would you use the USING clause?（）

• A、You want to create a nonequijoin.
• B、The tables to be joined have multiple NULL columns.
• C、The tables to be joined have columns of the same name and different data types.
• D、The tables to be joined have columns with the same name and compatible data types.
• E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

第3题：

第4题：

Which command （without options） would you use to display how much space is available on all mounted partitions？（）

第5题：

You want the size of the tablespace to increase when it is full. Which option would you use？（）

• A、use automatic extent allocation
• B、disable threshold for the tablespace
• C、use freelists to manage the free space
• D、use automatic segment space management
• E、create the tablespace as a bigfile tablespace
• F、use the RESIZE clause while creating the tablespace
• G、enable AUTOEXTEND for at least one of the data files in the tablespace

第6题：

Which two are true about aggregate functions?（）

• A、You can use aggregate functions in any clause of a SELECT statement.
• B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F、You cannot group the rows of a table by more than one column while using aggregate functions.

第7题：

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）

• A、SMON would automatically restore the lost file.
• B、You would need to restore the whole database from the last backup.
• C、You would need to restore the file from the last full database backup.
• D、You would need to use flashback technology to restore the lost redo log member.
• E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
• F、You would need to restore the missing log file by copying one of the remaining files from the same group.

第8题：

第9题：

Which two statements about sequences are true? （）

• A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
• B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
• C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
• D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
• E、If a sequence starting from a value 100 and incremented by 1 is used by more than one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
• F、You use a REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

第10题：

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

• A、 use DBMS_IJOB package
• B、 use Oracle Scheduler
• C、 use DBMS_JOB package
• D、 use Oracle Data Pump Export and Import