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 :

Your Comment

Valid name is required.

Name *

Valid name is required.

Your Email *

Valid email id is required.

Related MCQ/Quiz

01st
Nov

IOS MCQ

01st
Nov

Ajax MCQ

01st
Nov

PostgreSQL MCQ Questions

PostgreSQL MCQ Questions

01st
Nov

JSON MCQ

01st
Nov

ASP.NET MCQ Questions

ASP.NET MCQ Questions

01st
Jul

Computer Vision MCQ Questions

Computer Vision MCQ Questions