Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? SELECT, FROM, WHERE WHERE, FROM,SELECT FROM, WHERE, SELECT SELECT,WHERE,FROM SELECT, FROM, WHERE WHERE, FROM,SELECT FROM, WHERE, SELECT SELECT,WHERE,FROM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT APPEND UPDATE ADD INSERT APPEND UPDATE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis The order of occurrence determines the order of evaluation. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False ANSWER DOWNLOAD EXAMIANS APP