Introduction to SQL Which of the following is valid SQL for an Index? CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . percent sign (%); underscore (_) underscore(_); question mark (?) asterisk (*); percent sign (%) question mark (?); asterisk (*) percent sign (%); underscore (_) underscore(_); question mark (?) asterisk (*); percent sign (%) question mark (?); asterisk (*) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has two 0's in it, at any position Feature begins with two 0's Feature ends with two 0's Feature has more than two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature ends with two 0's Feature has more than two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES ( INSERT INTO student VALUES ( INSERT VALUES INTO student ( INSERT student VALUES ( INSERT VALUES ( INSERT INTO student VALUES ( INSERT VALUES INTO student ( INSERT student VALUES ( ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: parenthesis -- (...) . brackets -- [...]. braces -- {...}. CAPITAL LETTERS. parenthesis -- (...) . brackets -- [...]. braces -- {...}. CAPITAL LETTERS. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS