Home > Databases > Quizzes > Apache Derby Practice Test Questions
Apache Derby Practice Test Questions
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 78% • Most missed: “Which of the following statement is used to create a procedure in Apache Derby?”

Apache Derby is a relational database management system developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 3.5 MB disk-space footprint. Apache Derby is developed as an open source project under the Apache 2.0 license.

Apache Derby Practice Test Questions
Time left 00:00
25 Questions

1. In Apache Derby, a ____ is a fundamental database object that contains a collection of rows and columns reflecting a specific set of data?
2. Apache Derby provides how many types of delete?
3. Which of the following companies are using Apache derby?
4. The GROUP BY clause is used with ____ statements?
5. Apache Derby is written in ____ programming language?
6. Which of the following create a trigger in Derby?
7. To produce Data Definition Language ____ tool is utilised?
8. When Derby is deployed in ____ mode, the database engine runs in the same JVM as the Java application?
9. A table ____ is nothing more than a reference to its data.
10. A ____ object is used to run a static SQL statement with no input parameters.
11. ____ indexes are used for data integration in Apache Derby?
12. In Apache Derby, a ____ is a logical container that holds a collection of database objects including tables, views, indexes, and procedures?
13. In Apache Derby, a ____ is a point inside a transaction that allows you to roll back only a portion of the transaction.
14. A ____ object is used to run a dynamic SQL query with parameters.
15. Apache Derby is ____?
16. Apache Derby is developed by ____?
17. Apache Derby follows the concept of ____?
18. Which of the following statement helps us to drop the view in Apache derby?
19. Which of the following command helps us to create a table in Apache Derby?
20. Apache Derby provides how many types of updates?
21. Is Derby completely ACID-compliant?
22. Which of the following tools provides information about the Java and Derby environments?
23. To obtain data from a table, use the ____ command.
24. Is Apache Derby platform independent?
25. The ____ delete statement deletes all of the columns given in a table?

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers 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
 
❤ 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.