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.

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
  • 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

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.

Related MCQ/Quiz

Hibernate MCQ