Database, DBMS, and SQL Reviewer Quiz

Which of the following is the traditional way of storing and managing information?

• a. Cloud Database

• b. Manual Database

• c. Relational Database

• d. Electronic Database

Why do manual databases become ineffective when handling large amounts of data?

• a. They require the internet

• b. They cannot store text data

• c. They are too expensive to use

• d. They are difficult to search and prone to errors

What is the main purpose of a DBMS?

• a. To manage data effectively and efficiently

• b. To delete files permanently

• c. To serve as a backup software

• d. To replace operating systems

Which of the following is NOT a function of a DBMS?

• a. Data storage

• b. Data retrieval

• c. Printing hard copies automatically

• d. Data manipulation

In DBMS, which process involves saving data into memory for future use?

• a. Manipulation

• b. Storage

• c. Distribution

• d. Deletion

Converting raw facts into useful information through DBMS falls under which process?

• a. Storage

• b. Distribution

• c. Deletion

• d. Manipulation

SQL is primarily used to…

• a. Communicate with databases

• b. Create spreadsheets

• c. Replace operating systems

• d. Design graphics

Which environment should programmers use to test queries before live deployment?

• a. Production

• b. Backup

• c. Development

• d. Security

Which SQL environment holds real data for business operations?

• a. Backup Database

• b. Production Database

• c. Development Database

• d. Security Database

Which SQL query displays all student names from the Students table?

• a. SHOW Students;

• b. GET StudentName FROM Students;

• c. SELECT * FROM Students;

• d. SELECT StudentName FROM Students;