Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Default values Data types All of these Primary keys Default values Data types All of these Primary keys ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . XML HTML DDL DML XML HTML DDL DML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. ONLY DISTINCT SINGLE UNIQUE ONLY DISTINCT SINGLE UNIQUE 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; None of these SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; None of these SELECT SYSDATE - SYSDATE FROM DUAL; 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 Data Definition Language(DDL) Both of above Data Manipulation Language(DML) None Data Definition Language(DDL) Both of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS