Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE COMMIT ROLLBACK TRUNCATE DELETE COMMIT ROLLBACK TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT SUM, AVG, MULT, DIV, MIN COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT SUM, AVG, MULT, DIV, MIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has more than two 0's Feature has two 0's in it, at any position Feature ends with two 0's Feature begins with two 0's Feature has more than two 0's Feature has two 0's in it, at any position Feature ends with two 0's Feature begins with two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? BETWEEN operator LIKE operator None of these EXISTS operator BETWEEN operator LIKE operator None of these EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False ANSWER DOWNLOAD EXAMIANS APP