HomeTech infoQuiz technologyeQuiz - Multiple choice test on SQL

eQuiz - Multiple choice test on SQL

  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?
    eQuiz - Multiple choice test on SQL Picture 1
    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
4 ★ | 1 Vote
tutorialsquizzestestssqlprogrammingequizknowledgebasictechnicaloptimizationlanguagemanagementmonitoringdatabase

You should read it

May be interested

  • eQuiz - Multiple choice test on ASPPhoto of eQuiz - Multiple choice test on ASP
    here is a small test of asp web programming language, a total of 30 questions will be answered with no time to answer each sentence.
  • eQuiz - A quiz about CSSPhoto of eQuiz - A quiz about CSS
    welcome to the test series of tipsmake.com with topics related to the fields of information technology.
  • eQuiz - Multiple choice test on XHTMLPhoto of eQuiz - Multiple choice test on XHTML
    to be able to compare html and xhtml readers can refer to html and xhtml articles, but if you want to start familiarizing with new things related to xhtml, you can try some of the multiple choice questions below. here to see where your level of knowledge is.
  • eQuiz - Test of knowledge about the browserPhoto of eQuiz - Test of knowledge about the browser
    tipsmake.com has sent a series of quizzes to readers for some basic programming languages ​​for beginners. in today's article will be a multiple choice question about web browser. it seems that this topic is very familiar, let's try to see how many sentences you answered correctly!
  • Test your level of understanding of Office 2010 - Part 1Photo of Test your level of understanding of Office 2010 - Part 1
    in the article below, the network administrator will send you to read interesting quiz questions about office so you can assess your level of understanding about this software.
  • Test your understanding of the network and Windows operating systemPhoto of Test your understanding of the network and Windows operating system
    continuing the series of articles about this category, in today's article will be multiple choice questions also extremely interesting around the topic office 2010 so you can test your knowledge.

Quiz technology