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;