Database Management System - 9

LIST OF ATTEMPTED QUESTIONS AND ANSWERS


Multiple Choice Single Answer
Question Write a command to remove all privileges on catalogue table from user "Mathew" :-
Correct Answer REVOKE ALL ON CATALOGUE FROM MATHEWS
Your Answer REVOKE ALL ON CATALOGUE FROM MATHEWS


Multiple Choice Multiple Answer
Question Major difficulties in referring to the log is :-
Correct Answer Time Consuming , Redoing transactions which have already written their updates to the database
Your Answer Time Consuming , Redoing transactions which have already written their updates to the database


Select The Blank
Question Entities are represented in ________in E-R diagram
Correct Answer Rectangular box
Your Answer Rectangular box


True/False
Question SQL is low level language.
Correct Answer False
Your Answer False


Select The Blank
Question The information collected in requirement analysis stage is ________ for information modeling.
Correct Answer Input
Your Answer Processing


Multiple Choice Single Answer
Question The SQL statement, which will show contents of table book, where last character of bookname is 'm' is :-
Correct Answer select * from book where bookname like '%m'
Your Answer select * from book where bookname like '%m'


Multiple Choice Multiple Answer
Question Which of the following are functions of DBA?
Correct Answer Installing and upgrading the dbms , Enrolling users and maintaining security , Contacting dbms vendor for technical support
Your Answer Installing and upgrading the dbms , Enrolling users and maintaining security , Contacting dbms vendor for technical support


True/False
Question To update city_name to bombay following command is used. UPDATE EMP_TABLE SET CITY='BOMBAY';
Correct Answer True
Your Answer True


Multiple Choice Single Answer
Question Write a command to remove update authority on price and year columns of the catalog tables from user "Alexis" :-
Correct Answer REVOKE UPDATE(PRICE,YEAR) ON CATALOG FROM ALEXIS
Your Answer REVOKE UPDATE(PRICE,YEAR) ON CATALOG FROM ALEXIS


True/False
Question Internal schema means how and where data are organized in physical data storage.
Correct Answer True
Your Answer True


Multiple Choice Multiple Answer
Question Functions at the server end are :-
Correct Answer Query , Transaction
Your Answer Transaction , User interface , Application Program


Select The Blank
Question The users of the database don't have to worry about ________of the database.
Correct Answer Internal working
Your Answer Internal working


Multiple Choice Single Answer
Question Each role granted to a user is :-
Correct Answer Enabled or disabled
Your Answer Enabled or disabled


True/False
Question A user can grant any object privilege on any object he or she owns to any other user or role.
Correct Answer True
Your Answer True


Select The Blank
Question The current page changes when the transaction performs a ________ operation.
Correct Answer Write
Your Answer Modify


True/False
Question You cannot grant or revoke system privileges to users and roles.
Correct Answer False
Your Answer False


Multiple Choice Multiple Answer
Question Requirement analysis includes :-
Correct Answer Human factors of applications , Application's functionality , All information used by application
Your Answer Human factors of applications , Application's functionality , All information used by application


Select The Blank
Question ________provides a graphical means of modeling various components of software system
Correct Answer UML
Your Answer UML


Multiple Choice Single Answer
Question Transaction which can no longer continue with normal execution because of internal conditions such as bad input, data not found, overflow are called as :-
Correct Answer Logical Error
Your Answer Logical Error


Select The Blank
Question ________ is a process by which the user's privileges are ascertained.
Correct Answer Authorization
Your Answer Authorization


Multiple Choice Multiple Answer
Question Write names of high level languages :-
Correct Answer COBOL , Pascal
Your Answer COBOL , Pascal


Multiple Choice Single Answer
Question Write output of following example SELECT initcap('JOHN MARTIN') FROM DUAL;
Correct Answer John Martin
Your Answer john martin


True/False
Question Unary operator operates only on one operand.
Correct Answer True
Your Answer True


Multiple Choice Single Answer
Question Which type of attribute represents a value that is derivable from the value of related attribute?
Correct Answer Derived attribute
Your Answer Derived attribute


Multiple Choice Multiple Answer
Question The functions of Database administrator are :-
Correct Answer Authorization for data access , Schema definition , Maintenance ofDatabase
Your Answer Authorization for data access , Schema definition , Maintenance of Database


True/False
Question A relational model relates records by the value that they contain.
Correct Answer True
Your Answer True


Select The Blank
Question ________are collection of instructions for manipulating data
Correct Answer program
Your Answer program


Select The Blank
Question In________there is no security of data
Correct Answer DBMS
Your Answer RDBMS


Multiple Choice Multiple Answer
Question Application development tools are :-
Correct Answer Power Builder , VB
Your Answer Oracle


Select The Blank
Question SQL as a language is ________ of the way it is implemented internally.
Correct Answer Independent
Your Answer Different


Multiple Choice Multiple Answer
Question Different types of log based recovery are:-
Correct Answer Deferred database modification , Immediate database modification , Checkpoints
Your Answer Deferred database modification , Immediate database modification , Checkpoints


Multiple Choice Multiple Answer
Question Which of the following are object oriented features?
Correct Answer Abstraction , Inheritance
Your Answer Inheritance , Abstraction


Multiple Choice Multiple Answer
Question The interface between the front end and the back end is through :-
Correct Answer SQL , Application program
Your Answer SQL , Application program , Assembly language , Data Definition language


Match The Following
Question Correct Answer Your Answer

Relationship Constraints Relationship between entities Relationship between entities

Temporal constraints Time period validation Time period validation

Structural constraints Data structures Data structures

Range constraints Limit values of attributes Limit values of attributes



Select The Blank
Question An entity that does not have sufficient attributes to form a primary key is termed ________.
Correct Answer Weak entity set
Your Answer Weak entity set


True/False
Question The shadow page table is never changed over the duration of the transaction.
Correct Answer True
Your Answer True


Multiple Choice Single Answer
Question Write output of following example SELECT lower('JOHN MARTIN') FROM DUAL;
Correct Answer john martin
Your Answer john martin


Match The Following
Question Correct Answer Your Answer

E-R diagram Similar to class diagram Similar to class diagram

Use case Interaction between users and system Interaction between users and system

Activity diagrams Flow of tasks between components Flow of tasks between components

Implementation diagram System components and their connection System components and their connection



True/False
Question If company policy does not support more than 100 employees in a department. So Dept-Emp relationship is "one to many relationship".
Correct Answer True
Your Answer True


Select The Blank
Question In 1978 the ________ approved the SQL database language project which led to the formulation of the initial SQL standard language.
Correct Answer ANSI American national std institute
Your Answer ANSI American national std institute


Select The Blank
Question UML additionaly provide set of ________that can be invoked to compute values on the basis of attributes of the object
Correct Answer functions
Your Answer functions


Multiple Choice Single Answer
Question The command to revoke the system privileges for creating tables from 'Smita' is :-
Correct Answer REVOKE CREATE TABLE FROM SMITA
Your Answer REVOKE TABLE CREATE FROM SMITA


Select The Blank
Question Enitity name is written in ________in E-R diagram
Correct Answer upper case
Your Answer upper case


Select The Blank
Question In an Entity ________ data model Relationship is an association among several entities.
Correct Answer Relationship
Your Answer Relationship


Select The Blank
Question A ________ mechanism that can be used to provide authorization.
Correct Answer Role
Your Answer Role


Select The Blank
Question ________are binary computer representations of stored logical entities
Correct Answer Data
Your Answer Program


Select The Blank
Question The most widely used conceptual model is________.
Correct Answer E-R model
Your Answer E-R model