DBMS interview questions – page 4

Which language is used by most of DBMSs for helping their users to access data?

1. HLL
2. Query language
3. SQL
4. 4 GL

The relational database management (RDBM) system manages data in more than one file at once. How does it organize these files?

1. Relations
2. Tables
3. Tuples
4. Both (a) and (b)

A table consists of

1. Rows and cells
2. Rows and columns
3. Fields and columns
4. None of these

In a large DBMS

1. each user can access every sub schema
2. each sub schema contains every field in the logical schema
3. each user can “see” only a small part of the entire database
4. all of these

A network schema

1. stores data in tables
2. restricts the structure to a one-to-many relationship
3. permits many-to-many relationships
4. none of these

Administrative supervision of database activities is the responsibility of the

1. DB manager
2. DP manager
3. VP-DP administration
4. Database administrator

A file consists of

1. Fields and records
2. Records and sorts
3. Fields and sorts
4. Databases and fields

An entry in the telephone book can be compared to a

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

A command that lets you change one or more fields in a record is

1. Look-up
2. Insert
3. Modify
4. None of these

The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in a/an

1. Sequential file
2. Hashed file
3. Indexed file
4. B-tree file

Information can be transferred between DBMS and a

1. Graphics program
2. Word processor program
3. Spreadsheet program
4. All of these

A field that uniquely identifies which person, thing, or event the record describes is a ____

1. Key
2. Field
3. Data
4. File

A data dictionary doesn’t provide information about ____

1. the size of the disk storage disk
2. where data is located
3. how owns or is responsible for the data
4. who owns or is responsible for the data

Participants can see and hear each other in a/an

1. Message system
2. Bulletin board
3. Teleconference
4. Electronic mail system

Example of non-numeric data is

1. Bank balance
2. Examination score
3. Employee address
4. All of these

Error which is diagnosed by compiler is

1. Semantic error
2. Logical error
3. Syntax error
4. None of the above

What is the difference between html and oracle?

What is your nick name?

Tell me about your project, searching and sorting algorithms?

What is Business Communication?

What is mysql?

What is the foreign key?

When the fan trap may exist in ER model.

What is the minimum cardinality of zero specifies?

What is view level or external level data hiding?

What are the drawbacks of the file system which is overcome on the database management system?

What are various types of locking techniques?

What is lock?

What are the various methods of controlling concurrency ?

What is result equivalent?