0

databases Online Quiz - 221

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

What authority is required to create a table?

  1. ADMIN Privileges

  2. CREATETAB Privileges

  3. No Privileges

  4. USERTAB Privileges


Correct Option: B
  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read


Correct Option: D
  1. The cursor is moved to another row

  2. The row the cursor is on is deleted by the application

  3. The row the cursor is on is deleted by another application

  4. The row the cursor is on needs to be updated by another application


Correct Option: B
  1. It has to be in a CURSOR

  2. cannot be used in Embedded SQL

  3. No restrictions

  4. None of the above


Correct Option: A
  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read


Correct Option: D

A declared temporary table is used for which of the following purposes?

  1. Backup purposes

  2. Storing intermediate results

  3. Staging area for load operations

  4. Sharing result data sets between applications


Correct Option: B
  1. SELECT COUNT *

  2. SELECT COUNT(*)

  3. SELECT COUNT[*]

  4. SELECT COUNT(ALL)


Correct Option: B
  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read


Correct Option: D

To run abcd.sql Script, what is the syntax....?

  1. @abcd.sql

  2. @abcd

  3. get abcd.sql /

  4. all the above


Correct Option: D

which one is not the output of Desc ...?

  1. name

  2. null

  3. type

  4. null?


Correct Option: B
  1. 512 peta bytes

  2. 1024 peta byes

  3. 512 nano bytes

  4. 1024 giga bytes


Correct Option: A
  1. 1*1024 pow 3 bytes

  2. 1*1024 pow 4 bytes

  3. 1*1024 pow 5 bytes

  4. 1*1024 pow 6 byes


Correct Option: C

Which one of these files stores the location of disk components....?

  1. parameter files

  2. control files

  3. redo logs

  4. data files


Correct Option: B

which one is the function in SQL...?

  1. soundex

  2. lightex

  3. weightex

  4. lux


Correct Option: A

which one is the Oracle function in SQL...?

  1. floor

  2. window

  3. door

  4. ground


Correct Option: A

which keyword can be placed in trim function...?

  1. tailoring

  2. travelling

  3. trailing

  4. trucking


Correct Option: C
- Hide questions