Info Midterm Part 1

What does the SELECT statement do?

• Update existing data in the database

• Delete data from the database

• Insert data into the database

• Retrieve information from the database

What does the Projection capability of the SELECT statement allow you to do?

• Perform arithmetic operations

• Combine data from different tables

• Choose the columns in a table that are returned by a query

• Choose the rows in a table that are returned by a query

Which operator is used to add two values in SQL?

• /

• +

• -

• *

What is a NULL value in SQL?

• A value that is a character

• A value that is a blank space

• A value that is unavailable or unknown

• A value that is zero

What does a column alias do in SQL?

• Deletes a column from the table

• Combines two columns into one

• Renames a column heading

• Filters rows based on a condition

Which operator is used for concatenation in SQL?

• ||

• +

• -

• *

What is a literal character string in SQL?

• A value that is a number

• A value that is enclosed in double quotation marks

• A value that is included in the SELECT statement

• A value that is a date

What does the DISTINCT keyword do in a SQL query?

• Filters out duplicate rows

• Groups rows based on a specific column

• Sorts the results in ascending order

• Performs a join operation

What is the difference between SQL and iSQL*Plus?

• SQL allows manipulation of values in the database, iSQL*Plus does not

• SQL is a browser-based tool, iSQL*Plus is not

• SQL is an Oracle-proprietary language, iSQL*Plus is not

• SQL cannot be abbreviated, iSQL*Plus can

What is a feature of SQL?

• Is a procedural language

• Is accessed from a browser

• Can be used by users with little or no programming experience

• Is an Oracle-proprietary language