Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE TRUNCATE COMMIT ROLLBACK DELETE TRUNCATE COMMIT ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return exactly 10 rows None of these less than 10 rows more than 10 rows exactly 10 rows None of these less than 10 rows more than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? CHARACTER All of these FLOAT NUMERIC CHARACTER All of these FLOAT NUMERIC ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . DML HTML DDL XML DML HTML DDL XML ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS