0

DBMS Architecture and its Classification

Description: DBMS Architecture and its Classification
Number of Questions: 15
Created by:
Tags: DBMS Architecture and its Classification Data Structure Database Management System Database Oracle
Attempted 0/15 Correct 0 Score 0

Which of the following in Oracle architecture is a database management system that is able to store, manage and manipulate data?

  1. The Oracle instance

  2. The Oracle database

  3. The Oracle server

  4. Database schema

  5. Package


Correct Option: C
Explanation:

This in Oracle architecture is a database management system, which is able to store, manage and manipulate data.

Which data structure in a compiler is used for managing information about variables and their attributes?

  1. Abstract syntax tree

  2. Symbol table

  3. Semantic stack

  4. Parse table


Correct Option: B
Explanation:

Symbol table is used for storing information about variables and their attributes by compiler.

The model for a record management system might be a

  1. business form

  2. handwritten list

  3. rolodex card file

  4. all of above


Correct Option: D

Which of the following is at the highest level in the hierarchy of data organisation?

  1. Data record

  2. Data file

  3. Database

  4. Data bank


Correct Option: C

Which database handles full text data, image, audio and video?

  1. Transaction database

  2. Graphics database

  3. Video on demand database

  4. Multimedia database


Correct Option: D

Which of the following contains a complete record of all the activities that affect the contents of a database?

  1. Transaction log

  2. Query language

  3. Report writer

  4. Data manipulation language


Correct Option: A
Explanation:

  Transaction log is a history of actions executed by a DBMS to guarantee ACID properties over crashes or hardware failures.

A data dictionary does not provide information about

  1. where the data is located

  2. who owns it

  3. the size of disk storage device

  4. how the data is used


Correct Option: C

Which of the following is a record based logical model?

  1. Network model

  2. Object oriented model

  3. Object based

  4. E-R model


Correct Option: A

Which of the following is a relational database?

  1. 4th Dimension

  2. Foxpro

  3. D base-IV

  4. All of the above


Correct Option: D

Which of the following is the highest level of data abstraction?

  1. Physical

  2. Logical

  3. View

  4. None of above


Correct Option: C

A DBMS consists of application programs called

  1. Fortran

  2. Autoflow

  3. BPL

  4. Total


Correct Option: C

If the changes done on the physical data storage does not affect the logical data storage, they are known as ______________.

  1. logical data independence

  2. physical data independence

  3. external data independence

  4. user data independence


Correct Option: B
Explanation:

In physical data independence, the changes done on the physical data independence does not affect the logical data independence.

____________ defines how and where data are stored in physical data storage.

  1. Internal schema

  2. Conceptual schema

  3. User schema

  4. Logical schema


Correct Option: A
Explanation:

Internal schema or physical schema define how and where data are stored or organized in a physical data storage.

A large computer information system maintains many different computer files, which file is called perpetual file?

  1. Log file

  2. Master file

  3. Specialised file

  4. Update file


Correct Option: B

Which of the following objects in distributed database receives a request for information from another node?

  1. Client

  2. Database server

  3. Global coordinator

  4. Local coordinator

  5. Commit point site


Correct Option: B
Explanation:

This object in distributed database receives a request for information from another node.

- Hide questions