网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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 are iSQL*Plus commands? ()A、INSERTB、UPDATEC、SELECTD、DESCRIBEE、DELETEF、RENAME

考题 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 is an iSQL*Plus command? ()A INSERTB UPDATEC SELECTD DESCRIBEE DELETEF RENAME

考题 多选题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