Chapter 6 Relational Algebra and SQL MCQs

15 min Score: 0 Attempted: 0/15 Subscribe
1. Which of the following is not a built-in aggregate function in SQL?





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





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





4. Which of the following is not a valid aggregate function?





5. Which data manipulation command is used to combines the records from one or more tables?





6. Which type of JOIN is used to returns rows that do not have matching values?





7. Which of the following is not a DDL command?





8. ___ is not a category of Database language.





9. DCL provides commands to perform actions like





10. The result of a SQL SELECT statement is a ______.





11. Which of the following do you need to consider when you make a table in SQL?





12. Which of the following are TCL commands?





13. Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.





14. Which of the following is a fundamental operation in relational algebra?





15. The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.





Contents Copyrights Reserved By T4Tutorials