InfoMidterm P1

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