DBMS - SQL MCQ

Database

Title
Using the _______ clause retains only one copy of identical tuples
Observe the following query and choose the correct option
What will be the result of the following query?
Which of the following correctly describes the between predicate in the where clause?
Which of the following is not a built in aggregate function in SQL?
Observe the given SQL query and choose the correct option
State true or false: SQL does not permit distinct with count(*)
We apply the aggregate function to a group of sets of tuples using the _______ clause
Choose the correct option regarding the query:
The _____ aggregation operation adds up all the values of the attribute
State true or false: Any attribute which is present in the having clause without being aggregated must not be present in the group by clause
Which keyword is used to rename the resulting attribute after the application of the aggregation function?
What values does the count(*) function ignore?
What is a subquery?
If a set is a collection of values given by the select clause, The ______ connective tests for set membership
State true or false : Nested Subqueries cannot be used for comparing two different sets
What is the result of the following query?
The ________ comparison checker is used to check “each and every” condition
The ______ construct returns true if a given tuple is present in the subquery
What is a correlated sub-query?

Questions

Views

Best Answers

Points