Tag: databases

Questions Related to databases

Identify the physical component of the database, which stores the information about the database layout

technology databases

  1. Datafile

  2. Controlfile

  3. Redolog Group

  4. Archivelogs

  5. Password File

Show answer
Correct Option: B

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

  1. Datafile

  2. Database

  3. Controlfile

  4. Table

  5. Schema

  6. Redolog Group

Show answer
Correct Option: B,D,E

which of the following represent the "not equal to" condition?
technology databases

  1. !=

  2. ^=

  3. <>

  4. !==

Show answer
Correct Option: A,B,C

which of the following is not a comparison condition?
technology databases

  1. NOT LIKE

  2. IN (set)

  3. ==

  4. ^=

Show answer
Correct Option: C

which of the following are wildcard characters?
technology databases

  1. %

  2. $

  3. _

  4. *

Show answer
Correct Option: A,C

RDBMS stands for
technology databases

  1. Relational Database Management System

  2. Rational Database Management System

  3. Real Database Management System

  4. Rapid Database Management System

Show answer
Correct Option: A

Identify SQL statement which is used for Data Retrieval
technology databases

  1. Insert

  2. Create

  3. Delete

  4. Select

  5. Grant

  6. Commit

Show answer
Correct Option: D

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

  1. Insert

  2. Create

  3. Delete

  4. Select

  5. Merge

  6. Update

Show answer
Correct Option: A,C,E,F

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

  1. Alter

  2. Rollback

  3. Select

  4. Commit

  5. Rename

  6. Savepoint

Show answer
Correct Option: B,D,F

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

  1. Alter

  2. Grant

  3. Select

  4. Rename

  5. Revoke

  6. Update

Show answer
Correct Option: B,E