Font size
WorksheetsDBMS Quiz 1
Total questions: 10
Worksheet time: 10mins
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.
