Databases (Week 02)

Which of the following are types of relations in SQL?

• Stored relations

• Views

• Temporary tables

• All of the above

Which SQL data type stores a fixed-length string of up to 8000 characters?

• VARCHAR(n)

• CHAR(n)

• NCHAR(n)

• TEXT

Which of the following is a valid SQL data type for storing dates?

• TEXT

• DATETIME

• VARCHAR

• CHAR

What does the `IDENTITY` property in SQL define?

• The data type of a column

• The default value for a column

• The initial value and increment step for a column

• The foreign key constraint

Which of the following SQL commands is used to delete a table?

• DELETE TABLE

• DROP TABLE

• REMOVE TABLE

• ERASE TABLE

What is the purpose of the `DEFAULT` option in SQL?

• To specify the default data type

• To specify a default value for an attribute

• To modify the table structure

• To define the primary key

Which of the following SQL data types are used for fixed precision and scale numbers?

• FLOAT

• DECIMAL(p,s) or NUMERIC(p,s)

• INT

• DATETIME

Which command is used to modify the name of an existing database?

• ALTER DATABASE

• MODIFY DATABASE

• RENAME DATABASE

• UPDATE DATABASE

Which of the following is a valid SQL statement to declare a primary key in a table?

• CREATE TABLE TableName PRIMARY KEY (Attribute)

• ALTER TABLE TableName ADD PRIMARY KEY (Attribute)

• BOTH A and B

• None of the above

Which of the following is an example of a valid SQL command to insert data into a table?

• INSERT INTO TableName (Attribute1, Attribute2) VALUES (Value1, Value2)

• INSERT TableName (Attribute1, Attribute2) VALUES (Value1, Value2)

• ADD INTO TableName (Attribute1, Attribute2) VALUES (Value1, Value2)

• None of the above