DBMS interview questions

Which of the following is a procedural language?

1. Relational algebra
2. Query language
3. Tuple relational calculus
4. Domain relational calculus

A database management system

1. Allows simultaneous access to multiple files
2. Can do more than a record management system
3. Is a collection of programs for managing data into a single file
4. Both a and b

Which of the following types of tables constraints will prevent the entry of duplicate rows?

1. Primary keys
2. Foreign keys
3. Unique keys
4. Candidate keys

Which of the following is/are the primary features of a DBMS?

1. To provide an environment that is congenial to user
2. To store the information
3. To retrieve information
4. All of the above

In a relational model, relations are termed as

1. Rows
2. Tables
3. Attributes
4. Tuples

DBMS helps to achieve

1. Data independence
2. More redundancy
3. Centralised manner to control of data
4. Both a and c

The most popular commercial DBMS is

1. Oracle
2. MySQL
3. Microsoft Access
4. Microsoft SQL Server

Which of the following is a set of one or more attributes taken collectively to uniquely identify a record?

1. Foreign key
2. Super key
3. Sub key
4. Candidate key

A _____ consists of a collection of interrelated data and a collection of programs to access that data.

1. DBA
2. DBMS
3. Schema
4. Database

The ____ provides a set of operations that take one or more relations as input and return a relation as an output.

1. Relation flow
2. Scheme diagram
3. Relational algebra
4. Schematic representation

The feature that database allows to access only certain records in database is

1. Tables
2. Reports
3. Forms
4. Query

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

1. Union
2. Select
3. Projection
4. Join

In E-R diagram, relationship is represented by

1. Diamond shaped
2. Dashed shaped
3. Ellipse shaped
4. Rectangle shaped

The _____ operation allows the combining of two relations by merging pairs of tubles, one from each relation, into a single tuple.

1. Intersection
2. Union
3. Join
4. Select

A _____ is an abstract model that describes how the data are organised and represented.

1. Database
2. Schema
3. Instances
4. Data model

_____ describe what is in database fields.

1. Field names
2. Field definitions
3. Field markers
4. Structures

In an E-R diagrams, ellipses represents

1. Attributes
2. Link between attributes and entity sets
3. Relation among entity set
4. Entity set

A _____ is a property of the entire relation rather than of the individual tuples in which each tuple is unique.

1. Key
2. Rows
3. Attribute
4. Fields

In a relational modes, a cardinality is termed as

1. Number of constraints
2. Number of tables
3. Number of attributes
4. Number of tubles

Which of the following is not a type of database?

1. Relational
2. Hierarchical
3. Network
4. Transition

Which command creates and initializes one or more memory variables?

1. RELEASE
2. KEEP
3. STORE
4. UPDATE

Report generators are used to

1. Store data input by a user
2. Retrieve information from files

The logical data structure with a one-to-many relationship is a

1. Tree
2. Chain
3. Network
4. All of these

In a database, related fields are grouped to

1. File
2. Bank
3. Menu
4. Data record

The database environment has all the following components except

1. Database administrator
2. Database
3. Users
4. Separate files

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

1. Multimedia database
2. Video on demand database
3. Graphics database
4. Transaction database

The distinguishable parts of a record are called

1. Fields
2. Files
3. Data
4. All of these

The command to convert a numeric number to characters is

1. STR ()
2. CHR ()
3. ASC ()
4. All of these

Which normal form is considered adequate for normal relational database design?

1. 2 NF
2. 3 NF
3. 4 NF
4. 5 NF

One approach to standardizing storing of data is

1. CODASYL specifications
2. Structured programming
3. MIS
4. None of these