Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? None of these IS NULL operator EXISTS operator NOT operator None of these IS NULL operator EXISTS operator NOT operator 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. UNIQUE SINGLE ONLY DISTINCT UNIQUE SINGLE ONLY DISTINCT 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 None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None Data Definition Language(DDL) Data Manipulation Language(DML) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000? SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS