Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. OUTER JOIN NON-EQUIJOIN NATURAL JOIN EQUIJOIN OUTER JOIN NON-EQUIJOIN NATURAL JOIN EQUIJOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? All of these To specify the syntax and semantics of SQL manipulation language To define the data structures To specify the syntax and semantics of SQL data definition language All of these To specify the syntax and semantics of SQL manipulation language To define the data structures To specify the syntax and semantics of SQL data definition language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . percent sign (%); underscore (_) question mark (?); asterisk (*) underscore(_); question mark (?) asterisk (*); percent sign (%) percent sign (%); underscore (_) question mark (?); asterisk (*) underscore(_); question mark (?) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Data Integrity All of these Normalization Materialized Views Data Integrity All of these Normalization Materialized Views ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS