DBMS interview questions – page 3

____ represents raw facts, whereas ___ is data made meaningful.

1. Data, information
2. Information, reporting
3. Information, bits
4. Records, bytes

Which of the following places the common data elements in order from smallest to largest?

1. Character, file record, field, database
2. Character, record, field, file, database
3. Bit, byte, character, record, field, file, database
4. Character, field, record, file, database

A collection of unprocessed items is ____

1. Reports
2. Memory
3. Data
4. Information

Which command we will give if we want to show the database objects with its description?

1. List
2. Show
3. Details
4. Any of these

The simultaneous execution of two or more

1. Disk mirroring
2. Multiprocessing
3. Reduced instruction set computing
4. Sequential access

The first step in the transaction processing cycle is _____

1. Audit
2. Database operations
3. User inquiry
4. Data entry

A tuple is a

1. row of a table
2. key of a table
3. column of a table
4. two-dimensional table

The following are components of a database except _____

1. reports
2. indexes
3. metadata
4. user data

_____ is one reason for problems of data integrity.

1. Data redundancy
2. Security constraints
3. Data inconsistency
4. Data availability constraints

Forms that are used to organize business data into rows and columns are called ____

1. transaction sheets
2. business forms
3. registers
4. spreadsheets

1 k bits equal to the

1. 10 bits
2. 1000 bits
3. 1024 bits
4. 100 bits

A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as

1. DBMS
2. Data model
3. Database
4. ER model

____ search method is conducted for a specific title, domain, URL, or host.

1. Logical
2. Keyword
3. Field
4. Boolean

The management information system (MIS) structure with one main computer system us called a

1. Centralized MIS structure
2. Decentralized MIS structure
3. Distributed MIS structure
4. Hierarchical MIS structure

A collection of interrelated files in a computer is a  _____

1. Record
2. Database
3. Field
4. File manager

_____ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorized access of data.

1. Tables
2. DBMS
3. Production passwords
4. Database

What does the data dictionary identify?

1. Field formats
2. Field types
3. Field names
4. All of the above

Periodically adding, changing and deleting file records is called file

1. Renewing
2. Updating
3. Upgrading
4. Restructuring

The name of the location of a particular piece of data is its ____

1. Memory name
2. Data location
3. Storage site
4. Address

Attributes can be defined for

1. Pages
2. Macro
3. Switch board
4. Entity

What refers to a set of characters of a particular design?

1. Calligraphy
2. Typeface
3. Stencil
4. Keyface

Computer manipulate data in many ways, and this manipulation is called

1. File handling
2. Compiling
3. Batching
4. Processing

A Field is a related group of ____

1. Characters
2. Cables
3. Files
4. Records

C was primarily developed as

1. System programming language
2. Data processing language
3. General purpose language
4. None of the above

A record is related to a file as a statement is related to a ____

1. procedure
2. data
3. file
4. program

Data independency in DBMS is known as ____

1. Data modeling
2. Data hiding
3. Data consistency
4. Data capturing

We can quickly move a cursor by

1. Mouse
2. Printer
3. Keyboard
4. Monitor

A datawarehouse

1. contains numerous naming conventions and formats
2. is organized around important subject areas
3. contains only current data
4. can be updated by end users

In a database, a network structure

1. allows many-to-many relationship
2. is a physical representation of the data
3. allows only one-to-one relationship
4. none of these

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

1. Database
2. Data bank
3. Data file
4. Data record