|Description: DBMS DatabasesRelational Functions of DBMSDatabase ConceptsSQLDatabase SchemaNumerical Ability|
|Number of Questions: 20|
|Created by: Ashok Pandey|
|Tags: DBMS Databases Relational Functions of DBMS Database Concepts SQL Database Schema Numerical Ability|
In which level of data abstraction is data stored?
This is the low level and here, data is stored.
Which sign is used to represent entity set in ER-diagram?
Rectangles represent entity set.
The process of designating sub grouping within an entity set is called
The process of designating sub grouping within an entity set is called specialization.
Which of the following is represented by double lines in ER-diagram?
It is represented by double lines.
Which sign is used to represent derived attribute?
It represents derived attribute.
What is the function of view level in DBMS?
View level is the highest level of abstraction that describes only part of the database and simplifies their interaction with the system.
What is described by the sub-schema?
This is done by sub-schema.
The interface between low-level data stored in the data base and the application program is provided by
A storage manager is a program module that provides the interface between low-level data stored in the data base and the application program, and the queries submitted by the system. The storage manager is responsible for the interaction with the file manager.
What is represented by double rectangles?
They are represented by the double rectangles.
Which of the following is used to write database schema?
Data definition language (DDL) is used to define the database structure.
Find the odd one out.
Union is a binary operator.
DDL and DML statements are compiled and executed by
The components of query processor are 1) DDL interpreter 2) DML compiler 3) Query evalution engine The DDL interpreter interprets DDL statements and records the definition in the data dictionary .The DML compiler translates the DML statements in a query language into an evaluation plan consisting of low-level instruction that the query evaluation engine understands.
Which of the following is a DML command?
Neither one of the above four options is correct. The example of a DML command is INSERT.
What is/are instance(s) of database?
This is the definition of instance of database.
Which type(s) of attribute(s) is/are phone number?
This attribute is like phone number, car number, etc.
Which type of command is DROP?
It is a Data Definition Language (DDL) command.
What is the function of the SAVEPOINT command?
This is the function of a SAVEPOINT command.
Which of the following is/are example(s) of Transaction Control Language (TCL) command?
Only 2 and 3 are TCL commands.
What function(s) is/are done by the Transaction Control Language (TCL) command?
It is done by Transaction Control Language (TCL) commands.
Which type of command is GRANT?
It is a Data Control Language (DCL) command.