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?


  2. IN (set)

  3. ==

  4. ^=

Correct Option: C

which of the following are wildcard characters?

  1. %

  2. $

  3. _

  4. *

Correct Option: A,C
  1. Relational Database Management System

  2. Rational Database Management System

  3. Real Database Management System

  4. Rapid Database Management System

Correct Option: A
  1. Insert

  2. Create

  3. Delete

  4. Select

  5. Grant

  6. Commit

Correct Option: D

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

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
  1. Structured Query Language

  2. Stable Query Language

  3. Synchronous Query Language

  4. System Query Language

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. /


  4. *

Correct Option: C

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

  1. True

  2. False

Correct Option: B

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