Database Management System Set 6

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 6

Q1 | What is ACID properties of Transactions?

atomicity, consistency, isolation, database

atomicity, consistency, isolation, durability

atomicity, consistency, inconsistent, durability

automatically, concurrency, isolation, durability

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

first normal form

second normal form

third normal form

fourth formal form

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

lost update

uncommitted dependency

inconsistent data

all of the above

Q4 | UML is stands for

universal modeling language

unified modeling language

united modeling language

uni modeling language

Q5 | Data Manipulation Language (DML) is not to

create information table in the database

insertion of new information into the database

deletion of information in the database

modification of information in the database

Q6 | 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 primary-key value in an associated table

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

Q7 | ODBC stands for ______

offline database connection

oriented database connection

open database connection

none of above

Q8 | Which algebra is widely used in DBMS?

relational algebra

arithmetic algebra

both

none

Q9 | Which of the following is an unary operation?

selection operation

generalized selection

primitive operation

projection operation

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

create table

alter table

drop table

none of these

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

left to left

left to right

right to right

right to left

Q12 | In DBMS FD stands for _______

facilitate data

functional data

facilitate dependency

functional dependency

Q13 | How many types of keys in Database Design?

candidate key

primary key

foreign key

all of these

Q14 | Which of the following is based on Multi Valued Dependency?

first

second

third

fourth

Q15 | Which of the following is the structure of the Database?

table

schema

relation

none of these

Q16 | The minimal set of super key is called

primary key

secondary key

candidate key

foreign key

Q17 | A relation that has no partial dependencies is in which normal form

first

second

third

bcnf

Q18 | A functional dependency between two or more non-key attributes is called

transitive dependency

partial transitive dependency

functional dependency

partial functional dependency

Q19 | A logical description of some portion of database that is required by a user to perform task is called as

system view

user view

logical view

data view

Q20 | ______________ is a classical approach to database design?

left – right approach

right – left approach

top – down approach

bottom – up approach

Q21 | _____________ refers to the correctness and completeness of the data in a database?

data security

data integrity

data constraint

data independence

Q22 | A table that displays data redundancies yields ____________ anomalies

insertion

deletion

update

all of the above

Q23 | A lock that allows concurrent transactions to access different rows of the same table is known as a

field-level lock

row-level lock

table-level lock

database-level lock

Q24 | A type of query that is placed within a WHERE or HAVING clause of another query is called

super query

sub query

master query

multi-query

Q25 | A transaction completes its execution is said to be

saved

loaded

rolled

committed

Previous Next