KC 3 - Database

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

• To create a unique identifier for each row in a table

• To define the relationships between tables

• To store text data in a table

• To perform mathematical operations on data

What SQL statement is used to create a table inside a database?

• DEFINE TABLE

• INSERT TABLE

• ADD TABLE

• CREATE TABLE

Which data type represents a date in SQL?

• INTEGER

• DECIMAL

• CHAR

• DATE

What is the purpose of a foreign key in a table?

• To create a unique identifier for each row in a table

• To store text data in a table

• To define the relationships between tables

• To perform mathematical operations on data

Which data type represents a floating point number in SQL?

• DECIMAL

• CHAR

• INTEGER

• FLOAT

What is the purpose of constraints in a database?

• To perform calculations on data

• To store large text data

• To define the relationships between tables

• To enforce limits on the type of data that can go into a table

Which SQL sublanguage group is used to view, add, change, or delete data in a table?

• Data manipulation language (DML)

• Data definition language (DDL)

• Data control language (DCL)

• Structured query language (SQL)

What is the purpose of reserved terms in SQL?

• To define the relationships between tables

• To have specific meanings when being processed

• To enforce limits on the type of data that can go into a table

• To control access to the data in a database

Which data type represents a large character string or text data in SQL?

• CHAR

• VARCHAR

• CLOB

• DECIMAL

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

• To perform mathematical operations on data

• To store text data in a table

• To define the relationships between tables

• To create a unique identifier for each row in a table