PCS Infotech Placement: Sample Questions 3 - 4 of 25

Get unlimited access to the best preparation resource for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 3

Statement True-False▾

Tablespace contains physical data.

Choices

Choice (4)

a.

True

b.

False

c.

All of the above

d.

Question does not provide sufficient data or is vague

Edit

Answer

a.

Explanation

  • Tablespace provides independence of logical data structures such as tables, views, and indexes from physical storage structures.
  • The files in a tablespace usually share common logical characteristic.
  • Tablespaces can be created, deleted, and merged.
  • Both are physical and logical structures are separate.
  • We can manage physical storage of data without affecting logical structure.
  • Data file is created by database and contains data structure like table and index.
  • Data written to files in oracle proprietary format cannot be read by other program.

Database Can Use Tablespace To

  • Control disk space allocation for database data.
  • Specific space for database user.
  • Control availability of data through individual tablespaces.
  • Perform partial database backup or recovery operations.
  • Allocate data storage across devices to improve performance.

Question 4

Statement True-False▾

Can a labelled “goto” statement goto the inner loop?

Choices

Choice (4)

a.

True

b.

False

c.

Question does not provide sufficient data or is vague

d.

All of the above

Edit

Answer

b.

Explanation

Understanding of GOTO Statements
  • The goto allows unconditional branching to another program section.
  • The form of the goto statements as follows:

    goto label;

  • Goto statement transfers control to a labelled block.

GOTO Label

  • Label is point after processing starts a GOTO is targeted to label.
  • Must follow the rules for identifiers.

Restriction on GOTO statement:

  • Cannot transfer control into IF statement, CASE statement, LOOP statement
  • Cannot transfer control from one IF statement clause to another.
  • Cannot transfer control into an exception handler.
  • Cannot transfer control out of subprogram.