Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as 0 for integer the same as blank for character not a value the same as 0 for integer and blank for character the same as 0 for integer the same as blank for character not a value the same as 0 for integer and blank for character ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return more than 10 rows None of these less than 10 rows exactly 10 rows more than 10 rows None of these less than 10 rows exactly 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints garbage is illegal prints 045.926 prints 50 prints garbage is illegal prints 045.926 prints 50 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS