17th
Mar

Database MCQ

Admin
17th Mar, 2023
406 Followers

Database Quiz
Database Online Test

Database MCQ Questions

1. Which of the following option is an Open Source DBMS?
2. what is an instance of a database?
3. which of the following is not a database object?
4. How many schema does database support?
5. which language related to database?
6. Which of the following is a threat to databases?
7. Which of the following is distributed database?
8. Which of the following is not a database management software?
9. We use the ______ command to remove a relation from an SQL database.
10. Which of the following clause is used to list the attributes desired in the result of a query?
11. Which of the following operator is used for appending two strings?
12. .......... creates a virtual relation for storing the query.
13. .......... makes the transaction permanent in the database.
14. The user defined data type can be created using ..............
15. Which of the following invokes functions in sql?
16. Which of the following syntax is used to access large objects from a database ?
17. Is Microsoft Access an enterprise-class database product?
18. What does sql stands for?
19. Read-only databases are ________ updated.
20. What are the correct features of a distributed database?

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
B.COBOL
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
B.UPDATE
C.SET RELATION
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

Database FAQs

What is the Database?

Data is a small part of any information. It is a fact relating to a person, thing, or place. The systematic arrangement of data in any computer is called the database. The database provides easy and organized data storage. It is well-equipped so it is easy to access and manage the data. It is an application that is widely used to develop, update, manage, and delete data. We can store data sequentially in the database which is also known as shortening. The database also provides high security and privacy. Many dynamic websites on the Internet such as Facebook, Twitter, or YouTube use databases to manage our data.

Types of Database

There are various types of databases. these are

Centralized database
Cloud database
Commercial database
Distributed database
End-user database
Graph database
NoSQL database
Object-oriented database
Relational Database, etc.

Types of database languages

Database Languages can be categorized into four types. These are -

DDL or Data Definition Language
DML or Data Manipulation Language
DCL or Data Control Language
TCL or Transaction Control Language

The uses of database

A database is a collection of raw data. It is used for:

Storing a huge amount of data.
Storing important information and data.
Solving the multiple access of data simultaneously.
Storing the data and providing the facilities to search for any specific information.