RDBMS Questions and Answers – Application Architectures

This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Application Architectures”.

1. Which of the following is true regarding the model-view- controller architecture?
a) The model corresponds to the business logic layer
b) The view defines the presentation of data
c) The controller receives events, executes actions on the model and returns a view
d) All of the mentioned
View Answer

2. The ___________ provides a high level view of data and actions on data
a) Business-logic layer
b) Data access layer
c) Data transfer layer
d) Business manager layer
View Answer

3. The _________ layer provides the interface between the business logic layer and the underlying database
a) Business-logic layer
b) Data access layer
c) Data transfer layer
d) Business manager layer
View Answer

4. What are workflows in a business logic layer?
a) They describe how a particular task that involves servers is handled
b) They describe how multiple tasks involving a single participant is handled
c) They describe how a particular task involving multiple participants is handled.
d) None of the mentioned
View Answer

5. State true or false: The code implementing the actions in the business logic layer ensures that business rules are followed
a) True
b) False
View Answer

6. What is the full form of JSON?
a) JavaScript Object Native
b) JavaScript Object Notation
c) JavaScript Object Negation
d) Java Object Notation
View Answer

7. Which of the following features does Rapid Application Development possess?
a) Provide a library of functions to generate UI elements
b) Provide drag and drop features in a n IDE
c) Auto generation of code for the user interface from a declarative specification
d) All of the mentioned
View Answer

8. Which of the following is not a web application development framework feature?
a) An object oriented model
b) A declarative way of specifying a form with validation constraints
c) Creating mass servers for effective handling of data
d) A template scripting system
View Answer

9. What are report generators?
a) They are the tools to generate human readable reports from a database
b) They are the tools that generate reports on the statistics of the database usage
c) They are the tools that prevent database querying and instead they generate pie charts and graphs
d) None of the mentioned
View Answer

10. Which of the following methods is used to reduce overhead?
a) Connection pooling
b) Parallel Processing
c) Caching Query Results at the server
d) All of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – RDBMS.

To practice all areas of RDBMS, here is complete set of 1000+ Multiple Choice Questions and Answers.