单选题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 SELEC

题目
单选题
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.

相似考题

1.What is true about updates through a view? ()A. You cannot update a view with group functions.B. When you update a view group functions are automatically computed.C. When you update a view only the constraints on the underlying table will be in effect.D. When you update a view the constraints on the views always override the constraints on the underlying tables.

2.In which three cases would you use the USING clause?()A.You want to create a nonequijoin.B.The tables to be joined have multiple NULL columns.C.The tables to be joined have columns of the same name and different data types.D.The tables to be joined have columns with the same name and compatible data types.E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

3.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

4.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.

更多“单选题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 SELEC”相关问题

  • 第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.

    正确答案:E

  • 第2题：

    Which two are true about aggregate functions? （）

    • A、You can use aggregate functions in any clause of a SELECT statement.
    • B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
    • C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
    • D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
    • E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
    • F、You cannot group the rows of a table by more than one column while using aggregate functions.

    正确答案:A,D

  • 第3题：

    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.

    正确答案:C,E

  • 第4题：

    Which two statements about views are true?（）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第5题：

    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 

    正确答案:C,D

  • 第6题：

    In which two cases would you use an outer join? （）

    • A、The tables being joined have NOT NULL columns.
    • B、The tables being joined have only matched data.
    • C、The columns being joined have NULL values.
    • D、The tables being joined have only unmatched data.
    • E、The tables being joined have both matched and unmatched data.
    • F、Only when the tables have a primary key/foreign key relationship.

    正确答案:C,E

  • 第7题：

    You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?（）

    • A、Create CHECK constraints on the tables. 
    • B、Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 
    • C、Create the view, specifying the WITH SCHEMABINDING option. 
    • D、Create the view, specifying the WITH CHECK option. 

    正确答案:C

  • 第8题：

    多选题
    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
    解析： 暂无解析

  • 第9题：

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


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

  • 第10题：

    单选题
    What is true about updates through a view?（）
    A

    You cannot update a view with group functions.

    B

    When you update a view group functions are automatically computed.

    C

    When you update a view only the constraints on the underlying table will be in effect.

    D

    When you update a view the constraints on the views always override the constraints on the underlying tables.


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

  • 第11题：

    多选题
    Which two statements about views are true?（）
    A

    A view can be created as read only.

    B

    A view can be created as a join on two or more tables.

    C

    A view cannot have an ORDER BY clause in the SELECT statement.

    D

    A view cannot be created with a GROUP BY clause in the SELECT statement.

    E

    A view must have aliases defined for the column names in the SELECT statement.


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

  • 第12题：

    问答题
    Practice 1　　● Your company ordered from Maximum Company 50 tables. But when the goods arrived, you found that the sides of nearly all the tables are badly scratched. The damage appears to have been caused by rough handling before dispatch.　　● You are asked to write to Mr. Cooper, sales manager of Maximum, and complain about the damage.　　● Write about 60—80 words.

    正确答案： 【参考范文】
    Dear Mr. Cooper,
    We duly received the 50 tables from you, but regret to tell you that we find that the sides of nearly all the tables are badly scratched.
    It seems that the damage has been caused by rough handling before the dispatch, so we would appreciate it if you could inform us of what measures you are about to take as for the compensation for the damage as soon as possible.
    We look forward to hearing from you soon.
    Yours sincerely,
    Signature
    解析： 暂无解析

  • 第13题：

    In which case would you use a FULL OUTER JOIN?（）

    • A、Both tables have NULL values.
    • B、You want all unmatched data from one table.
    • C、You want all matched data from both tables.
    • D、You want all unmatched data from both tables.
    • E、One of the tables has more data than the other.
    • F、You want all matched and unmatched data from only one table.

    正确答案:D

  • 第14题：

    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 clause
    • D、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

    正确答案:B,E

  • 第15题：

    What is true about updates through a view? （）

    • A、You cannot update a view with group functions.
    • B、When you update a view group functions are automatically computed.
    • C、When you update a view only the constraints on the underlying table will be in effect.
    • D、When you update a view the constraints on the views always override the constraints on the underlying tables.

    正确答案:A

  • 第16题：

    Which two statements are true regarding the usage of the SQL*Loader utility（）

    • A、You can load data into multiple tables during the same load session.
    • B、You can load data from multiple files to a table during the same load session.
    • C、You cannot perform selective data loading based on the values available in the records.
    • D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
    • E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

    正确答案:A,B

  • 第17题：

    Which two statements are true regarding the Oracle Data Pump export and import operations（）

    • A、You cannot export data from a remote database.
    • B、You can rename tables during an import operation.
    • C、You can overwrite existing dump files during an export operation.
    • D、You can compress the data during export but not the metadata because it is not supported.

    正确答案:B,C

  • 第18题：

    You have two computers named Computer1 and Computer2 that run Windows 7. You need to ensure thatyou can remotely execute commands on Computer2 from Computer1.  What should you do?（）

    • A、Run Winrm quickconfig on Computer1.
    • B、Run Winrm quickconfig on Computer2.
    • C、Enable Windows Remote Management （WinRM） through Windows Firewall on Computer1.
    • D、Enable Windows Remote Management （WinRM） through Windows Firewall on Computer2.

    正确答案:B

  • 第19题：

    You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）

    • A、Specify a view based on the archival data table and current data tables.
    • B、Specify that the data must be queried by using a stored procedure.
    • C、Specify that both the archival data table and the current data tables must have indexes created on the same columns.
    • D、Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

    正确答案:A

  • 第20题：

    单选题
    You have two computers named Computer1 and Computer2 that run Windows 7. You need to ensure thatyou can remotely execute commands on Computer2 from Computer1.  What should you do?（）
    A

    Run Winrm quickconfig on Computer1.

    B

    Run Winrm quickconfig on Computer2.

    C

    Enable Windows Remote Management （WinRM） through Windows Firewall on Computer1.

    D

    Enable Windows Remote Management （WinRM） through Windows Firewall on Computer2.


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

  • 第21题：

    多选题
    In which three cases would you use the USING clause?（）
    A

    You want to create a nonequijoin.

    B

    The tables to be joined have multiple NULL columns.

    C

    The tables to be joined have columns of the same name and different data types.

    D

    The tables to be joined have columns with the same name and compatible data types.

    E

    You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.


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

  • 第22题：

    多选题
    In which two cases would you use an outer join? （）
    A

    The tables being joined have NOT NULL columns.

    B

    The tables being joined have only matched data.

    C

    The columns being joined have NULL values.

    D

    The tables being joined have only unmatched data.

    E

    The tables being joined have both matched and unmatched data.

    F

    Only when the tables have a primary key-foreign key relationship.


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?（）
    A

    Create CHECK constraints on the tables. 

    B

    Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 

    C

    Create the view, specifying the WITH SCHEMABINDING option. 

    D

    Create the view, specifying the WITH CHECK option. 


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

相关内容