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 Which SQL statement is used to delete data FROM a database? ALTER REMOVE DELETE COLLAPSE ALTER REMOVE DELETE COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? MODIFY TABLE CHANGE TABLE None of these ALTER TABLE MODIFY TABLE CHANGE TABLE None of these ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Both of above Data Manipulation Language(DML) Data Definition Language(DDL) None Both of above Data Manipulation Language(DML) Data Definition Language(DDL) None ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints ab bc 23 gh ab bc 23 gh ANSWER DOWNLOAD EXAMIANS APP