SQL 1 – Quiz | Divex Consult

1. What does SQL stand for? *

A) System Query Logic

B) Simple Query Language

C) Structured Query Language

D) Sequential Query Language

2. What is a database? *

A) A type of spreadsheet used to store information

B) A collection of organized data that can be accessed, managed, and updated

C) A programming language for web development

D) A set of files stored on a computer

3. Which SQL command is used to create a new database? *

A) CREATE DATABASE

B) NEW DATABASE

C) ADD DATABASE

D) MAKE DATABASE

4. What is a table in SQL? *

A) A visual representation of data only

B) A temporary storage space in SQL

C) A single column of information in a database

D) A collection of rows and columns that store structured data

5. What is the purpose of a schema in a database? *

A) To define the structure of the database, including tables, views, and relationships

B) To delete tables from a database

C) To store temporary query results

D) To restrict access to a database

6. Which of the following is TRUE about a Primary Key? *

A) It can be NULL

B) It allows duplicate values

C) It uniquely identifies each record in a table

D) It is only used for sorting data

7. What is the relationship between a schema and a table in SQL? *

A) A schema organizes tables and other database objects

B) A table is the same as a schema

C) A schema is only used for security purposes

D) A table cannot exist within a schema

8. Which of the following is NOT a characteristic of a well-designed SQL table? *

A) It has a primary key for unique identification

B) It contains only one column

C) It is organized into rows and columns

D) It can store different data types

9. Why is defining data types important when creating a table in SQL? *

A) It ensures data integrity and proper storage

B) It makes the table visually appealing

C) It allows duplicate data

D) It automatically creates relationships between tables

10. How does SQL help maintain data consistency in a database? *

A) By using constraints like PRIMARY KEY and FOREIGN KEY

B) By allowing unrestricted data entry

C) By automatically deleting duplicate records

D) By requiring manual checks for every entry

Structured Query Language(SQL)

SQL 1 – Quiz