Home > Databases > Quizzes > DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 29% • Most missed: “CREATE TABLE Employee(Emp_id NUMERIC NOT NULL, Name VARCHAR(20) , dept_name VARC…”
Quiz questions on SQL basics, set and null value operations, database modifications, views and transactions, different types of integrity constraints, joins, nested subqueries and aggregate functions, schemas and data types, triggers, functions and procedures and different queries and aggregation features. SQL queries are commands that retrieve data from a database, and are similar to questions a user asks a database. SQL constraints are rules that limit the data in a table to meet certain regulations. SQL triggers are database objects that execute SQL statements when a specific event occurs... Show more
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers
Time left 00:00
25 Questions

1. How many tables may be included with a join?
2. SELECT emp_name WHERE dept_name LIKE ’ _____ Computer Science’;Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?
3. CREATE TABLE employee (id INTEGER,name VARCHAR(20),salary NOT NULL);INSERT INTO employee VALUES (1002,Joey,335);Some of these insert statements will produce an error. Identify the statement.
4. A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
5. Which of the following closely resembles Create view?
6. To remove a relation from an SQL database, we use the ______ command.
7. To include integrity constraint in an existing relation use :
8. Materialised views make sure that
9. The intersection operator is used to get the _____ tuples.
10. The EXISTS keyword will be true if:
11. Which of the following statements creates a new table temp instructor that has the same schema as an instructor.
12. In case of any shut down during transaction before commit which of the following statement is done automatically?
13. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
14. Which of the following invokes functions in sql?
15. In an employee table to include the attributes whose value always have some value which of the following constraint must be used?
16. The____condition allows a general predicate over the relations being joined.
17. The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation
18. Subqueries cannot:
19. In order to maintain the consistency during transactions, database provides
20. The user defined data type can be created using
21. In authorization graph, if DBA provides authorization to u1 which inturn gives to u2 which of the following is correct?
22. You attempt to query the database with this command:
SELECT nvl (100 / quantity, NONE) FROM inventory;Why does this statement cause an error when QUANTITY values are null?
23. Which of the following is used to distinguish the variables in SQL from the host language variables?
24. Which of the following is a following statement is a prepared statements?
25. CREATE DOMAIN YearlySalary NUMERIC(8,2)CONSTRAINT salary VALUE test __________;In order to ensure that an instructor’s salary domain allows only values greater than a specified value use:

⚡ Recently practiced quizzes in this topic
Live quiz activity
Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs MariaDB Practice Test
 
❤ 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.