Introduction to SQL The SQL -92 wildcards are ____ and ____ . question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Nothing TRUE Hi FLASE Nothing TRUE Hi FLASE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. True False True False 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is not a value the same as blank for character the same as 0 for integer and blank for character the same as 0 for integer not a value the same as blank for character the same as 0 for integer and blank for character the same as 0 for integer ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS