1. Which of the following is not a built-in aggregate function in SQL?
(A) Avg
(B) Max
(C) Count
(D) Total
2. The _____ aggregation operation adds up all the values of the attribute?
(A) Add
(B) Sum
(C) Max
(D) Avg
3. What values does the count (*) function ignore?
(A) Repetitive values
(B) Integers
(C) Characters
(D) Null values
4. Which of the following is not a valid aggregate function?
(A) COUNT
(B) SUM
(C) COMPUTE
(D) MAX
5. Which data manipulation command is used to combines the records from one or more tables?
(A) JOIN
(B) PROJECT
(C) SELECT
(D) PRODUCT
6. Which type of JOIN is used to returns rows that do not have matching values?
(A) Outer JOIN
(B) Natural JOIN
(C) EQUI JOIN
(D) All of the above
7. Which of the following is not a DDL command?
(A) UPDATE
(B) TRUNCATE
(C) ALTER
(D) None of the Mentioned
8. ___ is not a category of Database language.
(A) TCL
(B) DDL
(C) DCL
(D) SCL
9. DCL provides commands to perform actions like
(A) Change the structure of Tables
(B) Authorizing Access and other control over Database
(C) Insert, Update or Delete Records and Values
(D) None of Above
10. The result of a SQL SELECT statement is a ______.
(A) file
(B) report
(C) form
(D) table
11. Which of the following do you need to consider when you make a table in SQL?
(A) All of the above
(B) Primary keys
(C) Default values
(D) Data types
12. Which of the following are TCL commands?
(A) COMMIT and ROLLBACK
(B) UPDATE and TRUNCATE
(C) SELECT and INSERT
(D) GRANT and REVOKE
13. Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
(A) Relational
(B) Procedural
(C) Structural
(D) Fundamental
14. Which of the following is a fundamental operation in relational algebra?
(A) Set intersection
(B) Natural Join
(C) Assignment
(D) Select
15. The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
(A) Union
(B) Intersection
(C) Difference
(D) Set-difference