Introduction to SQL Which of the following is valid SQL for an Index? ADD INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; 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 The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of columns. distinct values. values. groups. columns. distinct values. values. groups. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Materialized Views Data Integrity Normalization All of these Materialized Views Data Integrity Normalization All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS