Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which of the following queries returns the following result set? RETVAL E（）A、SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2B、SELECT r1 AS retval FROM t

题目

Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which of the following queries returns the following result set? RETVAL E（）

  • A、SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2
  • B、SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2
  • C、SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2
  • D、SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
相似考题

1.What is true about joining tables through an equijoin? ()A. You can join a maximum of two tables through an equijoin.B. You can join a maximum of two columns through an equijoin.C. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.D. To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

2.Given the following tables: CONTINENTS ID NAME COUNTRIES1 Antarctica 02 Africa 533 Asia 474 Australia 145 Europe 436 North America 237 South America 12REGION ID LOCATION 1 East 2 WestHow many rows would be returned using the following statement? SELECT location FROM continents, region（）A.2B.7C.9D.14

3.In which of the following situations should correlation names be used?()A.A table referenced in the FROM clause has no indexed column.B.The table referenced in the FROM clause has more than 200 columns.C.Two or more tables in the FROM clause have identical column names.D.The FROM clause contains two or more tables in the SELECT statement.

4.Given the following two AS path regular expressions: "65000＋ (65001|65002)" "65000(65001|65002){0,}" Which AS path matches both regular expressions?()A. 65000 65001 65002B. 65000 65002C. 65001 65000D. 65001 65002

更多“Given the following two tables:”相关问题

  • 第1题：

    The datum from which the predicted heights of tides are reckoned in the tide tables is ______.

    A.mean low water

    B.the same as that used for the charts of the locality

    C.the highest possible level

    D.given in table three of the tide tables


    正确答案：B

  • 第2题：

    What are two reasons to create synonyms?（）

    • A、You have too many tables.
    • B、Your tables are too long.
    • C、Your tables have difficult names.
    • D、You want to work on your own tables.
    • E、You want to use another schema's tables.
    • F、You have too many columns in your tables.

    正确答案:B,C

  • 第3题：

    Which of the following RAID levels would be appropriate given two drives and a need for fault tolerance？（）

    • A、RAID 0
    • B、RAID 1
    • C、RAID 5
    • D、RAID 10

    正确答案:B

  • 第4题：

    Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）

    • A、SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
    • B、SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
    • C、SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
    • D、SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx

    正确答案:D

  • 第5题：

    A bitmap join index is defined as（）.

    • A、An index used to join two bitmap indexes on a table.
    • B、A bitmap index created for the join of two or more tables.
    • C、A bitmap index created on the join of two or more indexes.
    • D、A bitmap index created on the join of two or more indexed-organized tables.

    正确答案:B

  • 第6题：

    单选题
    The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）
    A

    Temporary tables 

    B

    Index-organized tables 

    C

    Cluster tables 

    D

    Standard Oracle tables 


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

  • 第7题：

    单选题
    Which two terms can best describe the following pairs of words: table—tables, day + break—daybreak.
    A

    inflection and compound

    B

    compound and derivation

    C

    inflection and derivation


    正确答案： B
    解析：
    屈折变化是通过附加屈折词缀表现语法关系，如tables。合成词是由词根语素按一定的规则组合起来构成的，如daybreak。

  • 第8题：

    单选题
    You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）
    A

    One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.

    B

    One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.

    C

    Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.

    D

    None of the tables are recovered from the Recycle Bin, and the statement returns an error.


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

  • 第9题：

    单选题
    A bitmap join index is defined as（）.
    A

    An index used to join two bitmap indexes on a table.

    B

    A bitmap index created for the join of two or more tables.

    C

    A bitmap index created on the join of two or more indexes.

    D

    A bitmap index created on the join of two or more indexed-organized tables.


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

  • 第10题：

    多选题
    What are two reasons to create synonyms? （）
    A

    You have too many tables.

    B

    Your tables are too long.

    C

    Your tables have difficult names.

    D

    You want to work on your own tables.

    E

    You want to use another schema's tables.

    F

    You have too many columns in your tables.


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

  • 第11题：

    单选题
    Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）
    A

    2

    B

    7

    C

    9

    D

    14


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

  • 第12题：

    In which of the following situations should correlation names be used?（）

    • A、A table referenced in the FROM clause has no indexed column.
    • B、The table referenced in the FROM clause has more than 200 columns.
    • C、Two or more tables in the FROM clause have identical column names.
    • D、The FROM clause contains two or more tables in the SELECT statement.

    正确答案:C

  • 第13题：

    Given that Thing is a class， how many objects and reference variables are created by the following code？（）   Thing item， stuff；   item = new Thing（）；   Thing entity = new Thing（）；

    • A、One object is created
    • B、Two objects are created
    • C、Three objects are created
    • D、One reference variable is created
    • E、Two reference variables are created
    • F、Three reference variables are created.

    正确答案:B,F

  • 第14题：

    Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）

    • A、2
    • B、7
    • C、9
    • D、14

    正确答案:D

  • 第15题：

    Given the following two AS path regular expressions: "65000+ (65001|65002)" "65000(65001|65002){0,}" Which AS path matches both regular expressions?（）

    • A、65000 65001 65002
    • B、65000 65002
    • C、65001 65000
    • D、65001 65002

    正确答案:B

  • 第16题：

    多选题
    Which two are true regarding external tables？ （）
    A

    External tables can be updated.

    B

    External tables are read-only tables.

    C

    Indexes can be created on external tables.

    D

    Indexes cannot be created on external tables.


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

  • 第17题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）
    A

     Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.

    B

     Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.

    C

     Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.

    D

     Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.


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

  • 第18题：

    单选题
    What is true about joining tables through an equijoin?（）
    A

    You can join a maximum of two tables through an equijoin.

    B

    You can join a maximum of two columns through an equijoin.

    C

    You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.

    D

    To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.

    E

    You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.


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

  • 第19题：

    单选题
    Given the following two AS path regular expressions: "65000+ (65001|65002)" "65000(65001|65002){0,}" Which AS path matches both regular expressions?（）
    A

    65000 65001 65002

    B

    65000 65002

    C

    65001 65000

    D

    65001 65002


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

  • 第20题：

    单选题
    Which of the following grammar activities is most communicative?
    A

    Asking the students to read and correct the mistakes in the sentences.

    B

    Asking the students to tell the differences between two pictures in groups.

    C

    Asking the students to make sentences with the given words.

    D

    Asking the students to complete the translation exercises.


    正确答案： A
    解析：

  • 第21题：

    单选题
    In which of the following situations should correlation names be used?（）
    A

    A table referenced in the FROM clause has no indexed column.

    B

    The table referenced in the FROM clause has more than 200 columns.

    C

    Two or more tables in the FROM clause have identical column names.

    D

    The FROM clause contains two or more tables in the SELECT statement.


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

  • 第22题：

    单选题
    Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）
    A

    2

    B

    7

    C

    9

    D

    14


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

相关内容