Database Management System Set 2

Learning Mode Previous Next

On This Page

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

Q1 | Which of the following is not Modification of the Database

updating

sorting

deletion

insertion

Q2 | Which of the following in not Outer join?

left outer join

full outer join

all of the options

right outer join

Q3 | Set of premitted values of each attribute is called

tuple

schema

domain

relation

Q4 | Which of the following is true regarding Null Value?

null<0

null=0

null<>0

null>0

Q5 | Logical design of database is called

all of the options

database schema

database instance

database snapshot

Q6 | Snapshot of the data in the database at a given instant of time is called

database instance

all of the options

database schema

database snapshot

Q7 | Which of the following is not Unary operation?

rename

union

select

project

Q8 | Which of the following is not binary operation?

union

set difference

cartesian product

project

Q9 | Which of the following is correct regarding Aggregate functions?

it takes a single value and returns a single value as result

it takes a list of values and return a single values as result

it takes a list of values and return a list of values as result

it takes a single value and returns a list of values as result

Q10 | The Primary key must be

non null

unique

option a or b

option a and b

Q11 | A command to remove a relation from an SQL database

delete table

erase table

alter table

drop table

Q12 | which of the following is not an Aggregate function?

select

avg

min

max

Q13 | The attribute that can be divided into other attributes is called

composite attribute

derived attribute

simple attribute

multi-valued attribute

Q14 | What is ACID properties of Transactions?

atomicity, consistency, isolation, database

automatically, concurrency, isolation, durability

atomicity, consistency, isolation, durability

atomicity, consistency, inconsistent, durability

Q15 | If every non-key attribute is functionally dependent on the primary key, the relation will be in

fourth formal form

third normal form

first normal form

second normal form

Q16 | Database locking concept is used to solve the problem of

inconsistent data

all of the options

lost update

uncommitted dependency

Q17 | UML is stands for

universal modeling language

united modeling language

uni modeling language

unified modeling language

Q18 | Data Manipulation Language (DML) is not to

insertion of new information into the database

modification of information in the database

create information table in the database

deletion of information in the database

Q19 | Which of the following in true regarding Referential Integrity?

every primary-key value must match a primary-key value in an associated table

every primary-key value must match a foreign-key value in an associated table

every foreign-key value must match a foreign-key value in an associated table

every foreign-key value must match a primary-key value in an associated table

Q20 | Which of the following option is use to retrieval of data?

stack

data structure

linked list

query

Q21 | ODBC stands for ______

none of above

open database connection

offline database connection

oriented database connection

Q22 | Which of the following is an unary operation?

selection operation

primitive operation

projection operation

generalized selection

Q23 | Which SQL Query is use to remove a table and all its data from the database?

none of these

drop table

create table

alter table

Q24 | In precedence of set operators the expression is evaluated from:

left to right

right to left

left to left

right to right

Q25 | In DBMS, FD stands for _______

facilitate data

functional data

facilitate dependency

functional dependency

Previous Next