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

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

相似考题

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

2.You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

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

4.You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.What should you do?A．Select the commit on successful completion check box of the DTS package.B．Select the commit transaction on successful completion of this step check box of the customers transform. data task.C．Select the commit transaction on successful completion of this step check box of the sales transform. data task.D．Select the commit transaction on successful completion of this step check box of both transform. data tasks.

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

  • 第1题：

    You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.

    You want to minimize changes to your security model and to your database applications. How should you modify the database?

    A．Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.

    B．Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.

    C．Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.

    D．Create a view of the lookup tables. Use the view to allow users access to the lookup tables.


    正确答案：A
    解析：Explanation:SQLServer2000allowsfilegroupsotherthantheprimaryfilegrouptobemarkedasreadonly.Afilegroupthatismarkedread-onlycannotbemodified.Tablesthatmustnotbemodifiedcanbeplacedonafilegroupthatcanthenbemarkasread-only.Thiswillpreventsaccidentalupdates.IncorrectAnswers:B:Thissolutioneffectivelypermitsalluserstomodifyanytableinthedatabase,astheywouldallhaveSELECTpermissionstothedatabase.C:ThissolutionwilleffectivelypreventallusersfrombeingabletoperformingthesetasksonalltablesinthedatabaseastheyaredeniedpermissionstorunINSERT,UPDATE,orDELETEstatementsagainstthedatabase.Abettersolutionwouldbetoapplythedenypermissionsatthetablelevelofthelookuptables.Thiswould,however,requireunnecessaryadministrativetime.D:Viewsarevirtualtablesthatareusedtofiltertablesorrowsthattheusersshouldnothaveaccessto,however,iftheusershaveaccesstothebasetables,theycanstillrunINSERT,UPDATE,andDELETEstatementsagainstthebasetable.

  • 第2题：

    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data

    正确答案:C

  • 第3题：

    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

  • 第4题：

    In which scenario will you create a sorted hash cluster？ （）

    • A、 if the application uses queries joining tables only occasionally
    • B、 if the full table scan is executed often on only one table of the clustered tables
    • C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
    • D、 when you want the data to be returned automatically in the chronological order

    正确答案:D

  • 第5题：

    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、 Flash back all the tables in the data file， one by one.
    • B、 Restore the data file to a new location and perform a media recovery.
    • C、 Flash back the database， there is no need to restore the data file.
    • D、 Restore the data file from the most recent backup and flash the database.

    正确答案:B

  • 第6题：

    In which scenario will you create a hash cluster？（）

    • A、 when you want the data to be returned automatically in chronological order
    • B、 if the application uses queries joining tables only occasionally
    • C、 if the queries against the clustered table use the equality operator （=） to retrieve the desired row
    • D、 if the full table scan is executed often on only one of the clustered tables

    正确答案:C

  • 第7题：

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

  • 第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 data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
    A

     Flash back all the tables in the data file， one by one.

    B

     Restore the data file to a new location and perform a media recovery.

    C

     Flash back the database， there is no need to restore the data file.

    D

     Restore the data file from the most recent backup and flash the database.


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

  • 第10题：

    单选题
    In which scenario will you create a hash cluster？（）
    A

     when you want the data to be returned automatically in chronological order

    B

     if the application uses queries joining tables only occasionally

    C

     if the queries against the clustered table use the equality operator （=） to retrieve the desired row

    D

     if the full table scan is executed often on only one of the clustered tables


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

  • 第11题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第12题：

    单选题
    While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which type of tables would you use to achieve these objectives？（）
    A

    heap tables

    B

    object tables

    C

    partitioned tables

    D

    index-organized tables （IOTs）


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

  • 第13题：

    A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、flash back all the tables in the data file， one by one
    • B、restore the data file to a new location and perform a media recovery
    • C、flash back the database; there is no need to restore the data file
    • D、restore the data file from the most recent backup and flash back the database

    正确答案:B

  • 第14题：

    While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which type of tables would you use to achieve these objectives？（）

    • A、heap tables
    • B、object tables
    • C、partitioned tables
    • D、index­organized tables （IOTs）

    正确答案:D

  • 第15题：

    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

  • 第16题：

    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data.

    正确答案:C

  • 第17题：

    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

    • A、use the external table population
    • B、use the Oracle Data Pump export and import utility
    • C、use the conventional path data load of SQL*Loader utility
    • D、use the direct path data load of Oracle export and import utility

    正确答案:C

  • 第18题：

    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

  • 第19题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data


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

  • 第20题：

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

  • 第21题：

    单选题
    In which scenario will you create a sorted hash cluster？ （）
    A

     if the application uses queries joining tables only occasionally

    B

     if the full table scan is executed often on only one table of the clustered tables

    C

     if the data for all the rows of a cluster key value exceeds one or two Oracle blocks

    D

     when you want the data to be returned automatically in the chronological order


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

  • 第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题：

    单选题
    A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
    A

    flash back all the tables in the data file， one by one

    B

    restore the data file to a new location and perform a media recovery

    C

    flash back the database; there is no need to restore the data file

    D

    restore the data file from the most recent backup and flash back the database


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

  • 第24题：

    单选题
    While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which type of tables would you use to achieve these objectives？（）
    A

     heap tables

    B

     object tables

    C

     partitioned tables

    D

     index-organized tables （IOTs）


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

相关内容