Tag: databases

Questions Related to databases

How do you find the total number of rows in a table ?
technology databases

  1. SELECT COUNT *

  2. SELECT COUNT(*)

  3. SELECT COUNT[*]

  4. SELECT COUNT(ALL)

Show answer
Correct Option: B

Which of the following isolation levels will lock all rows scanned to build a result data set?
technology databases

  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read

Show answer
Correct Option: D

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

  1. @abcd.sql

  2. @abcd

  3. get abcd.sql /

  4. all the above

Show answer
Correct Option: D

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

  1. name

  2. null

  3. type

  4. null?

Show answer
Correct Option: B

How much data will be stored in oracle 9i Database..?
technology databases

  1. 512 peta bytes

  2. 1024 peta byes

  3. 512 nano bytes

  4. 1024 giga bytes

Show answer
Correct Option: A

1 peta byte =
technology databases

  1. 1*1024 pow 3 bytes

  2. 1*1024 pow 4 bytes

  3. 1*1024 pow 5 bytes

  4. 1*1024 pow 6 byes

Show answer
Correct Option: C

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

  1. parameter files

  2. control files

  3. redo logs

  4. data files

Show answer
Correct Option: B

Which one is the SQL*PLUS command...?
technology databases

  1. jump

  2. run

  3. walk

  4. sleep

Show answer
Correct Option: B

which one is the function in SQL...?
technology databases

  1. soundex

  2. lightex

  3. weightex

  4. lux

Show answer
Correct Option: A

The function which gives the storage of x in bytes..?(X may be the column)
technology databases

  1. usize(x)

  2. vsize(x)

  3. wsize(x)

  4. xsize(x)

Show answer
Correct Option: B