Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE ADD INSERT APPEND UPDATE ADD INSERT APPEND ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? All of these Materialized Views Normalization Data Integrity All of these Materialized Views Normalization Data Integrity ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: braces -- {...}. brackets -- [...]. parenthesis -- (...) . CAPITAL LETTERS. braces -- {...}. brackets -- [...]. parenthesis -- (...) . CAPITAL LETTERS. 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 Which of the following is a valid SQL type? NUMERIC All of these FLOAT CHARACTER NUMERIC All of these FLOAT CHARACTER ANSWER DOWNLOAD EXAMIANS APP