DBMS Assignments_DBMS Sample papers_Part8

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