Tag: databases

Questions Related to databases

What is the maximum number of areas you can open with a single OPEN statement?
technology databases

  1. 25

  2. 35

  3. 47

  4. 57

Show answer
Correct Option: C

Fetch = ?

technology databases

  1. get+find

  2. find

  3. find+get

  4. none of the above

Show answer
Correct Option: C

What type of Database is IDMS?

technology databases

  1. Relational

  2. Hierarchial

  3. Network

  4. None of the above

Show answer
Correct Option: C

There is a chance for Currency loss while doing AREA Sweep
technology databases

  1. True

  2. False

Show answer
Correct Option: A

What does 1205 Error code represnts in IDMS?
technology databases

  1. Error while disconnecting a record from its set

  2. Error while storing duplicates

  3. Error while connecting a record to a set

  4. Error while erasing a record

Show answer
Correct Option: B

select substr('DECCANPARK',3,-1) FROM DUAL would results in?
technology databases

  1. ARK

  2. CED

  3. DEC

  4. NULL

Show answer
Correct Option: D

select trunc(10,-1) from dual would results in?
technology databases

  1. 10

  2. 9

  3. ERROR

  4. 1

Show answer
Correct Option: A

let sysdate='19-SEP-2009' select round(sysdate,'YEAR'),round(sysdate,'MONTH') from dual would results in?
technology databases

  1. 09,SEP

  2. 1/1/2010,1/10/2009

  3. 1/1/2009,1/1/2009

  4. 2009,SEPTEMBER

Show answer
Correct Option: B

which of the following are true about natural join?
technology databases

  1. No advantage

  2. eliminates aliases

  3. Natural join doesnot exist in oracle

  4. eliminates join comparision

Show answer
Correct Option: B,D

State true or false All the columns in the column clause of select statment that are not in a group function must be listed in the group by clause.However,a column listed in group by clause needn't appear in column clause

technology databases

  1. True

  2. False

Show answer
Correct Option: A