Introduction to SQL ON UPDATE CASCADE ensures which of the following? Materialized Views Normalization All of these Data Integrity Materialized Views Normalization All of these Data Integrity ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Manipulation Language(DML) None Both of above Data Definition Language(DDL) Data Manipulation Language(DML) None Both of above Data Definition Language(DDL) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: ORDER BY. GROUP BY. SORT BY. None of these ORDER BY. GROUP BY. SORT BY. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCTIVE UNIQUE DISTINCT DIFFERENT DISTINCTIVE UNIQUE DISTINCT DIFFERENT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS