Database Management System Set 10

Computer Science Engineering (CSE),

Bachelor of Science in Computer Science FY (BSc CS),

Bachelor of Science in Computer Science SY (BSc CS),

Bachelor of Science in Information Technology SY (BSc IT),

Bachelor of Computer Applications (BCA),

Bachelor of Business Administration in Computer Applications (BBA [CA]),

Bachelor of Science in Information Technology (BSc IT),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Practice Mode Previous Next
On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 10

Q1 | Which of the following is the right syntax for the assertion?
  • create assertion ‘assertion-name’ check ‘predicate’;
  • create assertion check ‘predicate’ ‘assertion-name’;
  • create assertions ‘predicates’;
  • all of the mentioned
Answer: create assertion ‘assertion-name’ check ‘predicate’;
Q2 | Data integrity constraints are used to:
  • control who is allowed access to the data
  • ensure that duplicate records are not entered into the table
  • improve the quality of data entered for a specific property (i.e., table column)
  • prevent users from changing the values stored in the table
Answer: improve the quality of data entered for a specific property (i.e., table column)
Q3 | Dates must be specified in the format
  • mm/dd/yy
  • yyyy/mm/dd
  • dd/mm/yy
  • yy/dd/mm
Answer: yyyy/mm/dd
Q4 | A                  on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
  • index
  • reference
  • assertion
  • timestamp
Answer: index
Q5 | Which of the following is used to store movie and image files?
  • clob
  • blob
  • binary
  • image
Answer: blob
Q6 | The user defined data type can be created using
  • create datatype
  • create data
  • create definetype
  • create type
Answer: create type
Q7 | Values of one type can be converted to another domain using which of the following?
  • cast
  • drop type
  • alter type
  • convert
Answer: cast
Q8 | Which of the following closely resembles Create view?
  • create table . . .like
  • create table . . . as
  • with data
  • create view as
Answer: create table . . . as
Q9 | In contemporary databases, the top level of the hierarchy consists of              each of which can contain            
  • catalogs, schemas
  • schemas, catalogs
  • environment, schemas
  • schemas, environment
Answer: catalogs, schemas
Q10 | The database administrator who authorizes all the new users, modifies the database and takes grants privilege is
  • super user
  • administrator
  • operator of operating system
  • all of the mentioned
Answer: all of the mentioned
Q11 | Which of the following is used to provide privilege to only a particular attribute?
  • grant select on employee to amit
  • grant update(budget) on department to raj
  • grant update(budget,salary,rate) on department to raj
  • grant delete to amit
Answer: grant update(budget) on department to raj
Q12 | Which of the following is true regarding views?
  • the user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view
  • the user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view
  • if a user creates a view on which no authorization can be granted, the system will allow the view creation request
  • a user who creates a view receives all privileges on that view
Answer: if a user creates a view on which no authorization can be granted, the system will allow the view creation request
Q13 | 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.
  • with grant
  • grant user
  • grant pass privelege
  • with grant option
Answer: with grant option
Q14 | Which of the following is used to avoid cascading of authorizations from the user?
  • granted by current role
  • revoke select on department from amit, satoshi restrict;
  • revoke grant option for select on department from amit;
  • revoke select on department from amit, satoshi cascade;
Answer: revoke select on department from amit, satoshi restrict;
Q15 | The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation
  • the privilege must be granted only by roles
  • the privilege is granted by roles and users
  • the user role cannot be removed once given
  • by restricting the user access to the roles
Answer: the privilege must be granted only by roles
Q16 | 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?
  • embedded sql
  • dynamic sql
  • sql declarations
  • sql data analysis
Answer: dynamic sql
Q17 | Which of the following header must be included in java program to establish database connectivity using JDBC ?
  • import java.sql.*;
  • import java.sql.odbc.jdbc.*;
  • import java.jdbc.*;
  • import java.sql.jdbc.*;
Answer: import java.sql.*;
Q18 | Which of the following invokes functions in sql?
  • prepared statements
  • connection statement
  • callable statements
  • all of the mentioned
Answer: callable statements
Q19 | Which of the following function is used to find the column count of the particular resultset?
  • getmetadata()
  • metadata()
  • getcolumn()
  • get count()
Answer: getmetadata()
Q20 | Which of the following is used as the embedded SQL in COBOL?
  • exec sql ;
  • exec sql end-exec
  • exec sql
  • exec sql end exec;
Answer: exec sql end-exec
Q21 | Which of the following is used to distinguish the variables in SQL from the host language variables?
  • .
  • –
  • :
  • ,
Answer: –
Q22 | Which of the following is used to access large objects from a database ?
  • setblob()
  • getblob()
  • getclob()
  • all of the mentioned
Answer: all of the mentioned
Q23 | 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.
  • procedures
  • triggers
  • functions
  • none of the mentioned
Answer: triggers
Q24 | Triggers are supported in
  • delete
  • update
  • views
  • all of the mentioned
Answer: views
Q25 | What are the after triggers?
  • triggers generated after a particular operation
  • these triggers run after an insert, update or delete on a table
  • these triggers run after an insert, views, update or delete on a table
  • all of the mentioned
Answer: these triggers run after an insert, update or delete on a table
Previous Next