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
No comments:
Post a Comment