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 Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? BETWEEN operator EXISTS operator LIKE operator None of these BETWEEN operator EXISTS operator LIKE operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCT UNIQUE DIFFERENT DISTINCTIVE DISTINCT UNIQUE DIFFERENT DISTINCTIVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEN AVG JOIN LEFT LEN AVG JOIN LEFT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of distinct values. groups. values. columns. distinct values. groups. values. columns. ANSWER DOWNLOAD EXAMIANS APP