Tuesday, April 7, 2009
DBMS Assignments_DBMS Sample papers_Part2
Database management system : DBMS LIST OF ATTEMPTED QUESTIONS AND ANSWERS
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 CATALOG LIKE BOOK
Database management system : DBMS Select The Blank
Question The current page changes when the transaction performs a ________ operation.
Correct Answer Write
Your Answer Modify
Select The Blank
Question ________are binary computer representations of stored logical entities
Correct Answer Data
Your Answer Program
Database management system : DBMS True/False
Question In Database management system, protection includes against hardware and Software malfunctions and not against unauthorized access.
Correct Answer False
Your Answer False
Database management system : DBMS True/False
Question In the hierarchical model, records are organized as a collection of trees.
Correct Answer True
Your Answer True
Multiple Choice Single Answer
Question Data can be inserted by row in a table using following command :-
Correct Answer INSERT
Your Answer INSERT
Match The Following
Question Correct Answer Your Answer
Data model Must know entities, relation, attributes Used in physical modeling
Shareability Optimal data model's characteristics Must know entities, relation, attributes
E-R model Widely used conceptual model Widely used conceptual model
Database design Conversion into computer usable form Optimal data model's characteristics
Database management system : DBMS True/False
Question If attribute is multi-valued then single lines are used.
Correct Answer False
Your Answer False
Multiple Choice Multiple Answer
Question ERD captures :-
Correct Answer Entity type , Attributes , Relationship between entities
Your Answer Entity type , Attributes , Relationship between entities
Multiple Choice Multiple Answer
Question Write names of high level languages :-
Correct Answer COBOL , Pascal
Your Answer COBOL , Pascal , Assembly
Database management system : DBMS Select The Blank
Question Entities are represented in ________in E-R diagram
Correct Answer Rectangular box
Your Answer Rectangular box
Multiple Choice Single Answer
Question What type of Database system can have the actual database and Database system software spread over many sites, which is connected over computer network?
Correct Answer Distributed
Your Answer Centralized
Multiple Choice Multiple Answer
Question What are secured using authorization and access control?
Correct Answer The intranet , Local clients , Operators
Your Answer Local clients , Operators , The internet
Database management system : DBMS Select The Blank
Question Each table is given ________ in DBMS.
Correct Answer An Extension
Your Answer An attribute
Select The Blank
Question ________ regulates all user access to named objects through privileges.
Correct Answer Discretionary access control
Your Answer System access control
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 The set of all entities of the same type is called as :-
Correct Answer Entity set
Your Answer Entity set
Select The Blank
Question The first commercial RDBMS was ________from Relational Software Inc.
Correct Answer ORACLE
Your Answer ORACLE
Database management system : DBMS True/False
Question A database can avoid data inconsistency.
Correct Answer True
Your Answer True
Select The Blank
Question ________are collection of instructions for manipulating data
Correct Answer program
Your Answer program
Multiple Choice Multiple Answer
Question There are two types of views namely :-
Correct Answer Updatable views , Non updatable views
Your Answer Updatable views , Non updatable views
Select The Blank
Question In________there is no security of data
Correct Answer DBMS
Your Answer DBMS
Database management system : DBMS Multiple Choice Single Answer
Question Write output of following example SELECT SUBSTR('SECURE',3,4) FROM DUAL
Correct Answer CURE
Your Answer CURE
Multiple Choice Multiple Answer
Question Some examples of select command are as following using emp_table :-
Correct Answer select * from emp; , select empno, name from emp , select empno, name from emp where salary in(9000,10000);
Your Answer select * from emp; , select empno, name from emp , select empno, name from emp where salary in(9000,10000);
Select The Blank
Question Each attribute is associted with set of values called as________
Correct Answer Domain
Your Answer Domain
Select The Blank
Question File is collection of ________
Correct Answer records
Your Answer Data
Multiple Choice Multiple Answer
Question Which of the following are object oriented features?
Correct Answer Inheritance , Abstraction
Your Answer Inheritance , Abstraction , Polymerization
True/False
Question Using database redundancy can be removed.
Correct Answer True
Your Answer True
Multiple Choice Multiple Answer
Question The back end manages :-
Correct Answer Access Structures , Concurrency control
Your Answer Access Structures , Graphical user interfaces , Concurrency control
Select The Blank
Question Based on the SEQUEL/2 or SQL IBM developed another system called________.
Correct Answer System R
Your Answer SQL
Select The Blank
Question File is collection of ________.
Correct Answer Records
Your Answer Data
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
Multiple Choice Multiple Answer
Question Strong entities are also called as :-
Correct Answer Dominant , Parent , Owner
Your Answer Dominant , Parent , Owner
Select The Blank
Question A ________ mechanism that can be used to provide authorization.
Correct Answer Role
Your Answer Privilege
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
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 , Maintenance of hardware system
Multiple Choice Multiple Answer
Question Attributes are classified as :-
Correct Answer Simple , Composite , Multivalued
Your Answer Simple , Composite , Multivalued
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
Multiple Choice Single Answer
Question Security issues become more complex in which environment?
Correct Answer Network
Your Answer Network
Multiple Choice Single Answer
Question The log is a sequence of :-
Correct Answer Log Records
Your Answer Transactions
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
Select The Blank
Question ________ database involves specifying the data types structures for the data to be stored.
Correct Answer Defining
Your Answer Defining
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
True/False
Question Security is important issue in database management .
Correct Answer True
Your Answer True
Multiple Choice Single Answer
Question Which a function returns number of rows in the tables including duplicates?
Correct Answer count(*)
Your Answer count(*)
Multiple Choice Single Answer
Question If a user is able to manipulate system resources to deny their availability to other users, then this is referred to as :-
Correct Answer Denial of service
Your Answer Denial of service
Select The Blank
Question Enitity name is written in ________in E-R diagram
Correct Answer upper case
Your Answer upper case
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment