DBMS Online Test

Back

0

DBMS

Description: these questions are very useful for public sector exams like gail bel sail etc
Number of Questions: 15
Created by: Ashok Dhingra
Tags: database Databases

Start the Quiz

In relational model, a tuple is equivalent to _________.

record
field
file
database
table

Which of the following is/are the main objective(s) of database systems?

To eliminate data redundancy
To establish relationship between files
To manage file access
To make data access complex
Only 1, 3 and 4

In which of the following data types are addresses considered?

Numeric field
Data field
Relational field
Alpha numeric
Only 1 and 4

Managers salary is hidden from the employee. Which of the following options better explain(s) this?

Conceptual level data hiding
Physical level data hiding
External level data hiding
Only 1 and 3
Logical level data hiding

A database environment has all of the following, except:

Users
Tables
Database
Separate files
Data

Relations from ER model will always be in

1 NF
2 NF
3 NF
BC NF
4 NF

What does 'A' stand for in acid properties?

Abort
Alike
Atomic
Attribute
Action

Which of the following describes a logical schema?

Entire database
Organising data
Storing of data on disk
Revising the file structure
Shows only user specific data

What is/are the properties of sequential file organisation?

A pointer points to the next record in order.
Indexes are required to represent stored records.
A tree structure is used to represent multi level index.
If the order is lost, the file has to be re-organised.
Only 1 and 4.

A functional dependency x- > y is trivial, if _______________.

y is a subset of x
y is a proper subset of x
x is a subset of y
x is a proper subset of y
only 1 and 2

A transparent DBMS ___________.

cannot hide sensitive data
keeps its logical structure hidden
keeps its physical structure hidden
can hide sensitive data
is highly safe

A network structure represents

physical structure of data
many to many relationship
logical representation of data
a database of future
designing of database

Which of the following is/are concurrency control mechanism(s)?

Optimistic
Pessimistic
Commit
Alter
Only (1) and (2)

What does an ellipse represent in E R model?

Entity set
Attribute
Relationship
Derived attribute
Primary key

What is/are the type(s) of DML?

Procedural
Relational
Network model
Non-procedural
Only 1 and 4

- Hide questions