Home > Information Technology (IT) Support Executive > Quizzes > Database System Assistant Practice Test: MySQL Open Source Database
Database System Assistant Practice Test: MySQL Open Source Database
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 0% • Most missed: “Which of the SQL Server RTM included native support for managing XML data?”
Database System Assistant Practice Test: MySQL Open Source Database
Time left 00:00
25 Questions

1. Which was the first version of SQL Server to introduce in-memory capability?
2. Which is called as a virtual table in SQL?
3. SQL Select statement to retrieve unique record from a table is __________   
4. To combine the result-set of two or more SELECT statements, SQL clause used is __________  
5. Wrong statement about UPDATE keyword is
6. __________   is a software application first launched with the Microsoft SQL Server 2005.
7. Logical operators used in SQL are __________    
8. Which statement is correct? A table can have
9. SQL Command to remove stored procedure SQL
10. Which clause is used to combine rows from two or more tables based on a related column between them?
11. Types of SQL Trigger is/are in SQL database
12. Combination of primary key with foreign key forms
13. Codename for SQL Server 2012 is __________      
14. SQL Trigger automatically executed on operations
15. SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)
16. LocalDB was introduced in which of the following versions of SQL Server?
17. To specify the number of records to return, which keyword is used __________  
18. To give a temporary name to a table, or a column in a table for more readability, what is used?
19. Which is not DDL (data definition language) operation ?
20. Correct SQL query to delete a column from a table in SQL Server database __________    
21. In a table, a column contains duplicate value, if you want to list all different value only, then which SQL clause is used?
22. Match SQL language with SQL commands 1) DDL i) Revok, Grant 2) DML ii) rename a table 3) TCL iii) insert, update 4) DCL iv) rollback, commit
23. In a SQL subquery , which operator is used to check for existence of record ?
24. Which statement is correct about primary key of a table?
25. Which statement is wrong about PRIMARY KEY constraint in SQL?

⚡ Recently practiced quizzes in this topic
Live quiz activity
Multimedia Animation and Special Effects Practice Test: Basics of 3ds Max Database System Assistant Practice Test: Introduction To Database Assistant Database System Assistant Practice Test: Open Tools in Database Systems Information Technology Support Executive Practice Test: PageMaker & CorelDraw Database System Assistant Practice Test: Taking Backup and Restoring Backup
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.