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