Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify what table we are selecting or deleting data FROM None of these specify search condition specify range for search condition specify what table we are selecting or deleting data FROM None of these specify search condition specify range for search condition ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: cannot have its results sorted using ORDER BY. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. can only be used with two tables. 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
Introduction to SQL The command to eliminate a table from a database is: UPDATE TABLE CUSTOMER; DELETE TABLE CUSTOMER; DROP TABLE CUSTOMER; REMOVE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DELETE TABLE CUSTOMER; DROP TABLE CUSTOMER; REMOVE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Definition Language(DDL) Both of above Data Manipulation Language(DML) None Data Definition Language(DDL) Both of above Data Manipulation Language(DML) None ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS