Tag: databases

Questions Related to databases

NUMBER OF PCBS ALLOWED IN A PSB?

technology databases

  1. 15

  2. 255

  3. 1

  4. NO LIMITATIONS

Show answer
Correct Option: D

MAXIMUM NUMBER OF FIELDS ALLOWED PER SEGMENT?
technology databases

  1. 15

  2. 255

  3. 1000

  4. 1

Show answer
Correct Option: B

maximum number of levels allowed in IMS DB?

technology databases

  1. 1

  2. 15

  3. 255

  4. 1000

Show answer
Correct Option: B

Can we use PROCOPT on PCB and Segment field (SENSEG)?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Each PSB consists of how many control blocks?

technology databases

  1. 15

  2. 1

  3. 1 OR MORE

  4. 255

Show answer
Correct Option: C

wHAT defines the types of access to the database?
technology databases

  1. PCB

  2. SENSEG

  3. SENFLD

  4. PROCOPT

Show answer
Correct Option: D

ALL OCCURENCES OF A SEGMENT TYPE UNDER A PARENT IS CALLED AS

technology databases

  1. CHILD

  2. DEPENDENT

  3. TWIN

  4. SIBLINGS

Show answer
Correct Option: C

Emp table has 10 rows. How many rows will be fetched against the following query? Select 10 from emp where rownum>=2
technology databases

  1. 2

  2. 8

  3. 10

  4. None of the above

Show answer
Correct Option: D

Round(159.63,-3) and Trunc(159.63,-3) will have following Outputs respectively:
technology databases

  1. 200 and 100

  2. 100 and 100

  3. 160 and 150

  4. none of the above

Show answer
Correct Option: D

What will be Output of the following query? select length(to_char('9999','999999.99')) from dual
technology databases

  1. 9

  2. 10

  3. 4

  4. 8

Show answer
Correct Option: B