ICTPRG431Session 2 Introduction Database Management Systems Quiz

What does SQL stand for in database management systems?

• Structured Query Language

• Simple Query Language

• Sequential Query Language

• Standard Query Language

Which language is used for defining and manipulating data in a relational database?

• Java

• Python

• SQL

• C++

What is the purpose of DDL in SQL?

• To manipulate data

• To define data structures

• To enhance performance

• To create backups

What is the primary purpose of using SELECT, INSERT, UPDATE, and DELETE commands in SQL?

• To modify the SQL software

• To control user access and permissions

• To manage data in a database

• To configure network settings

Which SQL command is used to modify existing data within a table?

• SELECT

• INSERT

• UPDATE

• DELETE

What is the primary purpose of key constraints in relational databases?

• To link tables together

• To ensure only valid data is entered into tables

• To increase processing speed

• To duplicate data for backup purposes

What is the purpose of a primary key in a database?

• To link two tables together

• To uniquely identify a row in a table

• To set default values for a column

• To enforce data validation rules

Which of the following is true about a foreign key?

• It cannot reference a primary key in another table

• It must have a different data type than the primary key it references

• It ensures referential integrity by linking to a primary key in another table

• It must always be a unique value

What does a NULL constraint in SQL specify?

• The column must always have a numeric value

• The column cannot have duplicate values

• The column must not have any value

• The column can have empty values

What is the purpose of a unique constraint in SQL?

• To ensure all rows in a table can have identical values.

• To prevent duplicate entries in a column that is not a primary key.

• To link two tables together.

• To automatically update data in a table.