DBMS QUIZ

Multiple Choice

What is the purpose of DBMS?

• Data Storage

• Data Management

• Data Analysis

• Data Presentation

DBMS Quiz

Multiple Choice

Name a popular data model.

• Hierarchical

• Relational

• Object-oriented

• Network

Multiple Choice

What SQL command is used to add data to a table?

• ADD

• UPDATE

• INSERT

• DELETE

Multiple Choice

Which language is commonly used for querying databases?

• Java

• C++

• SQL

• Python

Multiple Choice

What SQL keyword is used to retrieve data from a database?

• FETCH

• RETRIEVE

• SELECT

• GET

Multiple Choice

Keyword for filtering SQL query results?

• WHERE

• FILTER

• CONDITION

• SELECT

Multiple Choice

Keyword for joining tables?

• MERGE

• CONNECT

• JOIN

• COMBINE

Multiple Choice

SQL keyword for sorting results?

• SORT

• ORDER

• ARRANGE

• GROUP

Multiple Choice

SQL keyword for grouping data?

• GROUP

• SORT

• COLLECT

• AGGREGATE

Multiple Choice

SQL function for finding average?

• MEAN

• AVERAGE

• AVG

• MID

Multiple Choice

Keyword for limiting query results?

• REDUCE

• SHORTEN

• LIMIT

• MINIMIZE

Multiple Choice

Term for ensuring all rows unique?

• Singularity

• Consistency

• Uniqueness

• Validity

Multiple Choice

Type of key referencing another table?

• Secondary

• Unique

• Foreign

• Relational

Multiple Choice

Term for removing data redundancy?

• Compression

• Reduction

• Normalization

• Minimization

Multiple Choice

Function to convert text to uppercase?

• UPPER

• CAPITALIZE

• UPPERCASE

• CONVERT

Multiple Choice

What does normalization aim to reduce?

• Duplication

• Redundancy

• Complexity

• Scalability

Multiple Choice

What ensures data consistency?

• Queries

• Indexes

• Transactions

• Views

Multiple Choice

What type of key uniquely identifies each record in a table?

• Secondary

• Primary

• Foreign

• Candidate

Multiple Choice

What type of integrity ensures data accuracy across tables?

• Entity

• Referential

• Domain

• Functional

Multiple Choice

Which SQL function is used to count rows in a table?

• SUM

• MAX

• AVG

• COUNT