How do you find the total number of rows in a table ?
SELECT COUNT *
SELECT COUNT(*)
SELECT COUNT[*]
SELECT COUNT(ALL)
Which of the following isolation levels will lock all rows scanned to build a result data set?
Uncommitted Read
Cursor Stability
Read Stability
Repeatable Read
To run abcd.sql Script, what is the syntax....?
@abcd.sql
@abcd
get abcd.sql /
all the above
which one is not the output of Desc ...?
name
null
type
null?
How much data will be stored in oracle 9i Database..?
512 peta bytes
1024 peta byes
512 nano bytes
1024 giga bytes
1 peta byte =
1*1024 pow 3 bytes
1*1024 pow 4 bytes
1*1024 pow 5 bytes
1*1024 pow 6 byes
Which one of these files stores the location of disk components....?
parameter files
control files
redo logs
data files
Which one is the SQL*PLUS command...?
jump
run
walk
sleep
which one is the function in SQL...?
soundex
lightex
weightex
lux
The function which gives the storage of x in bytes..?(X may be the column)
usize(x)
vsize(x)
wsize(x)
xsize(x)