Tag: databases

Questions Related to databases

SELECT Statement comes under?
technology databases

  1. DRL

  2. DDL

  3. DML

  4. DCL

Show answer
Correct Option: A

TRUNCATE IS USED TO?
technology databases

  1. DROP TABLE

  2. DELETE ALL ROWS

  3. DELETE ALL COLUMNS

  4. DELETE ORACLE

Show answer
Correct Option: B

SQL means
technology databases

  1. simple questionary language

  2. simple query language

  3. structured questionary language

  4. structured query language

Show answer
Correct Option: D

ORACLE IS?
technology databases

  1. object oriented programming language

  2. programming language

  3. scripting language

  4. database

Show answer
Correct Option: D

SQL statements are divided into?
technology databases

  1. 2

  2. 3

  3. 4

  4. 5

Show answer
Correct Option: D

ORACLE is used to store?
technology databases

  1. operational data

  2. historical data

  3. both

  4. none

Show answer
Correct Option: A

DDL Means data drive language?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

oracle is a programming language?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The life cycle of the explicit cursor goes through __________stages:

technology databases

  1. Declare, Open, Close

  2. Declare, Open, Fetch, Close

  3. None

  4. Declare, Open, Fetch, Close, Remove

Show answer
Correct Option: B

Which is a Valid table name:
technology databases

  1. emp@_tab

  2. emp#_tab

  3. $emp_tab

  4. Emp_delete

Show answer
Correct Option: B,D