Rdbms MCQ Quiz

Take Rdbms Quiz To test your Knowledge 

Below are few Rdbms MCQ test that checks your basic knowledge of Rdbms. This Rdbms Test contains around 20 questions of multiple choice with 4 options. You have to select the right answer to a question. You can see the correct answer by clicking view answer link.

Also, Read Best Rdbms interview questions.

1. A RDBMS consists a collection of ?

  • Tables
  • Fields
  • Records
  • Keys
View Answer

2. The term attribute refers to a ___________ of a table.

  • Record
  • Tuple
  • Column
  • Key
View Answer

3. In relational model, the row of table is known to be ?

  • Relation
  • Entity field
  • Tuple
  • Attribute
View Answer

4. Address field of a person should not be part of primary key, since it is likely to ?

  • Dependent
  • Too long
  • Changed
  • Not changed
View Answer

5. The relational model is concerned with ?

  • Data structure and Data integrity
  • Data Manipulation
  • Both A and B
  • None of these
View Answer

6. Which is the false statement from the following ?

  • A veiw is a named derived table
  • A name relation is variable
  • A veiw is a named reation and is virtual
  • None of these
View Answer

7. The union of primary keys of the related entity sets becomes a -------------------------- of the relation ?

  • Super Key
  • Candidate key
  • Foreign key
  • Primary key
View Answer

8. What is the full form of RDBMS ?

  • Right Database Management System
  • Relational Database Management system
  • Rapid Database Management System
  • Route Database Management System
View Answer

9. In a relational Database a referential integrity constraint cab be specified with the help of ;

  • Primary Key
  • Secondry key
  • Foreign key
  • None of these
View Answer

10. Primary key should be chosen such that its attribute values are

  • Updated
  • Changed
  • Dependent
  • None of these
View Answer

11. Query language is a language in which a user ?

  • Requests
  • Stores
  • Response
  • Represents
View Answer

12. Minimal superkeys are called ?

  • Unique key
  • Superset key
  • Candidate key
  • Primary key
View Answer

13. A table is a collection of relationships, there is a close correspondence between concept of :

  • Tables and instances
  • Table and variables
  • Tables and relations
  • Tables and Entries
View Answer

14. Contents of a relation instance may change with time as relation :

  • Domain
  • Retrieved
  • Updated
  • Time
View Answer

15. Query languages used in practice includes

  • Elements
  • Instances
  • Tuples
  • Fields
View Answer

16. Logical design of database, is known to be

  • Database relation
  • Database instance
  • Database entity
  • Database Schema
View Answer

17. A domain is atomic if elements of the domain are considered to be ____________ units.

  • Different
  • Indivisbile
  • Constant
  • Divisible
View Answer

18. Which one of the following is a procedural language ?

  • Domain relational calculus
  • Tuple relational calculus
  • Query language
  • Relational algebra
View Answer

19. The _______operation performs a set union of two “similarly structured” tables :

  • Intersect
  • Product
  • Union
  • Join
View Answer

20. Which is the operator, takes the results of two queries and returns only rows that appear in both result sets ?

  • Union
  • Projection
  • Difference
  • Intersect
View Answer

21. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

  • Select
  • Intersection
  • Union
  • Join
View Answer

Write For Us.

Contribute the Community.