Database Management System Questions and Answers Part-22

1. Which of the following is true for Seeheim model?
a) Presentation is abstracted from dialogue and Application
b) Presentation and Dialogue is abstracted from Application
c) Presentation and Application is abstracted from Dialogue
d) None of the mentioned

Answer: a
Explanation: Presentation is abstracted from dialogue and application.

2. Which of the unit operation is used in Model view controller?
a) Is a Decomposition
b) Part Whole Decomposition
c) All of the mentioned
d) None of the mentioned

Answer: b
Explanation: Part whole decomposition is applied to MVC.

3. Memory address refers to the successive memory words and the machine is called as ______________
a) word addressable
b) byte addressable
c) bit addressable
d) Terra byte addressable

Answer: a
Explanation: word addressable

4. Which layer deals which deals with user interaction is called _____________ layer.
a) Business logic
b) Presentation
c) User interaction
d) Data access

Answer: b
Explanation: The single application may have several different versions of this layer, corresponding to distinct kinds of interfaces such as Web browsers, and user interfaces of mobile phones, which have much smaller screens.

5. The _____________ layer, which provides a high-level view of data and actions on data.
a) Business logic
b) Presentation
c) User interaction
d) Data access

Answer: a
Explanation: Business logic

6. The ______________ layer, which provides the interface between the business-logic layer and the underlying database.
a) Business logic
b) Presentation
c) User interaction
d) Data access

Answer: d
Explanation: Many applications use an object-oriented language to code the business-logic layer, and use an object-oriented model of data, while the underlying database is a relational database.

7. The _____________ system is widely used for mapping from Java objects to relations.
a) Hibernate
b) Object oriented
c) Objective
d) None of the mentioned

Answer: a
Explanation: In Hibernate, the mapping from each Java class to one or more relations is specified in a mapping file.

8. Which among the following are the functions that any system with a user interface must provide?
a) Presentation
b) Dialogue
c) All of the mentioned
d) None of the mentioned

Answer: a
Explanation: Presentation and Application are the functions that any system with a user interface must provide.

9. Which of the following is the main task accomplished by the user?
a) Compose a document
b) Create a spread sheet
c) Send mail
d) All of the mentioned

Answer: d
Explanation: All of the mentioned are the main task accomplished by the user.

10. What are the portability concerns founded in Seeheim model?
a) Replacing the presentation toolkit
b) Replacing the application toolkit
c) Replacing the dialogue toolkit
d) Replacing the presentation & application toolkit

Answer: d
Explanation: The portability concerns founded in Seeheim model are- Replacing the presentation toolkit and Replacing the application toolkit.