Database Management System - 1

LIST OF ATTEMPTED QUESTIONS AND ANSWERS



Select The Blank
Question
Data types BIT and BIT VARYING are known as ________.
Correct Answer
Bit string data types
Your Answer
Bit string data types

Select The Blank
Question
A ________ is collection of tables where table is an unordered collection of rows.
Correct Answer
Relational Database
Your Answer
Relational Database

True/False
Question
Physical design is tailored to a specific DBMS system.
Correct Answer
True
Your Answer
True

Multiple Choice Single Answer
Question
WWW stands for :-
Correct Answer
World wide web
Your Answer
World wide web

Multiple Choice Multiple Answer
Question
In a two tier architecture, the software components are distributed over which two systems?
Correct Answer
Client , Server
Your Answer
Client , Server

Select The Blank
Question
________ are binary computer representations of stored logical entities.
Correct Answer
Data
Your Answer
Data

Multiple Choice Single Answer
Question
Access to a database can be controlled using :-
Correct Answer
Access Privileges
Your Answer
Access Privileges

Multiple Choice Multiple Answer
Question
Which of the following is a criterion that should be satisfied by an optimal data model?
Correct Answer
Structural validity , Express ability , Shareability
Your Answer
Structural validity , Express ability , Shareability , Maintenance of hardware system

Select The Blank
Question
A ________ is a situation, event or personnel that will adversely affect the database security and the smooth functioning of organization.
Correct Answer
Threat
Your Answer
Integrity

Multiple Choice Multiple Answer
Question
Different syntaxes used for update command in SQL are as follows :-
Correct Answer
update
set = , update

set = where

Your Answer
update from
set =


True/False
Question
Database design model help in improving maintainability.
Correct Answer
True
Your Answer
True

Multiple Choice Single Answer
Question
If role B has been previously granted to role A :-
Correct Answer
Role A cannot be granted to role B
Your Answer
Role A cannot be granted to role B

Multiple Choice Multiple Answer
Question
Write examples of dbms :-
Correct Answer
FoxBASE , FoxPro
Your Answer
FoxBASE , FoxPro , Cobol , Pascal

Multiple Choice Single Answer
Question
A database must be protected against :-
Correct Answer
Viruses
Your Answer
Viruses

Select The Blank
Question
Each attribute is associted with set of values called as________
Correct Answer
Domain
Your Answer
Domain

True/False
Question
A fuzzy checkpoint allows transactions to perform updates even while buffer blocks are being written out.
Correct Answer
True
Your Answer
True

Multiple Choice Single Answer
Question
When a particular transaction never makes progress because the data item it wants to lock is already locked and other transactions are also waiting for the same data item then it is said to be :-
Correct Answer
Starvation
Your Answer
Deadlock

True/False
Question
A program is a collections of instructions for manipulating data.
Correct Answer
True
Your Answer
True

Multiple Choice Single Answer
Question
The set of all relationships of the same type called as
Correct Answer
Relationship set
Your Answer
Relationship set

Multiple Choice Multiple Answer
Question
Deadlock prevention scheme using time stamps are:-
Correct Answer
Wait - die , Wound - wait
Your Answer
Wait - die , Wound - wait , Rollback , Starvation

Multiple Choice Multiple Answer
Question
Specify any 2 forms of insert command :-
Correct Answer
INSERT INTO SELECT , FROM , INSERT INTO SELECT , FROM WHERE
Your Answer
INSERT INTO SELECT , FROM , INSERT INTO SELECT , FROM WHERE

Multiple Choice Single Answer
Question
Which SQL statement will show contents of table book, where 2nd character of bookname is 'm' ?
Correct Answer
select * from book where bookname like '_m%'
Your Answer
select * from book where bookname like '%m_'

Select The Blank
Question
In a database for geographic information system ________ can be stored.
Correct Answer
Satellite images
Your Answer
Satellite images

Select The Blank
Question
________ is visual representation of Entity Relationships.
Correct Answer
ERD
Your Answer
Relation

Multiple Choice Multiple Answer
Question
Some clauses of GRANT command are as follows :-
Correct Answer
ALL , ON , PUBLIC
Your Answer
ALL , ON , PUBLIC

Multiple Choice Single Answer
Question
Which of the following is high level data model?
Correct Answer
Entity-Relationship model
Your Answer
Entity-Relationship model

Multiple Choice Multiple Answer
Question
Advantages of Database Management System are :-
Correct Answer
Reduced redundancy , Sharing of data , Security
Your Answer
Reduced redundancy , Sharing of data , Security , Work Space required for execution and storage is less

Select The Blank
Question
________ is the process by which the user's access to physical data in the application is limited, based on his privileges.
Correct Answer
Access control
Your Answer
Packet sniffers

Select The Blank
Question
Diagrammatic representation in data modeling is ________ to represent a model in diagrammatic notation.
Correct Answer
Capability
Your Answer
Capability

Select The Blank
Question
Entity name is written in ________ in E-R diagram.
Correct Answer
Upper case
Your Answer
Upper case

True/False
Question
The database is partitioned into some number of fixed length block called as pages.
Correct Answer
True
Your Answer
True

Multiple Choice Multiple Answer
Question
Following are properties of roles allowed for easier privilege management :-
Correct Answer
Application awareness , Reduced privilege administration , Dynamic privilege administration
Your Answer
Reduced privilege administration , Dynamic privilege administration , Application awareness

True/False
Question
Database is widely used in banking.
Correct Answer
True
Your Answer
True

Multiple Choice Single Answer
Question
What is many-to-one relationship between two sets of attributes of a given relation?
Correct Answer
Functional dependency
Your Answer
Functional dependency

Match The Following
Question
Correct Answer
Your Answer
Data files
Stores the database itself
Stores the database itself
Person who design and implement Database management system modules
Database Management system designers and implementers
Database Management system designers and implementers
Person who design and implement tools
Tool developers
Tool box developers
Person responsible for running and maintenance of Hardware and Software in a Database
Operators and maintenance personal
Operators and maintenance personal

Select The Blank
Question
File is collection of ________
Correct Answer
records
Your Answer
records

Multiple Choice Multiple Answer
Question
The levels of abstraction of data are :-
Correct Answer
Physical level , Logical level , View level
Your Answer
Physical level , Logical level , View level

True/False
Question
>= ' is arithmetic operator.
Correct Answer
False
Your Answer
False

True/False
Question
DES provides standards based encryption for data privacy.
Correct Answer
True
Your Answer
True

Multiple Choice Multiple Answer
Question
Block movements between disk and main memory are initiated through two operations namely :-
Correct Answer
Input , Output
Your Answer
Input , Output

Multiple Choice Single Answer
Question
What is alternative name for functions?
Correct Answer
Methods
Your Answer
Methods

Multiple Choice Multiple Answer
Question
ERD captures :-
Correct Answer
Entity type , Attributes , Relationship between entities
Your Answer
Entity type , Attributes , Relationship between entities

Match The Following
Question
Correct Answer
Your Answer
Menu driven interface
Stand alone user
Stand alone user
Query language interface
Casual user
Casual user
Programming language interface
Application user
Application user
Forms and command code
Parametric user
Parametric user

Select The Blank
Question
________are two critical phases in database development lifecycle.
Correct Answer
Data modeling and database design
Your Answer
Information and program

Multiple Choice Single Answer
Question
The set of all entities of the same type called as
Correct Answer
entity set
Your Answer
entity set

Multiple Choice Single Answer
Question
A graphical user interface typically displays a schema to the user in which form?
Correct Answer
Diagrammatic form
Your Answer
Statement form

Multiple Choice Single Answer
Question
Command to create table catalog having similar structure as book is :-
Correct Answer
CREATE TABLE CATALOG LIKE BOOK
Your Answer
CREATE STRUCTURE CATALOG LIKE BOOK