DBMS first 10 questions

Duplication of data at several places is called as _______________.

• Data Inconsistency

• Database

• Data Redundancy

• Data Atomicity

Which of the following is incorrect regarding levels of abstraction in database ?

• Physical level describes how to store a record and not the relationship among the data.

• Logical level describes what data to store in database and the relationship among the data.

• Physical level describes what data to store in the database.

• View level describe only part of entire database.

Bank customer can withdraw money from bank account using ATM machine interfaces. Which type of user is a bank customer

• Naïve user

• Application Developer

• DBA

• Programmer

The physical storage structure or device could be changed without affecting the conceptual schema, this is known as _____

• Physical data Independence

• Logical data Independence

• External data independance

• View data independance

_________ is a sub component of Query processor Which executes low level instructions

• Complier and Linker

• File Manager

• Buffer Manager

• Query Evaluation engine

If you want to maintain and store information about your car inurance company, a car would be considered a(n) _____

• Relation

• Entity

• Instance

• Instance

What is cardinality of relation between loan and customer in the given diagram

• A loan can be borrowed by at most 1 customer and a customer can borrow at most 1 loan

• A loan can be borrowed by N customer and a customer can borrow at most 1 loan

• A loan can be borrowed by at most 1 customer and a customer can borrow N loans

• A loan can be borrowed by N customer and a customer can borrow at most N loan

One of the limitation of ER model is that it can not

• Use Generlization

• Express relationship among relationship

• Use single primary key

• None of the above

The attribute Percentage is calculated from Total_Marks. The attribute Percentage is

• Single valued

• Multi valued

• Composite

• Derived

Which of the following symbols represent Weak Entity Set in an ER diagram

• Rectangle

• Double Rectangle

• Double Ellipse

• Ellipse