RDBMS MCQ

RDBMS MCQ

  • Sharad Jaiswal
  • 22nd Nov, 2021

We have listed here the best RDBMS MCQ Questions for your basic knowledge of RDBMS. This RDBMS MCQ Test contains 20+ RDBMS Multiple Choice Questions. You have to select the right answer to every question to check your final preparation for the RDBMS MCQ Interview or Exams.

Practice Best RDBMS MCQ Questions;

1) A relational database consists of a collection is

  • A. Keys
  • B.Tables
  • C.Fields
  • D.Records

2) ER model is used in______

  • A. Applications
  • B.Physical refinement
  • C.Schema refinement
  • D.Conceptual database

3) The most open source RDBMS is

  • A. MySQL
  • B.Oracle
  • C.Microsoft Access
  • D.Microsoft SQL Server

4) Minimal superkeys are called______

  • A. Candidate key
  • B.Primary key
  • C.Superset key
  • D.Unique key

5) The 'NULL' represents

  • A. 0
  • B.Blank space
  • C.Absence of any value
  • D.None of the above

6) What is the full form of ACID?

  • A. Atomicity, Constant, Isolation, Durability.
  • B.Atomicity, Consistency, Indexing, Durability.
  • C.Atomicity, Consistency, Isolation, Duration.
  • D.Atomicity, Consistency, Isolation, Durability.

7) Top-to-bottom relationship among the items in a database is established by

  • A. Relational schema
  • B.Hierarchical schema
  • C.Network schema
  • D.All of the above

8) Entity is a

  • A. Model of relation
  • B.Object of relation
  • C.Thing in real world
  • D.Present working model

9) The language used application programs to request data from the DBMS:

  • A. DML(Data Manipulation Language)
  • B.DDL(Data Definition Language)
  • C.Query-language
  • D.None of the above

10) Four DML commands

  • A. CREATE, UPDATE, DELETE, SELECT
  • B.CREATE, ALTER, DELETE, SELECT
  • C.INSERT, UPDATE, DROP, SELECT
  • D.INSERT, MODIFY, DELETE, SELECT

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

  • A. Stores
  • B.Requests
  • C.Response
  • D.Represents

12) Which language can a user request information from a database

  • A. Compiler
  • B.Query
  • C.Relational
  • D.Structural

13) In SQL the cross-tabs are created using

  • A. Dice
  • B.Slice
  • C.Pivot
  • D.All of the above

14) Which one of the following attribute can be taken as a primary key?

  • A. Id
  • B.Name
  • C.Street
  • D.Department

15) Which SQL keyword is used to return only different values?

  • A. GROUP
  • B.COUNT
  • C.QUERY
  • D.DISTINCT

16) The relational model is concerned________

  • A. Data structure
  • B.Data integrity
  • C.Data manipulation
  • D.All of the above

17) In relational model the row of table is known as

  • A. Entity field
  • B.Tuple
  • C.Relation
  • D.Attribute

18) The Primary key should be chosen such that its attribute values are never

  • A. Edit
  • B.Update
  • C.Changed
  • D.Modified

19) The term attribute refers to a__________.

  • A. Key
  • B.Tuple
  • C.Column
  • D.Record

20) Union of primary keys of the related entity sets becomes are___________

  • A. Foreign key
  • B.Super Key
  • C.Primary key
  • D.Candidate key

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Nov
Ansible MCQ
01st
Nov
WPF MCQ
01st
Nov
Kotlin MCQ
01st
Jun
Docker MCQ