1. Which of the following is a disadvantage of DBMS?
A. High cost
B. Improved security
C. Data sharing
D. Reduced redundancy
Answer: A
What does DBMS stand for?
A. Data Backup Management System
B. Database Management System
C. Data Build Management Software
D. Database Monitoring System
Answer: B
A database is defined as:
A. Collection of programs
B. Collection of related data
C. Collection of hardware devices
D. Collection of users
Answer: B
Which of the following is used to manage databases?
A. Compiler
B. Operating System
C. DBMS
D. Assembler
Answer: C
Which of the following is an example of DBMS software?
A. Oracle
B. MS Word
C. PowerPoint
D. Paint
Answer: A
Which language is used to query databases?
A. HTML
B. SQL
C. XML
D. Python
Answer: B
DBMS is mainly used for:
A. Data storage and retrieval
B. Playing games
C. Image editing
D. Video streaming
Answer: A
Which of the following is NOT a function of DBMS?
A. Data storage
B. Data manipulation
C. Data security
D. Word processing
Answer: D
The person who manages the database is called:
A. Programmer
B. Database Administrator
C. System Analyst
D. Operator
Answer: B
DBA stands for:
A. Database Access
B. Database Administrator
C. Data Backup Administrator
D. Database Application
Answer: B
A structured collection of data is known as:
A. File
B. Database
C. Record
D. Field
Answer: B
A row in a database table is called:
A. Column
B. Record
C. Field
D. Key
Answer: B
A column in a table is called:
A. Field
B. Record
C. Row
D. File
Answer: A
Which model organizes data in tables?
A. Hierarchical model
B. Network model
C. Relational model
D. Object model
Answer: C
The relational database model was proposed by:
A. Charles Babbage
B. E.F. Codd
C. Alan Turing
D. Bill Gates
Answer: B
In DBMS, data redundancy means:
A. Data security
B. Duplicate data
C. Data accuracy
D. Data encryption
Answer: B
One advantage of DBMS is:
A. Data inconsistency
B. Data redundancy
C. Data sharing
D. Data loss
Answer: C
Which of the following reduces data redundancy?
A. DBMS
B. Compiler
C. Operating System
D. Assembler
Answer: A
A field is also known as:
A. Attribute
B. Record
C. Table
D. File
Answer: A
A table in a relational database is also called:
A. Relation
B. Attribute
C. Key
D. Field
Answer: A
The collection of rows in a table represents:
A. Records
B. Fields
C. Keys
D. Attributes
Answer: A
Which key uniquely identifies a record in a table?
A. Foreign Key
B. Primary Key
C. Candidate Key
D. Alternate Key
Answer: B
A foreign key is used to:
A. Identify duplicate data
B. Link two tables
C. Delete records
D. Create tables
Answer: B
SQL stands for:
A. Structured Query Language
B. Standard Query Language
C. Simple Query Language
D. Sequential Query Language
Answer: A
Which SQL command is used to retrieve data?
A. SELECT
B. INSERT
C. DELETE
D. UPDATE
Answer: A
Which SQL command is used to add data into a table?
A. INSERT
B. SELECT
C. CREATE
D. DROP
Answer: A
Which command removes a table from the database?
A. DELETE
B. DROP
C. REMOVE
D. CLEAR
Answer: B
Which SQL command modifies existing data?
A. UPDATE
B. ALTER
C. INSERT
D. SELECT
Answer: A
The structure of a database is called:
A. Schema
B. Instance
C. Table
D. File
Answer: A
The actual data stored in a database at a particular time is called:
A. Schema
B. Instance
C. Relation
D. Attribute
Answer: B
Which database model uses tree structure?
A. Relational
B. Hierarchical
C. Network
D. Object
Answer: B
Which model allows many-to-many relationships?
A. Hierarchical Model
B. Network Model
C. Relational Model
D. Linear Model
Answer: B
DBMS provides:
A. Data security
B. Data integrity
C. Data sharing
D. All of these
Answer: D
Which of the following is a popular relational DBMS?
A. MySQL
B. Photoshop
C. Linux
D. Notepad
Answer: A
A database containing many tables is called:
A. File system
B. Database system
C. Table system
D. Record system
Answer: B
Data integrity means:
A. Data accuracy and consistency
B. Data deletion
C. Data duplication
D. Data compression
Answer: A
Data independence means:
A. Data stored separately
B. Data structure independent of application
C. Data without tables
D. Data with duplication
Answer: B
The smallest unit of data in a database is:
A. Bit
B. Field
C. Record
D. Table
Answer: B
A collection of related records forms a:
A. Field
B. Table
C. Attribute
D. Key
Answer: B
Database security protects:
A. Data from unauthorized access
B. Data duplication
C. Data entry
D. Data printing
Answer: A
Which component allows users to interact with the database?
A. User Interface
B. Hardware
C. Processor
D. Printer
Answer: A
Which type of key can uniquely identify records among multiple candidate keys?
A. Alternate Key
B. Primary Key
C. Composite Key
D. Foreign Key
Answer: B
Composite key is:
A. Single field key
B. Combination of two or more fields
C. Foreign key
D. Duplicate key
Answer: B
Which database stores data as objects?
A. Object-Oriented Database
B. Relational Database
C. Hierarchical Database
D. Network Database
Answer: A
DBMS mainly interacts with:
A. Users and applications
B. Hardware only
C. Software only
D. Internet only
Answer: A
Which command creates a new table?
A. CREATE
B. INSERT
C. SELECT
D. DELETE
Answer: A
Which of the following is NOT a database component?
A. Data
B. Hardware
C. Software
D. Printer
Answer: D
The process of organizing data into tables is called:
A. Normalization
B. Compilation
C. Execution
D. Sorting
Answer: A
A view in DBMS is:
A. Virtual table
B. Physical table
C. Record
D. Attribute
Answer: A
50. Which of the following is used for data backup?
A. DBMS utilities
B. Compiler
C. Interpreter
D. Assembler
Answer: A