Database MCQ Questions

Database MCQ Questions

  • Sharad Jaiswal
  • 22nd Dec, 2021

We have listed below the best Database MCQ Questions for your basic knowledge of Database. This Database MCQ Test contains 25 multiple Choice Questions. You have to select the right answer to every question.

Latest Interview Questions

img
API Testing Interview Questions 08th Aug, 2022
img
Celery Interview Questions 25th Nov, 2021
img
Solaris Interview Questions 24th Feb, 2021
img
Telematics Interview Questions 05th Mar, 2021
img
UFT Interview Questions 08th Aug, 2022
img
Terraform Interview Questions 23rd Nov, 2021

Database MCQ Questions & Answers

1) Open source Database basically used are_______

  • A. MySQL
  • B.Oracle
  • C.Microsoft Access
  • D.MS Excel

2) Database environment has all of the following components except:

  • A. Users
  • B.Database
  • C.Separate files
  • D.Database administrator

3) Data independence means:

  • A. Programs are not dependent on the logical attributes of data.
  • B.Programs are not dependent on the physical attributes of data.
  • C.Data is defined separately and not included in programs.
  • D.Both A & B

4) SET concept is used in:

  • A. Relational Model
  • B.Network Model
  • C.Hierarchical Model
  • D.None of the above

5) Set of possible data values is called______

  • A. Domain
  • B.Tuple
  • C.Degree
  • D.Attribute

6) What are the different view to present a Table?

  • A. Design View
  • B.Datasheet View
  • C.Pivote TableView
  • D.All Of Above

7) Data dictionary is a repository that manages_____

  • A. Metadata
  • B.Spell Checker
  • C.MemoryB
  • D.Data Validator

8) View of Total Database Content is:

  • A. Internal View
  • B.Physical View
  • C.External View
  • D.Conceptual View

9) ODBC stands for

  • A. open database connectivity
  • B.oracle database connectivity
  • C.object database connectivity
  • D.None of the above

10) Features of a distributed database?

  • A. Hardware independent
  • B.Network independent
  • C.Location independent
  • D.All of the above

11) Hierarchical model is also called

  • A. Table Structure
  • B.Tree structure
  • C.Plex Structure
  • D.Star Structure

12) A subset of a super key is a candidate key?

  • A. All subsets are super keys
  • B.Subset is a super key
  • C.Each subset is a super key
  • D.No proper subset is a super key

13) The number of attributes in relation is called as its

  • A. Entity
  • B.Degree
  • C.Tuples
  • D.Cardinality

14) An index is a special case of virtual view.

  • A. TRUE
  • B.FALSE

15) Which one is an Example for Network database?

  • A. Ingress
  • B.IDMS
  • C.Unify
  • D.None of the above

16) Which one of the following is not an object-based logical model?

  • A. Infological model
  • B.Binary model
  • C.Entity-relational model
  • D.None of these

17) An extent is which of the following?

  • A. Keyword that indicates that the subclass inherits from a superclass
  • B.Set of all instances of a class within a database
  • C.Keyword that indicates that the superclass inherits from a subclass
  • D.Only one instance of a class within a database

18) Data Dictionary tells the DBMS

  • A. What these file contains
  • B.What files are in Database
  • C.What attributes are possessed by data
  • D.None of the above

19) Which of the following is not a database management software?

  • A. COBOL
  • B.Oracle
  • C.MySQL
  • D.None of the above

20) One approach to standardization storing of data.

  • A. MIS
  • B.CODASYL specification
  • C.structured program
  • D.All of the above

21) Primary Key must be:

  • A. Unique
  • B.Null
  • C.Not Null
  • D.Both Unique and Not Null

22) Which language related to database?

  • A. HTML
  • B.Assembly Language
  • C.SQL
  • D.PHP

23) Which of the following invokes functions in SQL?

  • A. setBlob()
  • B.getClob()
  • C.getBlob()
  • D.All of the above

24) ______joins are sql server default.

  • A. Inner
  • B.Outer
  • C.Parallel
  • D.None of them

25) DML language is used to

  • A. Data Access
  • B.Define Schema
  • C.Define Internal
  • D.All of the above

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Latest Posts

img
Login With Google using PHP 18th Nov, 2019
img
Working with expressions In Angular JS? 01st Nov, 2019
img
What is AngularJS? Why it is Used. 16th Nov, 2019

Latest MCQ Questions

img
Arduino MCQ Questions 08th Dec, 2021
img
3D Printing MCQ 23rd Nov, 2021
img
Bioinformatics MCQ Questions 12th Mar, 2022
img
Business Intelligence MCQ 15th Apr, 2022
img
Salesforce MCQ 28th Feb, 2022
img
SAP ABAP MCQ 05th Mar, 2022

Related MCQ/Quiz

01st
Nov
Hibernate MCQ

Hibernate MCQ

01st
Nov
IOS MCQ

IOS MCQ

01st
Nov
Social Media Marketing MCQ

Social Media Marketing MCQ

01st
Nov
Django MCQ Questions

Django MCQ Questions

01st
Nov
R Programming MCQ Questions

R Programming MCQ Questions

01st
Nov
C++ MCQ Questions

C++ MCQ Questions