单选题Which /SQL*Plus feature can be used to replace values in the WHERE clause?()ASubstitution variablesBReplacement variablesCPrompt variablesDInstead-of variablesEThis feature cannot be implemented through /SQL*Plus

单选题
Which /SQL*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 /SQL*Plus


参考解析

解析: 暂无解析

相关考题:

Which two statements are true about the Automatic Diagnostic Repository (ADR)?() A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instances

Which two are attributes of /SQL*Plus? () A. /SQL*Plus commands cannot be abbreviated.B. /SQL*Plus commands are accesses 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 two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.) A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instances

Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?() A.UniqueB.CheckC.ReferentialD.Informational

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.

What is the purpose of the OSPF router ID in a OR/BOR election?() A. It is used with the OSPF priority values to determine which OSPF router will become the DR or BOR in a point-to-point networkB. It is used with the OSPF priority values to determine which interface will be used to form a neighbor relationship with another OSPF routerC. It is used with the OSPF priority values to determine which router will become the DR or BOR in a multi access networkD. It is used to determine which interfaces will send Hello packets to neighboring OSPF routers

Which statement correctly describes SQL and /SQL*Plus?()A、Both SQL and /SQL*plus allow manipulation of values in the database.B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

What is the purpose of the OSPF router ID in a OR/BOR election?()A、It is used with the OSPF priority values to determine which OSPF router will become the DR or BOR in a point-to-point networkB、It is used with the OSPF priority values to determine which interface will be used to form a neighbor relationship with another OSPF routerC、It is used with the OSPF priority values to determine which router will become the DR or BOR in a multi access networkD、It is used to determine which interfaces will send Hello packets to neighboring OSPF routers

Which two statements are true about the Automatic Diagnostic Repository (ADR)?() A、 The ADR base keeps all diagnostic information in binary formatB、 SQL*Plus provides the ADRI script, which can be used to work with ADRC、 The ADR can be used for problem diagnosis only when the database is openD、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE、 The ADR can be used for problem diagnosis even when the database instance is downF、 The ADR base is shared across multiple instances

Which two are the uses of the ASM metadata backup and restore (AMBR) feature?()A、 It can be used to back up all data on ASM disks.B、 It can be used to recover the damaged ASM disk group along with the data.C、 It can be used to gather information about a preexisting ASM disk group with disk paths,disk name,failure groups,attributes templates,and alias directory structure.D、 It can be used to re-create the ASM disk group with its attributes.

Which three tasks can be performed using regular expression support in Oracle Database 10g?()A、 it can be used to concatenate two strings.B、 it can be used to find out the total length of the string.C、 it can be used for string manipulation and searching operations.D、 it can be used to format the output for a column or expression having string data.E、 it can be used to find and replace operations for a column or expression having string data.

Which of the following can be used in conjunction with a Flashback Versions Query to filter the results?()A、 A range of SCN valuesB、 A list of SCN valuesC、 A starting and ending timestampD、 Minimum and maximum sequence valuesE、 A list of sequence values

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 tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()A、Segment AdvisorB、SQL Access AdvisorC、Undo AdvisorD、SQL Tuning Advisor

Which of the following methods can be used to detect block corruption?()  A、 ANALYZE operationsB、 dbvC、 SQL queries that access the potentially corrupt blockD、 RMANE、 All of the above

Which two are attributes of /SQL*Plus? ()A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accesses 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 of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()AUniqueBCheckCReferentialDInformational

多选题Which two are attributes of /SQL*Plus? ()A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accesses 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 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?()Asubstitution variablesBreplacement variablesCprompt variablesDinstead-of variablesEThis feature cannot be implemented through iSQL*Plus.

多选题Which three tasks can be performed using regular expression support in Oracle Database 10g?()Ait can be used to concatenate two strings.Bit can be used to find out the total length of the string.Cit can be used for string manipulation and searching operations.Dit can be used to format the output for a column or expression having string data.Eit can be used to find and replace operations for a column or expression having string data.

单选题Which statement correctly describes SQL and /SQL*Plus?()ABoth SQL and /SQL*plus allow manipulation of values in the database.B/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

多选题Which two are attributes of iSQL*Plus? ()AiSQL*Plus commands cannot be abbreviated.BiSQL*Plus commands are accessed from a browser.CiSQL*Plus commands are used to manipulate data in tables.DiSQL*Plus commands manipulate table definitions in the database.EiSQL*Plus is the Oracle proprietary interface for executing SQL statements.

单选题Which /SQL*Plus feature can be used to replace values in the WHERE clause?()ASubstitution variablesBReplacement variablesCPrompt variablesDInstead-of variablesEThis feature cannot be implemented through /SQL*Plus.

多选题Which two statements are true about the Automatic Diagnostic Repository (ADR)?()AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances

单选题Which is an /SQL*Plus command? ()AINSERTBUPDATECSELECTDDESCRIBEEDELETEFRENAME

单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()A Segment AdvisorB SQL Access AdvisorC Undo AdvisorD SQL Tuning Advisor