eQuiz - Multiple choice test on SQL
- Sentence 1. SQL is an acronym for:
- Strong Question Language
- Structured Question Language
- Structured Query Language
-
- Question 2. Which SQL statement is used to extract data from the database
- Get
- Open
- Extract
- Select
-
- Question 3. Which SQL statement is used to update data from the database
- Update
- Lưu như
- Modify
- Save
-
- Question 4. Which SQL statement is used to delete data from the database
- Truncate
- Delete
- Remove
-
- Question 5. Which SQL statement is used to insert data into the database:
- Add recrd
- Thêm vào
- Insert
- Add new
-
- Question 6. In SQL, how to select the data column named FirstName from the Persons table:
- Extract FirstName FROM Persons
- Select FirstName FROM Persons
- Slect Persons.FirstName
-
- Question 7. In SQL, how to select all columns of data in the Persons table:
- Select [all] FROM Persons
- Select All Persons
- Select * .Persons
- Select * FROM Persons
-
- Question 8. In SQL how to select all records from the Persons table with the value in FirstName column is Peter:
- Select [all] FROM Persons WHERE FirstName = 'Peter'
- Select * FROM Persons WHERE FirstName LIKE'Peter '
- Chọn [tất cả] FROM một thành viên không có tên_ĐI LIKE'Peter '
- Select * FROM Persons WHERE FirstName = 'Peter'
-
- 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:
- Chọn * From Persons WHERE FirstName = '% a%'
- Select * From Persons WHERE FirstNameLIKE%
- Select * From Persons WHERE FirstName = 'a'
- Select * From Persons WHERE FirstName = 'a%'
-
- 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:
- It's correct
- False
-
- 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:
- SELEC * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'
- SELEC * FROM Persons WHERE FirstName = 'Peter' AND LastName = 'Jackson'
- SELECT FirstName = 'Peter', LastName = 'Jackson' FROM Persons
-
- 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:
- SELECT LastName> 'Hansen' AND LastName <'Pettersen' FROM Persons
- SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
- SELECT * FROM Persons WHERE LastName> 'Hansen' AND LastName <'Pettersen'
-
- Question 13. Which SQL syntax is used to return different values:
- SELECT UNIQUE
- SELECT INDENTITY
- SELECT DIFFERNT
- SELECT DISTINCT
-
- Question 14. Which SQL keyword is used to sort the list of results:
- SORT BY
- ORDER
- ORDER BY
- SORT
-
- Question 15. In SQL, how to return all record data from Persons table in descending sort order in FirstName column:
- SELECT * FROM Persons SORT BY 'FirstName' DESC
- SELECT * FROM Persons ORDER BY FirstName DESC
- SELECT * FROM Persons ORDER FirstName DESC
- SELECT * FROM Persons SORT 'FirstName' DESC
-
- Question 16. In SQL, how to insert new records into the Persons table:
- INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
- INSERT ('Jimmy', 'Jackson') INTO Persons
- INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
-
- Question 17. In SQL, how to insert the Olsen into the LastName column in the Persons table:
- INSERT INTO Persons (LastName) VALUES ('Olsen')
- INSERT ('Olsen') INTO Persons (LastName)
- INSERT INTO Persons ('Olsen') INTO LastName
-
- Question 18. How to convert Hansen into Nilsen in the LastName column of the Persons table:
- UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'
- UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
- MODIFY Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'
- MODIFY Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
-
- Question 19. In SQL, how to delete Peter records in FirstName column of Persons table:
- DELETE FROM Persons WHERE FirstName = 'Peter'
- DELETE ROW FirstName = 'Peter' FROM Persons
- DELETE FirstName = 'Peter' FROM Persons
-
- Question 20. In SQL, how to return the number of records in the Persons table:
- SELECT COLUMNS () FROM Persons
- SELECT COUNT (*) FROM Persons
- SELECT COLUMNS (*) FROM Persons
- SELECT COUNT () FROM Persons
-
- Question 21. 1 employee data table as shown below. What will be the return value of the select count (*) from employees statement?
- first
- 2
- 3
- Other answers
-
- Question 22. The result of the SELECT clause may contain duplicate data lines:
- It's correct
- False
-
- Question 23. Sometimes, the 'select count (*)' syntax will return less value than 'select count (value)'
- It's correct
- False
-
- Question 24. Which of the following key types will prevent any user from accessing the data table:
- EXPLICIT
- IMPLICIT
- EXCLUSIVE
- SHARED
- READ ONLY
-
- Question 25. Which of the following SQL statements is used to delete data rows from the table:
- DROP
- REMOVE ROW
- DELETE
- DELETE ROW
-
- Question 26. The only way to link two data tables is to use ANSI standard syntax:
- It's correct
- False
-
- Question 27. The value of NULL is considered to be null or equal to 0:
- It's correct
- False
-
- Question 28. Left outer join is a form of outer join. Another form is:
- Right
- Full
- Right outer
- Full outer
- All answers above
-
4 ★ | 1 Vote
You should read it
May be interested
- eQuiz - Multiple choice test on ASPhere 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 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 optimizationthe 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 2in 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 P5do 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 1the osi model knowledge test, in total, there will be 12 questions with no time limit for answering each sentence.
- JAVA test on P3java 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 testmultiple 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 P2multiple 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 2this is part 2 of the osi model knowledge test, in total there will be 12 questions with no time for answering each sentence.