18 Questions
What is the purpose of a primary key in a database table?
To uniquely identify all table records
What must be true about values in a primary key column?
They must be unique
When does a primary key become a composite key?
When it consists of more than one column
What is the purpose of a foreign key in SQL?
To refer to other tables
What is the main feature of a primary key regarding null values?
It cannot contain null values
Which SQL command is used to add a new row into a table?
INSERT
What SQL operation is used to connect the client and server in a database system?
CONNECT
Which SQL JOIN operation produces the cartesian product of two tables?
Cross Join
In an SQL Inner Join, how are tables combined?
Based on a common column
What does a RIGHT OUTER JOIN retrieve in SQL?
All records from the right table and matching records from the left table
What does a Self Join in SQL involve?
Joining a table to itself
What is the purpose of the DISCONNECT statement in database operations?
To end the connection between client and server
What command is used in SQL to retrieve data from a table?
SELECT
In the context of SQL, what does the term 'table' refer to?
An unordered collection of rows
Which SQL command is used to create an empty table?
CREATE TABLE
What is the purpose of the WHERE clause in an SQL query?
To filter rows based on conditions
In Interactive SQL, what happens when you type a command to ask the database a question?
The database shows you the answer immediately
What does the SQL INSERT statement primarily do?
Enter data into a table
Learn about the rules and requirements for creating tables in a database, including unique table names, unique column names, and the use of primary keys to uniquely identify records.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free