Introduction to SQL SQL data definition commands make up a(n) ________ . XML DML HTML DDL XML DML HTML DDL 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 more than 10 rows exactly 10 rows less than 10 rows None of these more than 10 rows exactly 10 rows less than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? SORT SORT BY ORDER ORDER BY SORT SORT BY ORDER ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ORDER BY can be combined with the SELECT statements. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Default values All of these Data types Primary keys Default values All of these Data types Primary keys ANSWER DOWNLOAD EXAMIANS APP