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

May be interested

  • eQuiz - Multiple choice test on ASPeQuiz - 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.
  • JAVA test test P1JAVA test test P1
    java is an object-oriented and class-based programming language. to help you read more interesting knowledge about the java programming language, the network administrator will send you a very interesting multiple choice question on this topic. please try.
  • eQuiz - Multiple choice test on SEO - search engine optimizationeQuiz - Multiple choice test on SEO - search engine optimization
    the basic knowledge test is related to seo - search engine optimization, a total of 10 questions will be answered with no time to answer each sentence. there will be some questions with many different answer options.
  • eQuiz - VB.NET testing test - Part 2eQuiz - VB.NET testing test - Part 2
    in the previous article, i showed you the first part of the vb.net test. and this time, we will continue with part 2 of this popular quiz series on programming languages, the whole test will have 15 questions with unlimited response time.
  • Test on JAVA test P5Test on JAVA test P5
    do you like java programming and want to learn useful knowledge to apply to work? to meet the needs of readers, network administrators have collected and sent a series of quiz questions about java programming. invite your reference.
  • eQuiz - Multiple choice test on OSI Model - part 1eQuiz - Multiple choice test on OSI Model - part 1
    the osi model knowledge test, in total, there will be 12 questions with no time limit for answering each sentence.
  • JAVA test on P3JAVA test on P3
    java is a high-level programming language, if you are interested in learning about this programming language, the following test of network administrator will give you lots of useful information.
  • Test on JAVA P10 testTest on JAVA P10 test
    multiple choice questions on java programming help you test your basic knowledge of this programming language. the set of questions includes 10 sentences to try.
  • Testing test on JAVA P2Testing test on JAVA P2
    multiple choice questions on java programming help you test your basic knowledge of this programming language. the set of questions includes 10 sentences to try.
  • eQuiz - Multiple choice test on OSI Model - part 2eQuiz - Multiple choice test on OSI Model - part 2
    this is part 2 of the osi model knowledge test, in total there will be 12 questions with no time for answering each sentence.