Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A virtual table that cannot be accessed via SQL commands A base table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? 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; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username, Password FROM Users SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' None of these SELECT Username, Password FROM Users SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS