Home > Databases > Quizzes > DBMS Basics Practice Test: Database Programming Techniques
DBMS Basics Practice Test: Database Programming Techniques
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 78% • Most missed: “What is the purpose of SMON background process?”

Quiz questions on fundamentals of web programming, JSP and servlets, application performance and security, application encryption and architecture.
 

DBMS Basics Practice Test: Database Programming Techniques
Time left 00:00
25 Questions

1. Finding the location of the element with a given value is:
2. In the following query, which expression is evaluated first?
SELECT id_number, (quantity - 100 / 0.15 - 35 * 20) FROM inventory
3. Which JDBC driver Type(s) can be used in either applet or servlet code?
4. Assymmetric Encryption: Why can a message encrypted with the Public Key only be decrypted with the receiver’s appropriate Private Key?
5. The doGet() method in the example extracts values of the parameter’s type and number by using __________
6. In a database where the encryption is applied the data is cannot be handled by the unauthorised user without
7. Which among the following are the functions that any system with a user interface must provide?
8. In _________________ attacks, the attacker manages to get an application to execute an SQL query created by the attacker.
9. _________ is an attack which forces an end user to execute unwanted actions on a web application in which he/she is currently authenticated.
10. Where is metadata stored in MySQL?
11. This extra information is usually maintained in the form of a _________ at the client.
12. Which of the following requires no password travel across the internet?
13. Encryption of small values, such as identifiers or names, is made complicated by the possibility of __________
14. The ______________ layer, which provides the interface between the business-logic layer and the underlying database.
15. Which of the following is true for Seeheim model?
16. The ORDER BY clause can only be used in
17. Which is the largest disadvantage of symmetric Encryption?
18. The elements of an array are stored successively in memory cells because
19. A __________ is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents.
20. Which of the following is a valid uniform resource locator?
21. DML changes are
22. A Web site that allows users to enter text, such as a comment or a name, and then stores it and later display it to other users, is potentially vulnerable to a kind of attack called a ___________________ attack.
23. Which of the following is the main task accomplished by the user?
24. The application program typically communicates with a database server, through ___________ or other protocols, in order to get or store data.
25. _______________ allows a system administrator to associate a function with a relation; the function returns a predicate that must be added to any query that uses the relation.

⚡ 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.