NEW
Font size
WorksheetsInfoMidterm P1
Total questions: 15
Worksheet time: 8mins
What does a SELECT statement do in SQL?
Updates data in the database
Inserts data into the database
Retrieves information from the database
Deletes data from the database
What does the Projection feature in SQL allow you to do?
Delete data from a table
Choose the rows in a table
Choose the columns in a table
Join data from different tables
What is a Null value in SQL?
A value that is unavailable, unassigned, unknown, or inapplicable
A value equal to zero
A value that is not allowed in SQL
A value that represents a blank space
What does the Concatenation Operator (||) do in SQL?
Deletes rows from a table
Combines columns, expressions, or values to create a character expression
Performs division operations
Updates values in a table
What is a literal in SQL?
A value that is not included in the SELECT statement
A value that cannot be used in SQL
A character, number, or date included in the SELECT statement
A keyword used for abbreviating commands
What is SQL primarily used for?
Communication with the Oracle server
Sending emails
Playing music
Creating graphics
What is the purpose of a Column Alias in SQL?
To rename a table
To rename a column heading
To delete a column
To add a new column
What is the role of iSQL*Plus in SQL?
To delete tables
To manipulate data values
To run commands on a browser
To create new tables
What is the significance of the SELECT* statement in SQL?
It selects all columns from a table
It deletes all rows from a table
It updates all rows in a table
It joins two tables
What does the Selection feature in SQL allow you to do?
Choose the rows in a table
Rename columns in a table
Choose the columns in a table
Combine data from different tables
What happens if a column value in an arithmetic expression is null in SQL?
It is treated as a blank space
It results in an error
It is treated as zero
It results in a null or unknown
What is the purpose of the Joining feature in SQL?
To choose specific columns in a table
To choose specific rows in a table
To bring together data from different tables
To delete data from a table
What is the significance of a Column containing the NOT NULL constraint in SQL?
It allows null values in the column
It prevents null values in the column
It allows only zero values in the column
It allows only blank space values in the column
What is the role of SQL in communication with the Oracle server?
It is a non-procedural language
It is used for creating graphics
It is used for sending emails
It is a procedural language
What is the purpose of the Date and character literal values in SQL?
They must be enclosed by double quotation marks
They must be enclosed by single quotation marks
They must be enclosed by parentheses
They must be enclosed by square brackets
