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 |
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 |
Answer
b.Explanation
- 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.