Home > BCA > Quizzes > Relational D.B.M.S.
Relational D.B.M.S.
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 21% • Most missed: “The most commonly used operation in relational algebra for projecting a set of t…”
Relational D.B.M.S.
Time left 00:00
25 Questions

1. Using which language can a user request information from a database ?
2. Select * from student join takes using (ID); The above query is equivalent to
3. In case of any shut down during transaction before commit which of the following statement is done automatically ?
4. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?
5. Which of the following statement is used to remove the privilege from the user Amir ?
6. Which of the following makes the transaction permanent in the database ?
7. The predicate in a where clause can involve Boolean operations such as and.The result of true and unknown is_______, false and unknown is _____, while unknown and unknown is _____.
8. The _______operation performs a set union of two
9. The operation which is not considered a basic operation of relational algebra is
10. _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
11. The __________ function that does not create gaps in the ordering.
12. If there are n tuples in the partition and the rank of the tuple is r , then its ________ is defined as (r -1)/(n-1) .
13. A relational database consists of a collection of
14. The term _______ is used to refer to a row.
15. Updating the value of the view
16. In SQL the statement select * from R, S is equivalent to
17. The _____________ is essentially used to search for patterns in target string.
18. Which one of the following attribute can be taken as a primary key ?
19. Which one of the following cannot be taken as a primary key ?
20. Student(ID, name, dept name, tot_cred) - In this query which attribute form the primary key?
21. The primary key must be
22. Department (dept name, building, budget) and Employee (employee_id , name, dept name,salary) -Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
23. ________ in a table represents a relationship among a set of values.
24. Any recursive view must be defined as the union of two subqueries: a _______ query that is nonrecursive and a __________ query.
25. ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.

⚡ Recently practiced quizzes in this topic
Live quiz activity
Introduction To Computers: Basics Operating Systems Review Computer Networking Practice Test Theory Of Computation System Analysis & Design Android Application Development Introduction To Computers: Operating Systems and Networking Computer Based Optimization Techniques Internet And Web Design Network Security Quiz
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.