DBMS – Just Crack Interview

Ques:- Which of the following is a procedural language?

A. Relational algebra

B. Query language

C. Tuple relational calculus

D. Domain relational calculus

Recent Answer : Added by narendra On 2022-09-21 16:50:59:

A. Relational algebra

Ques:- A database management system

A. Allows simultaneous access to multiple files

B. Can do more than a record management system

C. Is a collection of programs for managing data into a single file

D. Both a and b

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

A. Primary keys

B. Foreign keys

C. Unique keys

D. Candidate keys

Recent Answer : Added by narendra On 2022-09-21 16:50:57:

A. Primary keys

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

A. To provide an environment that is congenial to user

B. To store the information

C. To retrieve information

D. All of the above

Ques:- In a relational model, relations are termed as

A. Rows

B. Tables

C. Attributes

D. Tuples

Recent Answer : Added by narendra On 2022-09-21 16:50:45:

D. Tuples

Ques:- DBMS helps to achieve

A. Data independence

B. More redundancy

C. Centralised manner to control of data

D. Both a and c

Recent Answer : Added by narendra On 2022-09-21 16:50:32:

D. Both a and c

Ques:- The most popular commercial DBMS is

A. Oracle

B. MySQL

C. Microsoft Access

D. Microsoft SQL Server

Recent Answer : Added by narendra On 2022-09-21 16:55:23:

A. Oracle

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

A. Foreign key

B. Super key

C. Sub key

D. Candidate key

Recent Answer : Added by Admin On 2022-09-24 15:52:30:

B. Super key

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

A. DBA

B. DBMS

C. Schema

D. Database

Recent Answer : Added by Admin On 2022-09-24 15:59:19:

B. DBMS

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

A. Relation flow

B. Scheme diagram

C. Relational algebra

D. Schematic representation

Recent Answer : Added by narendra On 2022-09-21 16:49:56:

C. Relational algebra

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

A. Tables

B. Reports

C. Forms

D. Query

Recent Answer : Added by narendra On 2022-09-21 17:57:33:

D. Query

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

A. Union

B. Select

C. Projection

D. Join

Ques:- In E-R diagram, relationship is represented by

A. Diamond shaped

B. Dashed shaped

C. Ellipse shaped

D. Rectangle shaped

Recent Answer : Added by narendra On 2022-09-21 16:55:30:

A. Diamond shaped

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

A. Intersection

B. Union

C. Join

D. Select

Recent Answer : Added by narendra On 2022-09-21 16:49:37:

C. Join

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

A. Database

B. Schema

C. Instances

D. Data model

Ques:- _____ describe what is in database fields.

A. Field names

B. Field definitions

C. Field markers

D. Structures

Recent Answer : Added by Admin On 2022-09-24 16:07:43:

A. Field names

Ques:- In an E-R diagrams, ellipses represents

A. Attributes

B. Link between attributes and entity sets

C. Relation among entity set

D. Entity set

Recent Answer : Added by Admin On 2022-09-24 15:50:39:

A. Attributes

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

A. Key

B. Rows

C. Attribute

D. Fields

Recent Answer : Added by Admin On 2022-09-24 16:00:32:

A. Key

Ques:- In a relational modes, a cardinality is termed as

A. Number of constraints

B. Number of tables

C. Number of attributes

D. Number of tubles

Recent Answer : Added by Admin On 2022-09-24 15:56:51:

D. Number of tuples

Ques:- Which of the following is not a type of database?

A. Relational

B. Hierarchical

C. Network

D. Transition

Recent Answer : Added by narendra On 2022-09-21 16:50:13:

D. Transition

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

A. Multimedia database

B. Video on demand database

C. Graphics database

D. Transaction database

Recent Answer : Added by Admin On 2022-09-25 17:15:23:

A. Multimedia database

Ques:- Which command creates and initializes one or more memory variables?

A. RELEASE

B. KEEP

C. STORE

D. UPDATE

Ques:- Report generators are used to

A. Store data input by a user

B. Retrieve information from files

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

A. Tree

B. Chain

C. Network

D. All of these

Recent Answer : Added by Admin On 2022-09-25 17:04:49:

A. Tree

Ques:- In a database, related fields are grouped to

A. File

B. Bank

C. Menu

D. Data record

Recent Answer : Added by Admin On 2022-09-25 17:04:12:

D. Data record

Ques:- The database environment has all the following components except

A. Database administrator

B. Database

C. Users

D. Separate files

Recent Answer : Added by Admin On 2022-09-25 17:06:33:

D. Separate files

Ques:- The distinguishable parts of a record are called

A. Fields

B. Files

C. Data

D. All of these

Recent Answer : Added by Admin On 2022-09-25 17:28:29:

A. Fields

Ques:- The command to convert a numeric number to characters is

A. STR ()

B. CHR ()

C. ASC ()

D. All of these

Ques:- Which normal form is considered adequate for normal relational database design?

A. 2 NF

B. 3 NF

C. 4 NF

D. 5 NF

Recent Answer : Added by Admin On 2022-09-25 17:23:48:

B. 3 NF

Ques:- One approach to standardizing storing of data is

A. CODASYL specifications

B. Structured programming

C. MIS

D. None of these

Recent Answer : Added by Admin On 2022-11-12 09:18:31:

A. CODASYL specifications