0

databases Online Quiz - 12

Description: databases Online Quiz - 12
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Identify the logical components of the database. Choose all that apply.

  1. Datafile

  2. Database

  3. Controlfile

  4. Table

  5. Schema

  6. Redolog Group


Correct Option: B,D,E

which of the following is not a comparison condition?

  1. NOT LIKE

  2. IN (set)

  3. ==

  4. ^=


Correct Option: C

which of the following are wildcard characters?

  1. %

  2. $

  3. _

  4. *


Correct Option: A,C

RDBMS stands for

  1. Relational Database Management System

  2. Rational Database Management System

  3. Real Database Management System

  4. Rapid Database Management System


Correct Option: A

Identify SQL statement which is used for Data Retrieval

  1. Insert

  2. Create

  3. Delete

  4. Select

  5. Grant

  6. Commit


Correct Option: D

Identify SQL statement which is used for Data Manipulation. Choose all that apply.

  1. Insert

  2. Create

  3. Delete

  4. Select

  5. Merge

  6. Update


Correct Option: A,C,E,F

Identify SQL statement which is used as Transaction Control Language command. Choose all that apply.

  1. Alter

  2. Rollback

  3. Select

  4. Commit

  5. Rename

  6. Savepoint


Correct Option: B,D,F

Identify SQL statement which is used as Data Control Language command. Choose all that apply.

  1. Alter

  2. Grant

  3. Select

  4. Rename

  5. Revoke

  6. Update


Correct Option: B,E

ERD stands for

  1. Enterprise Relationship Diagram

  2. Entity Relationship Diagram

  3. Extra Relationship Diagram

  4. Entry Relationship Diagram


Correct Option: B

What is true about RDBMS? Choose all that apply

  1. A system consisting of tables and relation between the tables

  2. Writes efficient queries itself without user intervention to retrieve and manipulate the data stored

  3. Handles data retrieval and manipulation using a functional programming language called SQL (Structured Query Language)

  4. A system consisting of memory structures and background process

  5. Translates a SQL query into a series of operations that retrieve the actual data from the database


Correct Option: A,C,E

SQL stands for

  1. Structured Query Language

  2. Stable Query Language

  3. Synchronous Query Language

  4. System Query Language


Correct Option: A

As a part of Entity Relationship Modeling conventions, an Entity is represented by a SOFT BOX.

  1. True

  2. False


Correct Option: A

which is an escape identifier i.e, used to avoid the meaning of wildcard characters, and hence interpret underscore and percentage literally

  1. \

  2. /

  3. ESCAPE

  4. *


Correct Option: C

In RDBMS, one can NOT have two tables with the same column name

  1. True

  2. False


Correct Option: B

In RDBMS, a TABLE is two dimensional object

  1. True

  2. False


Correct Option: A

DATABASE is a PHYSICAL object

  1. True

  2. False


Correct Option: B

Order by – clause comes last in select statement

  1. True

  2. False


Correct Option: A

desc - is the default option for sorting rows

  1. True

  2. False


Correct Option: B

Null vales are displayed last in case of ascending and first in case of desc sequences

  1. True

  2. False


Correct Option: A
- Hide questions