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
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 > 5000
- B、GROUP BY SALARY > 5000
- C、HAVING SALARY > 5000
- D、WHERE SALARY > 5000
相关考题：
Which substitution variable would you use if you want to reuse the variable without prompting the user each time? () A. B. ACCEPTC. PROMPTD.
Which clause should you use to exclude group results? () A. WHEREB. HAVINGC. RESTRICTD. GROUP BYE. ORDER BY
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
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.
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.
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.
You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace
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.
Which command （without options） would you use to display how much space is available on all mounted partitions？（）
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 packageB、 use Oracle SchedulerC、 use DBMS_JOB packageD、 use Oracle Data Pump Export and Import
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）A、 UNTIL CANCELB、 UNTIL SCNC、 UNTIL SEQUENCED、 UNTIL TIME
When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）A、 INCLUDING DEPENDENCIESB、 INCLUDING DEPENDENCIES CASCADEC、 COMPACTD、 CASCADEE、 None of the above
Which clause should you use to exclude group results?（）A、WHEREB、HAVINGC、RESTRICTD、GROUP BYE、ORDER BY
Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）A、B、ACCEPTC、PROMPTD、
单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）Ause automatic extent allocationBdisable threshold for the tablespaceCuse freelists to manage the free spaceDuse automatic segment space managementEcreate the tablespace as a bigfile tablespaceFuse the RESIZE clause while creating the tablespaceGenable AUTOEXTEND for at least one of the data files in the tablespace
单选题When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）A INCLUDING DEPENDENCIESB INCLUDING DEPENDENCIES CASCADEC COMPACTD CASCADEE None of the above
多选题You are creating a destination NAT rule-set. Which two are valid for use with the from clause？（）Asecurity policyBinterfaceCrouting-instanceDIP address
单选题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 packageB use Oracle SchedulerC use DBMS_JOB packageD use Oracle Data Pump Export and Import
单选题Which clause should you use to exclude group results?（）AWHEREBHAVINGCRESTRICTDGROUP BYEORDER BY
单选题You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）Atable Btransactional trigger Cstored procedure DFROM clause query
多选题In which three cases would you use the USING clause?（）AYou want to create a nonequijoin.BThe tables to be joined have multiple NULL columns.CThe tables to be joined have columns of the same name and different data types.DThe tables to be joined have columns with the same name and compatible data types.EYou want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
单选题You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests. Which naming method can you use？（）AOnly hostBOnly localCEither host or localDBoth host and local
单选题Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）ABACCEPTCPROMPTD
单选题Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）AORDER BY SALARY 5000BGROUP BY SALARY 5000CHAVING SALARY 5000DWHERE SALARY 5000
多选题Which two commands would you use to discard a candidate configuration?（）ArollbackBdeleteCdelete 0Drollback 0
单选题Which event would you use to run a method immediately after serialization occurs？（）A OnSerializingB OnDeserializingC OnSerializedD OnDeserialized