The Microsoft Access wildcards are ____ and ____
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V'
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
On UPDATE CASCADE ensures which of the following
Normalization
Data Integrity
Materialized Views
All of the above
Which of the following statements is false?
Tables contain one or more rows
Rows contain one or more database of information
Databases contain one or more tables
Which portion of a database system contains the actual data elements, such as the name, address, or a phone number for a particular person?
Tables
Columns
Rows
Databases