网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Which iSQL*Plus feature can be used to replace values in the WHERE clause?()
- A、substitution variables
- B、replacement variables
- C、prompt variables
- D、instead-of variables
- E、This feature cannot be implemented through iSQL*Plus.
参考答案
更多 “Which iSQL*Plus feature can be used to replace values in the WHERE clause?()A、substitution variablesB、replacement variablesC、prompt variablesD、instead-of variablesE、This feature cannot be implemented through iSQL*Plus.” 相关考题
考题
In which four clauses can a subquery be used? ()
A. in the INTO clause of an INSERT statementB. in the FROM clause of a SELECT statementC. in the GROUP BY clause of a SELECT statementD. in the WHERE clause of a SELECT statementE. in the SET clause of an UPDATE statementF. in the VALUES clause of an INSERT statement
考题
Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?()
A. RSTLNEB. NLSRTLC. LISTENERD. NLSSORTE. Linguistic sorts
考题
Which iSQL*Plus feature can be used to replace values in the WHERE clause?()
A.substitution variablesB.replacement variablesC.prompt variablesD.instead-of variablesE.This feature cannot be implemented through iSQL*Plus.
考题
Which two are attributes of iSQL*Plus? ()A、iSQL*Plus commands cannot be abbreviated.B、iSQL*Plus commands are accessed from a browser.C、iSQL*Plus commands are used to manipulate data in tables.D、iSQL*Plus commands manipulate table definitions in the database.E、iSQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
用户试图在运行Linux的Oracle数据库服务器上连接iSQL*Plus,然而在浏览器中却收到页面无法打开的错误消息。此时,用户怀疑iSQL_*Plus在数据库服务器上没有启动。下列()命令可以用于启动iSQL*Plus。A、emctlstartisqlplusB、emctlstartupisqlplusC、isqlplusctlstartupD、isqlplusctlstartE、isqlplusstart
考题
Cisco IOS XR has implemented a nonstop routing feature so that when RP failover occurs, the routinginformation can be recovered locally. Which protocol does not support the NSR feature?()A、OSPFB、LDPC、BGPD、IS-ISE、RSVP
考题
On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.B、 You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
考题
Which two statements are true about WHERE and HAVING clauses? ()A、A WHERE clause can be used to restrict both rows and groups.B、A WHERE clause can be used to restrict rows only.C、A HAVING clause can be used to restrict both rows and groups.D、A HAVING clause can be used to restrict groups only.E、A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.F、A HAVING clause CANNOT be used in subqueries.
考题
Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?()A、RSTLNEB、NLSRTLC、LISTENERD、NLSSORTE、Linguistic sorts
考题
In which four clauses can a subquery be used? ()A、in the INTO clause of an INSERT statementB、in the FROM clause of a SELECT statementC、in the GROUP BY clause of a SELECT statementD、in the WHERE clause of a SELECT statementE、in the SET clause of an UPDATE statementF、in the VALUES clause of an INSERT statement
考题
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 FROM clause.C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.D、A single row subquery can retrieve data from more than one table.E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
考题
Which /SQL*Plus feature can be used to replace values in the WHERE clause?()A、Substitution variablesB、Replacement variablesC、Prompt variablesD、Instead-of variablesE、This feature cannot be implemented through /SQL*Plus.
考题
Which /SQL*Plus feature can be used to replace values in the WHERE clause?()A、Substitution variablesB、Replacement variablesC、Prompt variablesD、Instead-of variablesE、This feature cannot be implemented through /SQL*Plus
考题
Which two statements are true regarding the USING and ON clauses in table joins?()A、Both USING and ON clauses can be used for equijoins and nonequijoins B、Amaximum of one pair of columns can be joined between two tables using the ON clause C、The ON clause can be used to join tables on columns that have different names but compatible data types D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
考题
Which two are attributes of iSQL*Plus? ()A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accessed from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
单选题Which /SQL*Plus feature can be used to replace values in the WHERE clause?()A
Substitution variablesB
Replacement variablesC
Prompt variablesD
Instead-of variablesE
This feature cannot be implemented through /SQL*Plus
考题
单选题Which /SQL*Plus feature can be used to replace values in the WHERE clause?()A
Substitution variablesB
Replacement variablesC
Prompt variablesD
Instead-of variablesE
This feature cannot be implemented through /SQL*Plus.
考题
多选题Which two are attributes of iSQL*Plus? ()A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accessed from a browser.C/SQL*Plus commands are used to manipulate data in tables.D/SQL*Plus commands manipulate table definitions in the database.E/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
单选题Which iSQL*Plus feature can be used to replace values in the WHERE clause?()A
substitution variablesB
replacement variablesC
prompt variablesD
instead-of variablesE
This feature cannot be implemented through iSQL*Plus.
考题
单选题Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?()A
RSTLNEB
NLSRTLC
LISTENERD
NLSSORTE
Linguistic sorts
考题
多选题Which two statements are true about WHERE and HAVING clauses? ()AA WHERE clause can be used to restrict both rows and groups.BA WHERE clause can be used to restrict rows only.CA HAVING clause can be used to restrict both rows and groups.DA HAVING clause can be used to restrict groups only.EA WHERE clause CANNOT be used in a query of the query uses a HAVING clause.FA HAVING clause CANNOT be used in subqueries.
考题
多选题In which four clauses can a subquery be used? ()Ain the INTO clause of an INSERT statementBin the FROM clause of a SELECT statementCin the GROUP BY clause of a SELECT statementDin the WHERE clause of a SELECT statementEin the SET clause of an UPDATE statementFin the VALUES clause of an INSERT statement
考题
单选题Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?()A
RSTLNEB
NLSRTLC
LISTENERD
NLSSORTE
Linguistic sorts
热门标签
最新试卷