itgle.com

多选题Which three are true? （）AA MERGE statement is used to merge the data of one table with data from another.BA MERGE statement replaces the data of one table with that of another.CA MERGE statement can be used to insert new rows into a table.DA MERGE stat

题目
多选题
Which three are true? （）
A

A MERGE statement is used to merge the data of one table with data from another.

B

A MERGE statement replaces the data of one table with that of another.

C

A MERGE statement can be used to insert new rows into a table.

D

A MERGE statement can be used to update existing rows in a table.

相似考题

1.Data Set对象的Merge方法用于()A.将两个Data Set中的数据和架构合并到一个Data Set中B.将两个Data Table中的行合并到一个Data Table中C.向数据源提交修改D.从数据源提取数据

2.Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()A. It releases the storage space used by the table.B. It does not release the storage space used by the table.C. You can roll back the deletion of rows after the statement executes.D. You can NOT roll back the deletion of rows after the statement executes.E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

3.Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?()A.B.C.D.

4.A SELECT statement can be used to perform these three functions:1. Choose rows from a table.2. Choose columns from a table3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities? （）A. difference, projection, joinB. selection, projection, joinC. selection, intersection, joinD. intersection, projection, joinE. difference, projection, product

更多“多选题Which three are true? （）AA MERGE statement is used to merge the data of one table with data from another.BA MERGE statement replaces the data of one table with that of another.CA MERGE statement can be used to insert new rows into a table.DA MERGE stat”相关问题

  • 第1题：

    Merge the following two short sentences into one new sentence.

    A: Split
    B: Combine
    C: Break
    D: Divide

    答案：B
    解析：
    句意：把下面的两个短句合并成一个新的句子。merge：使合并，与combine意思相近，故选项B为最佳答案。break和divide都有“拆分”的意思，与merge的意思正好相反。

  • 第2题：

    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

    正确答案:B,D

  • 第3题：

    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

    • A、MERGE
    • B、SELECT …CROSS JOIN
    • C、INSERT ALL …SELECT
    • D、CREATE VIEW …CONSTRAINT

    正确答案:A

  • 第4题：

    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.

    正确答案:B,D

  • 第5题：

    Which three statements are true regarding the data types in Oracle Database 10g/11g?（）

    • A、Only one LONG column can be used per table 
    • B、A TIMESTAMP data type column stores only time values with fractional seconds 
    • C、The BLOB data type column is used to store binary data in an operating system file 
    • D、The minimum column width that can be specified for a VARCHAR2 data type column is one 
    • E、The value for a CHAR data type column is blank-padded to the maximum defined column width

    正确答案:A,D,E

  • 第6题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL*Loader.
    • D、New data conforms to the constraint， but existing data is not checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第7题：

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


    正确答案： A,C
    解析： 暂无解析

  • 第8题：

    单选题
    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）
    A

    MERGE

    B

    SELECT …CROSS JOIN

    C

    INSERT ALL …SELECT

    D

    CREATE VIEW …CONSTRAINT


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities?（）
    A

    difference, projection, join

    B

    selection, projection, join

    C

    selection, intersection, join

    D

    intersection, projection, join

    E

    difference, projection, product


    正确答案： B
    解析： 暂无解析

  • 第10题：

    多选题
    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 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 an INSERT statement to insert multiple rows at a time.


    正确答案： A,F
    解析： 暂无解析

  • 第11题：

    多选题
    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
    A

    It releases the storage space used by the table.

    B

    It does not release the storage space used by the table.

    C

    You can roll back the deletion of rows after the statement executes.

    D

    You can NOT roll back the deletion of rows after the statement executes.

    E

    An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

    F

    You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table


    正确答案： D,F
    解析： 暂无解析

  • 第12题：

    多选题
    Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）
    A

    You cannot roll back this statement.

    B

    All pending transactions are committed.

    C

    All views based on the DEPT table are deleted.

    D

    All indexes based on the DEPT table are dropped.

    E

    All data in the table is deleted, and the table structure is also deleted.

    F

    All data in the table is deleted, but the structure of the table is retained.

    G

    All synonyms based on the DEPT table are deleted.


    正确答案： C,E
    解析： 暂无解析

  • 第13题：

    ( )algorithm specifies the way to arrange data in a particular order.

    A.Search
    B.Random
    C.Sorting
    D.Merge

    答案：C
    解析：
    本题考查计算机专业英语知识（）按特定顺序排列数据的方式A 搜索B 随机C 排序D 合并

  • 第14题：

    Which three are true?（）

    • A、A MERGE statement is used to merge the data of one table with data from another.
    • B、A MERGE statement replaces the data of one table with that of another.
    • C、A MERGE statement can be used to insert new rows into a table.
    • D、A MERGE statement can be used to update existing rows in a table.

    正确答案:A,C,D

  • 第15题：

    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

    • A、It releases the storage space used by the table.
    • B、It does not release the storage space used by the table.
    • C、You can roll back the deletion of rows after the statement executes.
    • D、You can NOT roll back the deletion of rows after the statement executes.
    • E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
    • F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

    正确答案:A,D,F

  • 第16题：

    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 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 an INSERT statement to insert multiple rows at a time.

    正确答案:D,F

  • 第17题：

    A SELECT statement can be used to perform these three functions: 1.Choose rows from a table. 2.Choose columns from a table. 3.Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities?（）

    • A、difference, projection, join
    • B、selection, projection, join
    • C、selection, intersection, join
    • D、intersection, projection, join
    • E、difference, projection, product

    正确答案:B

  • 第18题：

    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL *Loader.
    • D、New data conforms to the constraint， but existing data is not checked.
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第19题：

    多选题
    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL *Loader.

    D

    New data conforms to the constraint， but existing data is not checked.

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


    正确答案： C,B
    解析： 暂无解析

  • 第20题：

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


    正确答案： F,A
    解析： 暂无解析

  • 第21题：

    单选题
    Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）
    A

    A syntax error will result as you cannot specify more than one partition in the same statement

    B

    All data in p1 and p3 partitions are removed and the table definition is changed

    C

    All data in p1 and p3 partitions are removed, but the table definition remains unchanged

    D

    Only the first partition (p1) will be dropped as only one can be dropped at any time


    正确答案： D
    解析： 暂无解析

  • 第22题：

    多选题
    From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.
    A

    Updating

    B

    Viewing

    C

    Deleting

    D

    Inserting

    E

    Truncating


    正确答案： C,D
    解析： 暂无解析

  • 第23题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL*Loader.

    D

    New data conforms to the constraint， but existing data is not checked

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


    正确答案： C,A
    解析： 暂无解析

相关内容