Introduction to SQL Indexes can usually be created for both primary and secondary keys. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? REMOVE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; CREATE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can only be used with two tables. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can only be used with two tables. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE AS SAVE UPDATE MODIFY SAVE AS SAVE UPDATE MODIFY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS