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

第1题：

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.

第2题：

Which three statements are true regarding subqueries?（）

• A、Subqueries can contain GROUP BY and ORDER BY clauses 
• B、Main query and subquery can get data from different tables 
• C、Main query and subquery must get data from the same tables 
• D、Subqueries can contain ORDER BY but not the GROUP BY clause 
• E、Only one column or expression can be compared between the main query and subquery
• F、 Multiple columns or expressions can be compared between the main query and subquery

第3题：

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.

第4题：

The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）

• A、Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 
• B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
• C、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 
• D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. 
• E、Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 
• F、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.

第5题：

36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）

• A、Rows 
• B、Totals 
• C、Columns 
• D、Cells 
• E、Data

第6题：

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 

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）

• A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
• B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
• C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
• D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
• E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

第15题：

Which three statements about subqueries are true? （）

• A、A main query can have more than one subquery.
• B、A subquery can have more than one main query.
• C、The subquery and main query must retrieve data from the same table.
• D、The subquery and main query can retrieve data from different tables.
• E、Only one column or expression can be compared between the subquery and main query.
• F、Multiple columns or expression can be compared between the subquery and main query.

第16题：

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.

第17题：

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.

第18题：

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

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：