What does SQL stand for?
Structured Query Language
True or False: Oracle SQL is a proprietary version of SQL.
True
Fill in the blank: The primary function of SQL is to ________ data in a database.
manipulate
What is the command used to retrieve data from a database in Oracle SQL?
SELECT
Which clause is used to filter records in a SQL query?
WHERE
True or False: The ORDER BY clause is used to sort the result set.
True
What command is used to add a new record to a table in Oracle SQL?
INSERT
What is the purpose of the UPDATE statement in SQL?
To modify existing records in a table
Which SQL command is used to remove records from a table?
DELETE
Fill in the blank: In Oracle SQL, a ________ is a collection of related data entries.
table
What is a primary key in a database?
A unique identifier for a record in a table
True or False: A foreign key is used to establish a relationship between two tables.
True
What does the acronym DML stand for?
Data Manipulation Language
Which SQL statement is used to create a new table?
CREATE TABLE
What is the purpose of the GROUP BY clause?
To arrange identical data into groups
Fill in the blank: The ________ function is used to count the number of rows in a result set.
COUNT
What is the difference between INNER JOIN and LEFT JOIN?
INNER JOIN returns rows with matching values in both tables, while LEFT JOIN returns all rows from the left table and matched rows from the right table.
True or False: SQL statements are case sensitive.
False
What is the purpose of the HAVING clause?
To filter records after aggregation
Which SQL function is used to find the maximum value in a set?
MAX
What does the acronym DDL stand for?
Data Definition Language
Which command is used to modify the structure of an existing table?
ALTER TABLE
Fill in the blank: The ________ statement is used to remove a table from a database.
DROP
What is an index in a database?
A database structure that improves the speed of data retrieval
