Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? GRANT REVOKE UPDATE RENAME GRANT REVOKE UPDATE RENAME ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To define the data structures To specify the syntax and semantics of SQL data definition language All of these To specify the syntax and semantics of SQL manipulation language To define the data structures To specify the syntax and semantics of SQL data definition language All of these To specify the syntax and semantics of SQL manipulation language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS