DBMS interview questions – page 2

The command that add a new field to an active database is

1. MODIFY STRUCTURE
2. MODIFY COMMAND
3. MODIFY REPORT
4. MODIFY LABEL

Which of the following component of a computer system is the most important to a database management system?

1. High speed, large capacity disk
2. High resolution video display
3. Mouse
4. Printer

In a relational schema, each tuple is divided into fields called

1. Domains
2. Queries
3. Relations
4. None of these

An indexing operation

1. Establishes an index for a file
2. Sorts a file using two keys
3. Sorts a file using a single key
4. Both (b) and (c)

The modify operation is likely to be done after

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

A prescribed set of well- defined instructions for solving mathematical problems is called ____

1. An algorithm
2. A description
3. A code
4. A compiler

A collection of interrelated records is called a

1. Database
2. Spreadsheet
3. Management information system
4. Text file

The method of file organization in which data records in a file are arranged in a specified order according to key field is known as the

1. Sequential access method
2. Queuing method
3. Predetermined method
4. Direct access method

Unlike filters queries can be saved as in a database.

1. Database
2. Filters
3. Objects
4. Any of the above

External database is

1. Database created using DBMS package
2. Database created in MS-Word
3. Database created in EXCEL
4. All of the above

ROLLBACK in a database is ____ statement.

1. DDL
2. DML
3. DCL
4. TCL

Collecting personal information and effectively posing as another individual is known as the crime of _____

1. Spooling
2. Identity theft
3. Hacking
4. Spoofing

A DBMS that combines a DBMS and an application generator is ____

1. Oracle Corporation’s Oracle
2. Microsoft’s SQL Server
3. Microsoft’s Access
4. None of these

E.F. Codd represented _____ rules that a database must obey if it has to be considered truly relational.

1. 6
2. 8
3. 10
4. 12

The ability to find an individual item in a file immediately

1. Sequential access
2. File allocation table
3. Directory
4. Direct access

A telephone number, a birth date, and a customer name are all examples of

1. A database
2. A file
3. Data
4. A record

You organize files by storing them in

1. Archives
2. Indexes
3. Folders
4. Lists

The issues that deals with the collection and use of data about individuals is

1. Accuracy
2. Access
3. Privacy
4. Publicity

The database administrator is, in effect, the coordinator between them ____ and the ____

1. Database, users
2. Application program; database
3. DBMS; database
4. Application programs; users

In order to understand DBMS, it is important to understand?

1. The physical schema
2. One sub schema
3. All sub schema that are system support
4. Both (a) and (b)

Where will we find the referential integrity command?

1. Table
2. Tools
3. Format
4. None of these

The DBMS that is most difficult to use is ____

1. Oracle Corporation’s Oracle
2. Microsoft’s Access
3. Microsoft’s SQL Server
4. None of these

An adhoc query is a  _____

1. Pre-planned question
2. Pre-scheduled question
3. Spur-of the moment question
4. None of these

Which is one function of a database management system (DBMS)?

1. Preventing errors arising, while enabling multiple, simultaneous users
2. Deciding what to do with legacy systems
3. Identifying what a user needs
4. Ensuring usability

When data changes in multiple lists and all lists are not updated, this causes

1. Data redundancy
2. Data inconsistency
3. Duplicate data
4. Information overload

An application where only one user accesses the database at a given time is an example of a(n)____

1. Single-user database application
2. Multiuser database application
3. E-commerce database application
4. Data mining database application

Databases overall structure is maintained in a file called

1. Control file
2. Data file
3. Redolog file
4. None of these

Part number, part description, and number of parts ordered are examples of

1. Output
2. Input
3. Processing
4. Control

Which of these is considered intelligent CASE tool

1. Upper CASE
2. Methodology companion
3. Workbench
4. Lower CASE

A programming methodology used with internet are

1. C++ programming
2. GVI programming
3. HTML programming
4. None of the above