Database MCQ Online Test

  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 ..............
Database MCQ

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.

  • Oracle
  • MySQL
  • Microsoft Access
  • None of the above
View Answer
  • It is the set of memory structures that manage database files
  • It is the set of memory structures that create database files
  • It is the set of memory structures that delete database files
  • All of the above
View Answer
  • Table
  • Sequence
  • Index
  • Relationships
View Answer
  • 4
  • 6
  • 2
  • 8
View Answer
  • Hyper Text Markup Language
  • Structured Query Language
  • Practical Extraction and Reporting Language
  • None of the above
Download Free : Database MCQ PDF
View Answer
  • Excessive privileges
  • Database injection attacks
  • Malware & Storage media exposure
  • All of the above
View Answer
  • A single logical database that is limited to one location
  • A loose collection of file that is limited to one location
  • A loose collection of file that is spread to multiple locations and is interconnected by a network
  • A single logical database that is spread to multiple locations and is interconnected by a network
View Answer
  • Sybase
  • COBOL
  • Oracle
  • MySQL
View Answer
  • Purge
  • Delete
  • Remove
  • Drop Table
View Answer
  • From
  • Select
  • Where
  • Distinct
Read Best: Database
View Answer
  • %
  • &
  • -
  • ||
View Answer
  • View
  • Function
  • Procedure
  • All of the above
View Answer
  • View
  • Rollback
  • Commit
  • None of the above
View Answer
  • Create type
  • Create data
  • Create datatype
  • Create definetype
View Answer
  • Prepared Statements
  • Callable statements
  • Connection statement
  • None of the above
Download Free: Database PDF
View Answer
  • setBlob()
  • getClob()
  • getBlob()
  • All of the above
View Answer
  • Yes
  • No
View Answer
  • Sequential Question Language
  • Sequential Query Language
  • Structured Query Language
  • None of the above
View Answer
  • Never
  • Seldom
  • Always
  • Commonly
View Answer
  • Location independent
  • Hardware independent
  • Network independent
  • All of the above
View Answer
  • Field
  • Table
  • Record
  • Character
View Answer
  • JOIN
  • UPDATE
  • SET RELATION
  • None of the above
View Answer
  • Schema
  • Attribute
  • Instance
  • Parameter
View Answer
  • Partially or totally replicated across sites
  • Partitioned into segments at different sites
  • Totally centralized at one location and accessed by many sites
  • None of the above
View Answer
  • database is structured
  • database has no data.
  • database is well-designed.
  • database is relatively small.
View Answer
  • MODIFY TABLE TableName ADD ColumnName
  • ALTER TABLE TableName ADD ColumnName
  • ALTER TABLE TableName ADD COLUMN ColumnName
  • None of the above
View Answer
  • 2
  • 3
  • 4
  • 5
View Answer
  • Design View
  • Datasheet View
  • Pivot Table View
  • All of the above
View Answer
  • Form
  • Table
  • Query
  • Report
View Answer
  • Tuple
  • Field
  • Record
  • None of the above
View Answer