Database Management System Set 5

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 5

Q1 | Which of the following is Database Language?

data definition language

data manipulation language

query language

all of the above

Q2 | Which of the following in not a function of DBA?

network maintenance

routine maintenance

schema definition

authorization for data access

Q3 | Which of the following represents a relationship among a set of values.

a row

a table

a field

a column

Q4 | Column header is refer as

table

relation

attributes

domain

Q5 | A Relation is a

subset of a cartesian product of a list of attributes

subset of a cartesian product of a list of domains

subset of a cartesian product of a list of tuple

subset of a cartesian product of a list of relations

Q6 | In mathematical term Table is referred as

relation

attribute

tuple

domain

Q7 | In mathematical term Row is referred as

relation

attribute

tuple

domain

Q8 | _______ allow us to identify uniquely a tuple in the relation.

superkey

domain

attribute

schema

Q9 | Minimal Superkeys are called

schema keys

candidate keys

domain keys

attribute keys

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

deletion

insertion

sorting

updating

Q11 | Which of the following is Relation-algebra Operation

select

union

rename

all of the above

Q12 | Which of the following in not Outer join?

left outer join

right outer join

full outer join

all of the above

Q13 | Who proposed the relational model?

bill gates

e.f. codd

herman hollerith

charles babbage

Q14 | Set of premitted values of each attribute is called

domain

tuple

relation

schema

Q15 | Logical design of database is called

database instance

database snapshot

database schema

all of the above

Q16 | Snapshot of the dta in the database at a given instant of time is called

database schema

database instance

database snapshot

all of the above

Q17 | Which of the following is not Unary operation?

select

project

rename

union

Q18 | Which of the following is not binary operation?

union

project

set difference

cartesian product

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

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

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

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

delete table

drop table

erase table

alter table

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

min

max

select

avg

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

simple attribute

composite attribute

multi-valued attribute

derived attribute

Q23 | In an Entity-Relationship Diagram “Ellipses” represents

attributes

weak entity set

relationship sets

multi-valued attributes

Q24 | In an Entity-Relationship Diagram “Diamonds” represents

attributes

multi-valued attributes

weak entity set

relationship sets

Q25 | Which of the following is a Data Model?

entity-relationship model

relational data model

object-based data model

all of the above

Previous Next