0

DBMS

Description: Notes and Test Papers for DBMS, RDBMS Covers all concepts Primary Key, Data, Information, Modeling language, Data structure, Database query language, Transaction mechanism
Number of Questions: 25
Created by:
Tags: DBMS Data Base RDBMS Relational Data Base Primary Key B.Sc-IT M.Sc-IT MCA BCA MCA Entrance Basic Computer C C++ ASP PHP HTML database management system notes advantages of database management system Data Base Management System Relational Data Base Management System Databases Operating System Computer Basics Computer Architect
Attempted 0/25 Correct 0 Score 0

Which of the following is not a logical data-base structure?

  1. Tree

  2. Relational Structure

  3. Network

  4. Chain


Correct Option: A

Which of the following is true of a network structure?

  1. It is a physical representation of the data.

  2. It allows a many-to-many relationship.

  3. It is conceptually simple.

  4. It will be dominant database of the future.


Correct Option: B

Embedded Pointer provides

  1. the secondary access path

  2. a physical record key

  3. an inverted index

  4. all of the above


Correct Option: A

A scheme describes

  1. data elements

  2. records and files

  3. records relationships

  4. all of the above


Correct Option: D

The highest level in the hierarchy of data organization is called

  1. data link

  2. data base

  3. data file

  4. data record


Correct Option: B

The function of a database is

  1. to check all input data

  2. to check all spellings

  3. to collect and organize input data

  4. to output data


Correct Option: C

A number of related records that are treated as a unit, are called

  1. file

  2. field

  3. data

  4. batch


Correct Option: D

Periodically adding, changing and deleting file records is called file

  1. updating

  2. upgrading

  3. restructuring

  4. renewing


Correct Option: A

The file organization technique which includes an index on every secondary field, is

  1. inverted organization

  2. multi-list organization

  3. regular organization

  4. hierarchical organization


Correct Option: A

The simplest file organization technique is

  1. inverted organization

  2. multi-list organization

  3. regular organization

  4. hierarchical organization


Correct Option: C

The file organization technique which provides a very fast direct access, is

  1. inverted organization

  2. regular organization

  3. multi-list organization

  4. hashed organization


Correct Option: D

Which of the following is not a relational database?

  1. dBASE 1V

  2. 4th dimension

  3. Fox Pro

  4. Reflex


Correct Option: D

The database environment has all of the following components, except

  1. users

  2. separate files

  3. database

  4. data-base administrator


Correct Option: B

What is the name of the given to the organized collection of software that controls the overall operation of a computer?

  1. Working system

  2. Peripheral system

  3. Operating system

  4. None of the above


Correct Option: C

What is the name of the technique in which the operating system of a computer executes several programs concurrently by switching back and forth between them?

  1. Partitioning

  2. Multi-tasking

  3. Windowing

  4. Paging


Correct Option: B

Complete indexing is defined as an index existing for every distinct field combination in the indexed file. The number of indices necessary to provide complete indexing for a file defined on 4 fields, is

  1. 6

  2. 16

  3. 8

  4. 10


Correct Option: A

The operating system of a computer serves as a software interface between the user and

  1. hardware

  2. peripherals

  3. memory

  4. screen


Correct Option: A

Which of the following system softwares does the job of merging the records from two files into one?

  1. Security software

  2. Utility program

  3. Networking software

  4. None of the above


Correct Option: D

Which of the following types of software should be used if you often need to create, edit and print document?

  1. Word processing

  2. Spread sheet

  3. Desktop publishing

  4. UNIX


Correct Option: A

A translator which reads an entire programme written in high level language and converts it into machine language code, is

  1. assembler

  2. translator

  3. compiler

  4. system software


Correct Option: C

A front-end processor is usually used in

  1. multi-programming

  2. virtual storage

  3. time-sharing

  4. multi-processing


Correct Option: B

In which addressing mode does the content of a register, specified in the instruction, is first decremented and then used as the effective address of the operands?

  1. Index addressing

  2. Indirect addressing

  3. Auto increment

  4. Auto decrement


Correct Option: D

Under virtual storage,

  1. a single program is processed by two or more CPU's

  2. two or more programs are stored concurrently in primary storage

  3. only active pages of a program are stored in primary storage

  4. inter-program interference may occur


Correct Option: B

Which of the scheduling objectives most directly applies to the following:The system should admit jobs to create a mix that will keep most devices busy.

  1. To be fair

  2. To balance resource utilization

  3. To obey priorities

  4. To be predictable


Correct Option: A

Banker's algorithm for resource allocation deals with

  1. deadlock prevention

  2. deadlock recovery

  3. mutual exclusion

  4. none of the above


Correct Option: A
- Hide questions