网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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 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 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、
考题
Which protocols would you want to use for secure VPN ？（）A、EAPB、ChapC、Ms-ChapD、PPTPE、PAPF、SPAP
考题
单选题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
考题
单选题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
考题
单选题Which protocols would you want to use for secure VPN ？（）A
EAPB
ChapC
Ms-ChapD
PPTPE
PAPF
SPAP
考题
单选题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?（）A
WHEREB
HAVINGC
RESTRICTD
GROUP BYE
ORDER 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?（）A
table B
transactional trigger C
stored procedure D
FROM 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？（）A
Only hostB
Only localC
Either host or localD
Both host and local
考题
单选题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 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 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
热门标签
最新试卷
