SQL

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

With SQL, how do you select all the columns from a table named "Persons"?

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

Which SQL keyword is used to sort the result-set?

Which SQL statement is used to update data in a database?

Which SQL statement is used to extract data from a database?

Which SQL statement is used to return only different values?

Which SQL statement is used to delete data from a table?

Which SQL statement is used to insert new data in a database?

The primary - foreign key relations are used to

When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.

Which of the following is true about CASE SQL statement?

Which of the following statement is true about embedded SQL?

Which of the following is true concerning systems information in an RDBMS?

The AVG SQL function returns the

The table columns are also known as

Which of the following SQL statements deletes all rows in table called SalesData?

Can the SELECT clause list have a computed value like in the example below? SELECT CustomerName, UnitPrice * NumberofUnits FROM Sale

The TRUNCATE TABLE

This term, used to describe a database that occupies magnetic storage in the terabyte range, describes a database that contains billions of table rows.