Quiz 3 (Week 202)

wildcard operator in SQL statements?

*

What steps should be followed when preparing to create a table?

1. data type and length for each attribute 2. columns that should accept null values 3. columns that need to be unique 4. primary-foreign key mates 5. default values 6. columns for which domain constraints, such as check, 7. Create the table and any indexes using create table and create index statements

Which of the following is a technique for optimizing the internal performance of the relational data model? A. Avoiding indexes on secondary keys B. Clustering data C. Not reporting statistics to save machine resources D. Using random index organizations

B

Which of the following is true of the order in which SQL statements are evaluated? A. The SELECT clause is always processed first. B. The SELECT clause is always processed last. C. The SELECT clause is processed before the ORDER BY clause. D. The GROUP BY clause is processed before the WHERE clause.

C

--------is a set of commands used to control a database, which includes security.

DCL data control language

________ is a set of commands used to update and query a database.

DML DATA MANIPULATION LANGUAGE

When creating a table, it is not important to consider foreign keyprimary key mates TRUE FALSE

False

finds all groups meeting stated conditions? A. HAVING B. FIND C. WHERE D.SELECT

HAVING

Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T;

How many products have product descriptions in the Product Table?

What three clauses are contained in most SQL retrieval statements?

SELECT FROM WHERE

Which of the following will produce the minimum of all standard prices?

SELECT MIN(standard_price) FROM Product_V;

When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included. TRUE FALSE

TRUE

When creating tables, it's important to decide which columns will allow null values before the table is created TRUE FALSE

TRUE

SELECT command lists

columns and calculated expression from base tables. EXAMPLE SELECT atributeName , orNames FROM tableName WHERE atributeName =<> specific value;

WHERE used to

specify conditions for selection of rows in the result set. EXAMPLE SELECT atributeName , orNames FROM tableName WHERE atributeName (column)=<> specific value;

FROM identifies

tables and views which we want to gather data from in the query. EXAMPLE SELECT atributeName , orNames FROM tableName WHERE atributeName =<> specific value;