Database Management System MCQs
749+ questions with answers
The database administrator who authorizes all the new users, modifies the database and takes grants privilege is
Which of the following is used to provide privilege to only a particular attribute?
Which of the following statement is used to remove the privilege from the user Amir?
Which of the following is true regarding views?
If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.
Which of the following is used to avoid cascading of authorizations from the user?
The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation
Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?
Which of the following header must be included in java program to establish database connectivity using JDBC ?
DriverManager.getConnection(_______ , ______ , ______) What are the two parameters that are included?
Which of the following invokes functions in sql?
Which of the following function is used to find the column count of the particular resultset?
Which of the following is a following statement is a prepared statements?
Which of the following is used to distinguish the variables in SQL from the host language variables?
Which of the following is used to access large objects from a database ?
Which of the following is used to input the entry and give the result in a variable in a procedure?
The format for compound statement is
A stored procedure in SQL is a___________
Temporary stored procedures are stored in _________ database.
Declare out of classroom seats condition DECLARE exit handler FOR OUT OF classroom seats BEGIN SEQUENCE OF statements END
A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.
What are the after triggers?
The default extension for an Oracle SQL*Plus file is:
What are the different in triggers?
Triggers ________ enabled or disabled
Which prefixes are available to Oracle triggers?
Any recursive view must be defined as the union of two subqueries: a _______ query that is nonrecursive and a __________ query.
Ranking of queries is done by which of the following?
In rank() function if one value is shared by two tuples then
The __________ function that does not create gaps in the ordering.
If there are n tuples in the partition and the rank of the tuple is r, then its ________ is defined as (r −1)/(n−1).
The functions which construct histograms and use buckets for ranking is
The command ________________ such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
OLAP stands for
Data that can be modeled as dimension attributes and measure attributes are called _______ data.
The generalization of cross-tab which is represented visually is ____________ which is also called as data cube.
The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is
The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________
In SQL the cross-tabs are created using
What do data warehouses support?
Which one of the following is the right syntax for DECODE?
Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
Which of the following is a fundamental operation in relational algebra?
Which of the following is used to denote the selection operation in relational algebra?
For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.
The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
Which is a unary operation: