单选题Which of the following statements is true regarding the VERSIONS BETWEEN clause?()A The VERSIONS BETWEEN clause may be used in DML statements.B The VERSIONS BETWEEN clause may be used in DDL statements.C The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
单选题
Which of the following statements is true regarding the VERSIONS BETWEEN clause?()
A
The VERSIONS BETWEEN clause may be used in DML statements.
B
The VERSIONS BETWEEN clause may be used in DDL statements.
C
The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
D
The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
参考解析
解析:
暂无解析
相关考题:
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?() A. fixed tablesB. heap tablesC. external tablesD. temporary tablesE. Index-Organized Tables (IOTs)
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.) A. viewsB. fixed tablesC. heap tablesD. external tablesE. temporary tablesF. index-organized tables (IOT)
The relationship between the embedded clause and its matrix clause is one of a part to the whole.A对B错
Which two statements are true regarding the USING clause in table joins?()A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types
The relationship between the embedded clause and its matrix clause is one of a part to the whole.
What is the use of an "all configuration" backup in Cisco UCS?()A、 Can be used to migrate from a 6120 to a 6140 and retain the same service profilesB、 Can only be used on the fabric interconnect on which it was createdC、 Can be used to migrate from a 6120 to 6140 and retain system IP addresses and cluster informationD、 Can be used to match firmware versions between 6120 and 6140 during a migration
Which of the following statements best describes Flashback Versions Query?() A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B、 Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D、 Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
Which of the following statements is true regarding the VERSIONS BETWEEN clause?() A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
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.
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()A、fixed tablesB、heap tablesC、external tablesD、temporary tablesE、Index-Organized Tables (IOTs)
Which two statements are true regarding the ORDER BY clause? ()A、It is executed first in the query execution B、It must be the last clause in the SELECT statement C、It cannot be used in a SELECT statement containing a HAVING clauseD、You cannot specify a column name followed by an expression in this clause E、You can specify a combination of numeric positions and column names in this clause
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
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.)A、viewsB、fixed tablesC、heap tablesD、external tablesE、temporary tablesF、index-organized tables (IOT)
Where can subqueries be used?()A、field names in the SELECT statement B、the FROM clause in the SELECT statement C、the HAVING clause in the SELECT statementD、the GROUP BY clause in the SELECT statement E、the WHERE clause in only the SELECT statement F、the WHERE clause in SELECT as well as all DML statements
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 statement is true regarding Flashback Version Query? ()A、 It returns versions of rows only within a transaction.B、 It can be used in subqueries contained only in a SELECT statement.C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
多选题For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.)AviewsBfixed tablesCheap tablesDexternal tablesEtemporary tablesFindex-organized tables (IOT)
多选题On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()Afixed tablesBheap tablesCexternal tablesDtemporary tablesEIndex-Organized Tables (IOTs)
多选题Which two statements are true regarding the USING clause in table joins?()AIt can be used to join a maximum of three tablesBIt can be used to restrict the number of columns used in a NATURAL joinCIt can be used to access data from tables through equijoins as well as nonequijoinsDIt can be used to join tables that have columns with the same name and compatible data types
单选题Which of the following statements best describes Flashback Versions Query?()A Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.B Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.C Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.D Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
单选题What is the use of an "all configuration" backup in Cisco UCS?()A Can be used to migrate from a 6120 to a 6140 and retain the same service profilesB Can only be used on the fabric interconnect on which it was createdC Can be used to migrate from a 6120 to 6140 and retain system IP addresses and cluster informationD Can be used to match firmware versions between 6120 and 6140 during a migration
判断题The relationship between the embedded clause and its matrix clause is one of a part to the whole.A对B错
多选题Which two statements are true regarding the USING and ON clauses in table joins?()ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
单选题Which of the following statements is true regarding the VERSIONS BETWEEN clause?()A The VERSIONS BETWEEN clause may be used in DML statements.B The VERSIONS BETWEEN clause may be used in DDL statements.C The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
多选题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
多选题Where can subqueries be used?()Afield names in the SELECT statementBthe FROM clause in the SELECT statementCthe HAVING clause in the SELECT statementDthe GROUP BY clause in the SELECT statementEthe WHERE clause in only the SELECT statementFthe WHERE clause in SELECT as well as all DML statements
多选题Which two statements are true regarding the ORDER BY clause? ()AIt is executed first in the query executionBIt must be the last clause in the SELECT statementCIt cannot be used in a SELECT statement containing a HAVING clauseDYou cannot specify a column name followed by an expression in this clauseEYou can specify a combination of numeric positions and column names in this clause