Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Rename operation. Join operation. Projection operation. Selection operation. Rename operation. Join operation. Projection operation. Selection operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. None of these all columns of the table are to be returned. all records meeting the full criteria are to be returned. all records with even partial criteria met are to be returned. None of these all columns of the table are to be returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): NOT IN only. LIKE only. Both IN and NOT IN. IN only. NOT IN only. LIKE only. Both IN and NOT IN. IN only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE REMOVE ALTER DELETE COLLAPSE REMOVE ALTER DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? REVOKE RENAME GRANT UPDATE REVOKE RENAME GRANT UPDATE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS