Q. How many relations can a delete command operate on?

View solution

Q. Insert the appropriate key word in the blank in the query ( A is a relation)
delete ______ A

where P < 5;

View solution

Q. SQL subqueries that can occur wherever a value is permitted provided the subquery gives only one tuple with a single attribute are called _________

View solution

Q. State true or false: We can use Subqueries inside the from clause

View solution

Q. The _________ construct returns true if the argument in the sub-query is void of duplicates

View solution

Q. What is a correlated sub-query?

View solution

Q. The ______ construct returns true if a given tuple is present in the subquery.

View solution

Q. The ________ comparison checker is used to check “each and every” condition

View solution

Q. State true or false : Nested Subqueries cannot be used for comparing two different sets

View solution

Q. If a set is a collection of values given by the select clause, The ______ connective tests for set membership

View solution

Q. What is a subquery?

View solution

Q. What values does the count(*) function ignore?

View solution

Q. Which keyword is used to rename the resulting attribute after the application of the aggregation function?

View solution

Q. State true or false: We can rename the resulting attribute after the aggregation function has been applied

View solution

Q. 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.

View solution

Q. The _____ aggregation operation adds up all the values of the attribute

View solution

Q. We apply the aggregate function to a group of sets of tuples using the _______ clause.

View solution

Q. State true or false: SQL does not permit distinct with count(*)

View solution

Q. Which of the following is not a built in aggregate function in SQL?

View solution

Q. Which of the following correctly describes the between predicate in the where clause?

View solution