SQL and Database Management Quiz

What does ADBMS stand for?

• Advanced Data Backup Management System

• Advanced Database Management System

• Advanced Data and Backup Monitoring System

• Advanced Design of Business Management System

Which is the key tool commonly used with ADBMS?

• MongoDB

• Oracle

• MySQL

• PostgreSQL

Which of the following is NOT a feature of MySQL?

• Relational data management

• Supports ACID properties

• Lack of scalability

• Open-source availability

What is the role of normalization in a database?

• To create complex queries

• To reduce data redundancy

• To encrypt data

• To define foreign keys

Which XAMPP component is responsible for managing databases?

• Apache

• PHP

• MySQL

• Perl

What is the main goal of an ERD (Entity-Relationship Diagram)?

• To analyze queries

• To visually represent database structure

• To test data security

• To execute SQL views

SQL Views are used to:

• Store physical data

• Automate database processes

• Provide data abstraction and simplify queries

• Create temporary tables

Which of the following enhances security by controlling user access?

• Encryption

• Stored Procedures

• SQL Views

• Authentication

Which command defines a database structure?

• DDL

• DML

• DCL

• TCL

Which of the following SQL commands maintains and queries data?

• DDL

• DML

• DCL

• TCL