Database MCQ

Database MCQ

  • Admin
  • 17th Mar, 2023

Database is an organized collection of data. It stores data in rows and columns, called tables. The users can easily access & manage this data as per their requirements. It allows computers to store essential information in an organized and easily searchable way.

Finally, Practice Database Multiple Choice Questions to test your skills and knowledge. It will help you to gain a good understanding of database concepts.

Database MCQ Online Test

1) Which of the following option is an Open Source DBMS?

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

2) what is an instance of a database?

  • A. It is the set of memory structures that manage database files
  • B.It is the set of memory structures that create database files
  • C.It is the set of memory structures that delete database files
  • D.All of the above

3) which of the following is not a database object?

  • A. Table
  • B.Sequence
  • C.Index
  • D.Relationships

4) How many schema does database support?

  • A. 4
  • B.6
  • C.2
  • D.8

5) which language related to database?

  • A. Hyper Text Markup Language
  • B.Structured Query Language
  • C.Practical Extraction and Reporting Language
  • D.None of the above
Download Free : Database MCQ PDF

6) Which of the following is a threat to databases?

  • A. Excessive privileges
  • B.Database injection attacks
  • C.Malware & Storage media exposure
  • D.All of the above

7) Which of the following is distributed database?

  • A. A single logical database that is limited to one location
  • B.A loose collection of file that is limited to one location
  • C.A loose collection of file that is spread to multiple locations and is interconnected by a network
  • D.A single logical database that is spread to multiple locations and is interconnected by a network

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

  • A. Sybase
  • C.Oracle
  • D.MySQL

9) We use the ______ command to remove a relation from an SQL database.

  • A. Purge
  • B.Delete
  • C.Remove
  • D.Drop Table

10) Which of the following clause is used to list the attributes desired in the result of a query?

  • A. From
  • B.Select
  • C.Where
  • D.Distinct
Read Best: Database

11) Which of the following operator is used for appending two strings?

  • A. %
  • B.&
  • C.-
  • D.||

12) .......... creates a virtual relation for storing the query.

  • A. View
  • B.Function
  • C.Procedure
  • D.All of the above

13) .......... makes the transaction permanent in the database.

  • A. View
  • B.Rollback
  • C.Commit
  • D.None of the above

14) The user defined data type can be created using ..............

  • A. Create type
  • B.Create data
  • C.Create datatype
  • D.Create definetype

15) Which of the following invokes functions in sql?

  • A. Prepared Statements
  • B.Callable statements
  • C.Connection statement
  • D.None of the above
Download Free: Database PDF

16) Which of the following syntax is used to access large objects from a database ?

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

17) Is Microsoft Access an enterprise-class database product?

  • A. Yes
  • B.No

18) What does sql stands for?

  • A. Sequential Question Language
  • B.Sequential Query Language
  • C.Structured Query Language
  • D.None of the above

19) Read-only databases are ________ updated.

  • A. Never
  • B.Seldom
  • C.Always
  • D.Commonly

20) What are the correct features of a distributed database?

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

21) Which name must be unique within a database?

  • A. Field
  • B.Table
  • C.Record
  • D.Character

22) Command is used to link multiple database is .....................

  • A. JOIN
  • D.None of the above

23) A logical structure of the database is ...............

  • A. Schema
  • B.Attribute
  • C.Instance
  • D.Parameter

24) A distributed database can use ....................

  • A. Partially or totally replicated across sites
  • B.Partitioned into segments at different sites
  • C.Totally centralized at one location and accessed by many sites
  • D.None of the above

25) Database redesign is not terribly difficult if the ....................

  • A. database is structured
  • B.database has no data.
  • C.database is well-designed.
  • D.database is relatively small.

26) Which SQL command can be used to add columns to a table?

  • A. MODIFY TABLE TableName ADD ColumnName
  • B.ALTER TABLE TableName ADD ColumnName
  • C.ALTER TABLE TableName ADD COLUMN ColumnName
  • D.None of the above

27) ...................... copies of the database schema are typically used in the redesign process.

  • A. 2
  • B.3
  • C.4
  • D.5

28) ............. are the different view to present a Table.

  • A. Design View
  • B.Datasheet View
  • C.Pivot Table View
  • D.All of the above

29) Which of the following database object is ideal to view, change, and analyze data in different ways ?

  • A. Form
  • B.Table
  • C.Query
  • D.Report

30) The each category of information is called ................ in a database table.

  • A. Tuple
  • B.Field
  • C.Record
  • D.None of the above

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

Blockchain MCQ