SQL basics: SELECT, INSERT, DISTINCT and ORDER BY

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

   1. ASELECT
   2. BEXTRACT
   3. COPEN
   4. DGET
2. 2Which SQL statement is used to insert new data in a database?

   1. AINSERT INTO
   2. BADD NEW
   3. CADD RECORD
   4. DINSERT NEW
3. 3With SQL, how do you select all the columns from a table named "Quizzes"?

   1. ASELECT [all] FROM Quizzes
   2. BSELECT Quizzes
   3. CSELECT * FROM Quizzes
   4. DSELECT *.Quizzes
4. 4With SQL, how do you select all the records from a table named "Employees" where the value of the column "LastName" is "Ali"?

   1. ASELECT * FROM Employees WHERE LastName<>'Ali'
   2. BSELECT * FROM Employees WHERE LastName='Ali'
   3. CSELECT [all] FROM Employees WHERE FirstName LIKE 'Ali'
   4. DSELECT [all] FROM Employees WHERE LastName='Ali'
5. 5Which SQL statement is used to return only different values?

   1. ASELECT UNIQUE
   2. BSELECT DIFFERENT
   3. CSELECT DISTINCT
6. 6With SQL, how can you return all the records from a table named "Orders" sorted descending by "Items"?

   1. ASELECT * FROM Orders SORT 'Items' DESC
   2. BSELECT * FROM Orders ORDER BY Items DESC
   3. CSELECT * FROM Orders ORDER Items DESC
   4. DSELECT * FROM Orders SORT BY 'Items' DESC

Description

Quiz on Untitled, created by Shahd Yaser Nasr on 03/01/2021.

Author

Shahd Yaser Nasr

Language

English

Views

0

Rating

No ratings yet

Rate this quiz

Rate this quiz

More on SELECT Queries