Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? ROLLBACK DELETE TRUNCATE COMMIT ROLLBACK DELETE TRUNCATE COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . question mark (?); asterisk (*) underscore(_); question mark (?) asterisk (*); percent sign (%) percent sign (%); underscore (_) question mark (?); asterisk (*) underscore(_); question mark (?) asterisk (*); percent sign (%) percent sign (%); underscore (_) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? GRANT RENAME REVOKE UPDATE GRANT RENAME REVOKE UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL data definition language All of these To define the data structures To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language All of these To define the data structures To specify the syntax and semantics of SQL manipulation language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return None of these exactly 10 rows more than 10 rows less than 10 rows None of these exactly 10 rows more than 10 rows less than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS