Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE ADD APPEND INSERT UPDATE ADD APPEND INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . form table file report form table file report ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False 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 IN CUSTOMER WHERE STATE = 'V'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? None of these Equijoin Self-Join Non-Equijoin None of these Equijoin Self-Join Non-Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS