Home Tech infoQuiz technology

eQuiz - Multiple choice test on SQL

This is a small test of the SQL database administration system, there will be 10 questions in total with no time for answering each sentence.

  1. Sentence 1. SQL is an acronym for:
    1. Strong Question Language
    2. Structured Question Language
    3. Structured Query Language
  2. Question 2. Which SQL statement is used to extract data from the database
    1. Get
    2. Open
    3. Extract
    4. Select
  3. Question 3. Which SQL statement is used to update data from the database
    1. Update
    2. Lưu như
    3. Modify
    4. Save
  4. Question 4. Which SQL statement is used to delete data from the database
    1. Truncate
    2. Delete
    3. Remove
  5. Question 5. Which SQL statement is used to insert data into the database:
    1. Add recrd
    2. Thêm vào
    3. Insert
    4. Add new
  6. Question 6. In SQL, how to select the data column named FirstName from the Persons table:
    1. Extract FirstName FROM Persons
    2. Select FirstName FROM Persons
    3. Slect Persons.FirstName
  7. Question 7. In SQL, how to select all columns of data in the Persons table:
    1. Select [all] FROM Persons
    2. Select All Persons
    3. Select * .Persons
    4. Select * FROM Persons
  8. Question 8. In SQL how to select all records from the Persons table with the value in FirstName column is Peter:
    1. Select [all] FROM Persons WHERE FirstName = 'Peter'
    2. Select * FROM Persons WHERE FirstName LIKE'Peter '
    3. Chọn [tất cả] FROM một thành viên không có tên_ĐI LIKE'Peter '
    4. Select * FROM Persons WHERE FirstName = 'Peter'
  9. Question 9. In SQL, how to select all records from the Persons table with the values ​​in the FirstName column starting with the value a:
    1. Chọn * From Persons WHERE FirstName = '% a%'
    2. Select * From Persons WHERE FirstNameLIKE%
    3. Select * From Persons WHERE FirstName = 'a'
    4. Select * From Persons WHERE FirstName = 'a%'
  10. Question 10. The OR clause will display the record if any of the following conditions are true. And the AND clause will display the record if all of the following conditions are true:
    1. It's correct
    2. False
  11. Question 11. In SQL, how to select all records from the Persons table with the values ​​in the FirsName column, Perter and LastName, as Jackson:
    1. SELEC * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'
    2. SELEC * FROM Persons WHERE FirstName = 'Peter' AND LastName = 'Jackson'
    3. SELECT FirstName = 'Peter', LastName = 'Jackson' FROM Persons
  12. Question 12. In SQL, how to select all records from Persons table with values ​​in FirstName column sorted in alphabetical order between (and including) Hansen and Pettersen:
    1. SELECT LastName> 'Hansen' AND LastName <'Pettersen' FROM Persons
    2. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
    3. SELECT * FROM Persons WHERE LastName> 'Hansen' AND LastName <'Pettersen'
  13. Question 13. Which SQL syntax is used to return different values:
    1. SELECT UNIQUE
    2. SELECT INDENTITY
    3. SELECT DIFFERNT
    4. SELECT DISTINCT
  14. Question 14. Which SQL keyword is used to sort the list of results:
    1. SORT BY
    2. ORDER
    3. ORDER BY
    4. SORT
  15. Question 15. In SQL, how to return all record data from Persons table in descending sort order in FirstName column:
    1. SELECT * FROM Persons SORT BY 'FirstName' DESC
    2. SELECT * FROM Persons ORDER BY FirstName DESC
    3. SELECT * FROM Persons ORDER FirstName DESC
    4. SELECT * FROM Persons SORT 'FirstName' DESC
  16. Question 16. In SQL, how to insert new records into the Persons table:
    1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
    2. INSERT ('Jimmy', 'Jackson') INTO Persons
    3. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
  17. Question 17. In SQL, how to insert the Olsen into the LastName column in the Persons table:
    1. INSERT INTO Persons (LastName) VALUES ('Olsen')
    2. INSERT ('Olsen') INTO Persons (LastName)
    3. INSERT INTO Persons ('Olsen') INTO LastName
  18. Question 18. How to convert Hansen into Nilsen in the LastName column of the Persons table:
    1. UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'
    2. UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
    3. MODIFY Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'
    4. MODIFY Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
  19. Question 19. In SQL, how to delete Peter records in FirstName column of Persons table:
    1. DELETE FROM Persons WHERE FirstName = 'Peter'
    2. DELETE ROW FirstName = 'Peter' FROM Persons
    3. DELETE FirstName = 'Peter' FROM Persons
  20. Question 20. In SQL, how to return the number of records in the Persons table:
    1. SELECT COLUMNS () FROM Persons
    2. SELECT COUNT (*) FROM Persons
    3. SELECT COLUMNS (*) FROM Persons
    4. SELECT COUNT () FROM Persons
  21. Question 21. 1 employee data table as shown below. What will be the return value of the select count (*) from employees statement?
    Picture 1 of eQuiz - Multiple choice test on SQL
    1. first
    2. 2
    3. 3
    4. Other answers
  22. Question 22. The result of the SELECT clause may contain duplicate data lines:
    1. It's correct
    2. False
  23. Question 23. Sometimes, the 'select count (*)' syntax will return less value than 'select count (value)'
    1. It's correct
    2. False
  24. Question 24. Which of the following key types will prevent any user from accessing the data table:
    1. EXPLICIT
    2. IMPLICIT
    3. EXCLUSIVE
    4. SHARED
    5. READ ONLY
  25. Question 25. Which of the following SQL statements is used to delete data rows from the table:
    1. DROP
    2. REMOVE ROW
    3. DELETE
    4. DELETE ROW
  26. Question 26. The only way to link two data tables is to use ANSI standard syntax:
    1. It's correct
    2. False
  27. Question 27. The value of NULL is considered to be null or equal to 0:
    1. It's correct
    2. False
  28. Question 28. Left outer join is a form of outer join. Another form is:
    1. Right
    2. Full
    3. Right outer
    4. Full outer
    5. All answers above
tutorials quizzes tests sql programming equiz knowledge basic technical optimization language management monitoring database
« PREV POST
READ NEXT »
Similar Post
MORE LIKE THIS