DBMS Quiz 1

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 stored in database and the relationship among the data.

• View level hides the details of data types

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

Which of the following is true about data independence?

It is the ability:

• To modify schema definition in one level without affecting schema definition in the next lower level.

• To modify schema definition in one level without affecting schema definition in the next higher level.

• To modify the data at one level without affecting the data in the next lower level

• To modify the data at one level without affecting the data in the next higher level.

3. Identify the following the correct way/s to delete all rows at a time from salary table.

• DELETE * FROM salary;

• TRUNCATE TABLE salary;

• DELETE FROM SALARY;

• TRUNCATE TABLE FROM salary;

A characteristic of an entity.

• Relation

• Attribute

• Parameter

• Constraint

The actual content in the database at a particular point.

• Schema

• Attribute

• Parameter

• Instance

In relational model, cardinality is termed as

• Number of tuples

• Number of attributes

• Number of tables

• Number of constraints

ODBC Stands for

• Object Database connectivity

• Oral Database connectivity

• Oracle Database connectivity

• Open Database connectivity

The Database schema is written in

• DCL

• DDL

• DML

• TCL

In ER model Relationship is represented by

• Rectangle

• Ellipse

• Rhombus

• Triangle

An advantage of DBMS is

• Data is dependent on programs

• Data redundancy is increases

• Data is integrated and can be accessed by multiple programs.

• None of these.