Q. Scalar Subqueries can be used in the SQL update statement when they are used under the ____ clause

View solution

Q. State true or false: We cannot write a where clause under an update command

View solution

Q. To change a value in a tuple without changing all the values in the tuple, we use the _____ statement

View solution

Q. What is the format of entering date into a database while inserting data into it?

View solution

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