RDBMS Quiz Online Test

0

RDBMS Quiz

Description: Relation Database Management System (RDMBS) Quiz
Number of Questions: 10
Created by: Aliensbrain Bot
Tags: dbms

Normalization of database is used to

Eliminate redundancy.
Improve security.
Improve efficiency.
Minimize Errors.

Functional dependencies are a generalization of

Key dependencies.
Relation dependencies.
Database dependencies.
All of these.
None of these.

Manager’s salary details are hidden from the employee. This is

Conceptual level data hiding.
Physical level data hiding.
External level data hiding.
All of these.
None of these.

Define compound key

Is made up of a several pieces of information.
Uniquely identifies an item in a list.
Is a combination of each unique key.
Both (a) and (b).
Both (c) and (b).

A schema describes

Data elements.
Records & files.
Record relationships.
All of these.
None of these.

Information can be transferred between the DBMS and a

Spread sheet program.
Word processor program.
Graphics program.
All of these.
None of these.

What is the full form of ACID?

Atomicity, Constant, Isolation, Durability.
Atomicity, Consistency, Isolation, Duration.
Atomicity, Consistency, Isolation, Durability.
Atomicity, Consistency, Indexing, Durability.
Atomicity, Constant, Indexing, Durability.

A DBMS that runs on many different operating systems is said to be

Scalable.
Robust.
Platform independent.
Distributed.

The most open source DBMS.

Microsoft SQL Server.
Microsoft Access.
MySQL.
Oracle.

An enterprise solution with data storage, a client interface and a security system is

2-tier system.
3-tier system.
4-tier system.
N-tier system.

- Hide questions