SQL

  • 1/20

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

    Next >
  • 2/20

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

    Next >
  • 3/20

    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

    Next >
  • 4/20

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

    Next >
  • 5/20

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

    Next >
  • 6/20

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

    Next >
  • 7/20

    Which SQL statement is used to return only different values?

    Next >
  • 8/20

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

    Next >
  • 9/20

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

    Next >
  • 10/20

    The primary - foreign key relations are used to

    Next >
  • 11/20

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

    Next >
  • 12/20

    Which of the following is true about CASE SQL statement?

    Next >
  • 13/20

    Which of the following statement is true about embedded SQL?

    Next >
  • 14/20

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

    Next >
  • 15/20

    The AVG SQL function returns the

    Next >
  • 16/20

    The table columns are also known as

    Next >
  • 17/20

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

    Next >
  • 18/20

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

    Next >
  • 19/20

    The TRUNCATE TABLE

    Next >
  • 20/20

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

    Next >
  • If You want to see your results leave Your e-mail (optional)