Studied by 0 people
Looks like no one added any tags here yet for you.
What must a table in a database have at least one of?
At least one column.
What are duplicate column names not allowed in?
The same table.
What does rule 4 refer to in database management?
Data independence.
What happens if you try to create a table that already exists?
The operation fails.
What SQL command is used to delete a table and all its rows?
DROP TABLE.
What does the CREATE TABLE statement do?
It creates a new table by specifying the table name and columns.
What is the purpose of the ALTER TABLE statement?
It adds, deletes, or modifies columns in an existing table.
How are rows in a database generally treated regarding order?
Rows are not ordered and their organization on storage devices doesn't affect query results.
What datatype is used for a variable-length string up to n characters?
VARCHAR.
What does data independence allow database administrators to do?
Improve query performance by changing data organization on storage devices.
