Introduction to SQL Which of the following is valid SQL for an Index? REMOVE INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. all columns of the table are to be returned. None of these all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. all columns of the table are to be returned. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Nothing Hi TRUE FLASE Nothing Hi TRUE FLASE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCTIVE DIFFERENT DISTINCT UNIQUE DISTINCTIVE DIFFERENT DISTINCT UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS