• DBMS
Back
0

DBMS

Description: DBMS DatabasesRelational Functions of DBMSDatabase ConceptsSQLDatabase SchemaNumerical Ability
Number of Questions: 20
Created by:
Tags: DBMS Databases Relational Functions of DBMS Database Concepts SQL Database Schema Numerical Ability
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

In which level of data abstraction is data stored?

  1. View level

  2. Physical level

  3. Logical level

  4. Virtual level

  5. None of these

Show answer
Correct Option: B
Explanation:

This is the low level and here, data is stored.

Which sign is used to represent entity set in ER-diagram?

  1. Rectangle

  2. Ellipse

  3. Diamond

  4. Line

  5. Double ellipse

Show answer
Correct Option: A
Explanation:

Rectangles represent entity set.

The process of designating sub grouping within an entity set is called

  1. generalization

  2. aggregation

  3. attribute inheritance

  4. specialization

  5. none of these

Show answer
Correct Option: D
Explanation:

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?

  1. Multi-valued attribute

  2. Relationship status

  3. Derived attribute

  4. Total participation of an entity set

  5. None of these

Show answer
Correct Option: D
Explanation:

It is represented by double lines.

Which sign is used to represent derived attribute?

  1. Line

  2. Ellipse

  3. Double ellipse

  4. Dashed ellipse

  5. None of these

Show answer
Correct Option: D
Explanation:

It represents derived attribute.

What is the function of view level in DBMS?

  1. Simplifies how data is stored

  2. Simplifies what data is stored in the database

  3. Collects the information stored in the database at a particular moment

  4. Simplifies database interaction with the system

  5. None of these

Show answer
Correct Option: D
Explanation:

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?

  1. Database design at logical level

  2. Different views of the database

  3. Database design at physical level

  4. Complex low-level data structure

  5. None of these

Show answer
Correct Option: B
Explanation:

This is done by sub-schema.

The interface between low-level data stored in the data base and the application program is provided by

  1. storage manager

  2. query processor

  3. data model

  4. only 2 and 3

  5. none of these

Show answer
Correct Option: A
Explanation:

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?

  1. Weak entity sets

  2. Total participation of an entity in a relationship set

  3. Relationship set

  4. Link attribute to entity set and entity set to the relationship set

  5. None of these

Show answer
Correct Option: A
Explanation:

They are represented by the double rectangles.

Which of the following is used to write database schema?

  1. XML

  2. HTML

  3. DDL

  4. DML

  5. None of these

Show answer
Correct Option: C
Explanation:

Data definition language (DDL) is used to define the database structure.

Find the odd one out.

  1. Selection

  2. Rename

  3. Projection

  4. Union

  5. None of these

Show answer
Correct Option: D
Explanation:

Union is a binary operator.

DDL and DML statements are compiled and executed by

  1. query processor

  2. storage manager

  3. data model

  4. only 1 and 3

  5. none of these

Show answer
Correct Option: A
Explanation:

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?

  1. CREATE

  2. COMMIT

  3. ALTER

  4. SELECT

  5. None of these

Show answer
Correct Option: E
Explanation:

Neither one of the above four options is correct. The example of a DML command is INSERT.

What is/are instance(s) of database?

  1. The relationship among data

  2. The collection of conceptual tools for describing data

  3. The collection of information stored at a particular moment

  4. Only 1 and 3

  5. None of these

Show answer
Correct Option: C
Explanation:

This is the definition of instance of database.

Which type(s) of attribute(s) is/are phone number?

  1. Composite attribute

  2. Single-valued attribute

  3. Multi-valued attribute

  4. Derived attribute

  5. Only 2 and 4

Show answer
Correct Option: C
Explanation:

This attribute is like phone number, car number, etc. 

Which type of command is DROP?

  1. Data Definition Language (DDL) command

  2. Transaction Control Language (TCL) command

  3. Data Query Language (DQL) command

  4. Data Manupulation Language (DML) command

  5. None of these

Show answer
Correct Option: A
Explanation:

It is a Data Definition Language (DDL) command.

What is the function of the SAVEPOINT command?

  1. To save information in a database after updation

  2. To identify a point in a transaction to which you can later roll back

  3. To save a table

  4. To save after RENAME a table

  5. None of these

Show answer
Correct Option: B
Explanation:

This is the function of a SAVEPOINT command.

Which of the following is/are example(s) of Transaction Control Language (TCL) command?

  1. TRANCATE

  2. COMMIT

  3. ROLLBACK

  4. GRANT

  5. Only 2 and 3

Show answer
Correct Option: E
Explanation:

Only 2 and 3 are TCL commands.

What function(s) is/are done by the Transaction Control Language (TCL) command?

  1. Used for managing data within schema objects

  2. Used to manage the changes made by DML statements and allows statements to be grouped together into logical transactions.

  3. Statements are used to define the database structure or schema.

  4. Only 1 and 2

  5. None of these

Show answer
Correct Option: B
Explanation:

It is done by Transaction Control Language (TCL) commands.

Which type of command is GRANT?

  1. Transaction Control Language (TCL) command

  2. Data Query Language (DQL) command

  3. Data Control language (DCL) command

  4. Data Definition Language (DDL) command

  5. None of these

Show answer
Correct Option: C
Explanation:

It is a Data Control Language (DCL) command.

- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions