Dr Kalyan's - Quiz on Dbase & SQL

What is a database?

• A collection of random data

• A systematic collection of data

• A hardware component

• A type of software

Which of the following is a type of database that uses tables to define relationships?

• Cloud database

• NoSQL database

• Relational database

• Distributed database

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• Structured Quick Language

Which of the following is NOT a component of a database?

• Data

• Software

• Hardware

• User Interface

What is the purpose of normalization in databases?

• To increase data redundancy

• To improve data retrieval speed

• To reduce data redundancy

• To enhance data security

Which SQL command is used to remove records from a table?

• DELETE

• REMOVE

• DROP

• CLEAR

What is a primary key in a database?

• A unique identifier for a record

• A key used for foreign relationships

• A key that can be duplicated

• A key that can be NULL

Which of the following is a characteristic of NoSQL databases?

• They require complex joins

• They are strictly relational

• They use SQL for querying

• They can handle large volumes of unstructured data

What SQL clause is used to sort the result set?

• SELECT

• GROUP BY

• WHERE

• ORDER BY

Which SQL keyword is used to eliminate duplicate records?

• FOREIGN KEY

• PRIMARY KEY

• UNIQUE

• DISTINCT