logo
  • Home
  • Test & Rank
  • About
  • Training
  • Programming
  • CS
  • IT
  • IS
  • ECE
  • EEE
  • EE
  • Civil
  • Mechanical
  • Chemical
  • Metallurgy
  • Instrumentation
  • Aeronautical
  • Aerospace
  • Biotechnology
  • Mining
  • Marine
  • Agriculture
  • MCA
  • BCA
  • Internship
  • Jobs
  • Contact

RDBMS Multiple Choice Questions | MCQs | Quiz

RDBMS Interview Questions and Answers
Practice RDBMS questions and answers for interviews, campus placements, online tests, aptitude tests, quizzes and competitive exams.

Get Started

•   Relational Model Basics
•   Sql Data Definition
•   Basic Operations
•   Set Operations
•   Aggregate Functions
•   Nested Subqueries
•   Database Modification
•   Join Expressions
•   Views & Transactions
•   Integrity Constraints
•   Sql Data Types & Schemas
•   Sql Programming Language
•   Olap
•   Relational Algebra
•   Entity Relationship Model
•   Entity Relationship Diagram
•   Relational Schema
•   Extended E - R Features
•   Relational Design Features
•   Functional Dependencies
•   Functional Theory
•   Decomposition Algorithms
•   Normal Forms
•   Web Fundamentals
•   Servlets & Jsp
•   Application Architectures
•   Application Security
•   Magnetic Disk & Storage
•   Raid
•   File Organization
•   Records Organization
•   Ordered Indices
•   B+ Trees
•   Static Hashing
•   Dynamic Hashing
•   Bitmap Indices
•   Query Processing
•   Join & Other Operations
•   Expressions Evaluation
•   Relational Expressions
•   Expression Results
•   Evaluation Plans
•   Materialized Views
•   Transaction Concept
•   Serializability
•   Transaction Isolation
•   Transaction Isolation Levels
•   Lock Based Protocols
•   Deadlock Handling
•   Timestamp Based Protocol
•   Validation Based Protocols
•   Snapshot Isolation
•   Insert & Delete Operations
•   Failure Classification
•   Recovery & Atomicity
•   Sql Data Definition
•   Sql Queries - I
•   Sql Queries - II
•   Sql Queries - III
•   Sql Queries - IV

Best Reference Books

RDBMS Books

« Prev Page
Next Page »

RDBMS Questions and Answers – Application Architectures

Posted on July 5, 2017 by Manish

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

Answer: d
Explanation: In the model-view-controller architecture, the model corresponds to the business logic layer, the view defines the way data is presented and the controller receives events, executes actions on the model and returns a view.
advertisement

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

Answer: a
Explanation: The Business-logic layer provides a high level view of data and actions on data. An object oriented approach is used to code this layer.

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

Answer: b
Explanation: The data-access layer provides the interface between the business logic layer and the underlying database. The data access layer provides the mapping from the object oriented data model to the relational model.

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

Answer: c
Explanation: Business logic includes workflows. Workflows in a business logic layer describe how a particular task involving multiple participants is handled.

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

Answer: a
Explanation: The code implementing the actions in the business logic layer ensures that business rules are followed. For example a student can only enroll in a course if the prerequisites are completed.
advertisement

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

Answer: b
Explanation: JSON – JavaScript Object Notation. This is an encoding for javascript objects.

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

Answer: d
Explanation: The main features of Rapid Application development are to provide a library of functions for GUI development, to provide drag and drop features in an IDE, Auto-generation of code for the user interface from a declarative specification.

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

Answer: c
Explanation: Creating mass servers for effective handling of data is not a part of the web application development framework feature.

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

Answer: a
Explanation: Report generators are the tools to generate human readable reports from a database. They integrate querying the database with the creation of formatted text and summary charts.

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

Answer: d
Explanation: To reduce overhead, any of the following methods can be used. Connection pooling, Parallel processing or caching query results at the server. Caching query results at the server enables to reduce the number of database accesses every time a similar request is sent.
advertisement

Sanfoundry Global Education & Learning Series – RDBMS.

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

« Prev Page - RDBMS Questions and Answers – Servlets and JSP
» Next Page - RDBMS Questions and Answers – Application Security

« RDBMS Questions and Answers – Servlets and JSP
RDBMS Questions and Answers – Application Security »
advertisement

Deep Dive @ Sanfoundry:

  1. Artificial Intelligence Questions and Answers
  2. 100+ Java Android Programming Examples
  3. Computer Networks Questions and Answers
  4. C# Programming Examples on Events
  5. JUnit Questions and Answers
  6. MongoDB Questions and Answers
  7. Oracle Database Questions and Answers
  8. Database Management System Questions and Answers
  9. Javascript Questions and Answers
  10. RDBMS Questions and Answers – Recovery and Atomicity
Manish Bhojasia
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He is Linux Kernel Developer & SAN Architect and is passionate about competency developments in these areas. He lives in Bangalore and delivers focused training sessions to IT professionals in Linux Kernel, Linux Debugging, Linux Device Drivers, Linux Networking, Linux Storage, Advanced C Programming, SAN Storage Technologies, SCSI Internals & Storage Protocols such as iSCSI & Fiber Channel. Stay connected with him @ LinkedIn | Facebook | Twitter

Best Careers

Developer Tracks
SAN Developer
Linux Kernel Developer
Linux Driver Developer
Linux Network Developer

Live Training Photos
Mentoring
Software Productivity
GDB Assignment
Sanfoundry is No. 1 choice for Deep Hands-ON Trainings in SAN, Linux & C, Kernel Programming. Our Founder has trained employees of almost all Top Companies in India such as VMware, Citrix, Oracle, Motorola, Ericsson, Aricent, HP, Intuit, Microsoft, Cisco, SAP Labs, Siemens, Symantec, Redhat, Chelsio, Cavium, ST-Micro, Samsung, LG-Soft, Wipro, TCS, HCL, IBM, Accenture, HSBC, Mphasis, Tata-Elxsi, Tata VSNL, Mindtree, Cognizant and Startups.

Best Trainings

SAN I - Technology
SAN II - Admin
Linux Fundamentals
Advanced C Training
Linux-C Debugging
System Programming
Network Programming
Linux Threads
Kernel Programming
Kernel Debugging
Linux Device Drivers

Best Reference Books

Computer Science Books
Algorithm & Programming Books
Electronics Engineering Books
Electrical Engineering Books
Chemical Engineering Books
Civil Engineering Books
Mechanical Engineering Books
Industrial Engineering Books
Instrumentation Engg Books
Metallurgical Engineering Books
All Stream Best Books

Questions and Answers

1000 C Questions & Answers
1000 C++ Questions & Answers
1000 C# Questions & Answers
1000 Java Questions & Answers
1000 Linux Questions & Answers
1000 Python Questions
1000 PHP Questions & Answers
1000 Hadoop Questions
Cloud Computing Questions
Computer Science Questions
All Stream Questions & Answers

India Internships

Computer Science Internships
Instrumentation Internships
Electronics Internships
Electrical Internships
Mechanical Internships
Industrial Internships
Systems Internships
Chemical Internships
Civil Internships
IT Internships
All Stream Internships

About Sanfoundry

About Us
Copyright
Terms
Privacy Policy
Jobs
Bangalore Training
Online Training
Developers Track
Mentoring Sessions
Contact Us
Sitemap
© 2011 Sanfoundry. All Rights Reserved.