WorksheetsDBMS
Total questions: 10
Worksheet time: 10mins
Which one of the following refers to the total view of the database content?
Conceptual view
Physical view
Internal view
External view
The architecture of a database can be viewed as the
One level
Two-level
Three-level
Four level
In the relation model, the relation are generally termed as .......
Tuples
Attributes
Rows
Tables
Which of the following keys is generally used to represents the relationships between the tables?
Primary key
Foreign key
Secondary key
None of the above
Which one of the following keyword is used to find out the number of values in a column?
TOTAL
COUNT
SUM
ADD
Which one of the following is commonly used to define the overall design of the database?
Application program
Data definition language
Schema
Source code
Which one of the following commands is used to modify a column inside a table?
Drop
Update
Alter
Set
In the relational table, which of the following can also be represented by the term "attribute"?
Entity
Row
Column
Both B &C
Which of the following is used in the application programs to request data from the database management system?
Data Manipulation language
Data Definition Language
Data Control Language
All of the above
Which one of the following command is used to delete the existing row in a table?
Delete
Update
Insert
None of the above
