Database-Oracle [3i Infotech Placement]: Sample Questions 6 - 7 of 132

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 6

Oracle
Edit

Statement

True-False▾

All data files related to a Table space are removed when the Table space is dropped

Answer

FALSE

Explanation

Structure of Two Tablespace
  • A table space is a logical group of data files in a database.
  • Indicate the database storage location, not the logical database structure or schema
  • Using table space admin can control the disk layout of an installation.
  • DB contains at least one table space and usually two or more.
  • Database program automatically create a table space- SYSTEM.
  • A table space is made one or more data files.

Basically 4 Types of Table Spaces

  • Permanent:
    • Uses data files and normally contains the system and user data.
  • Temporary:
    • Temporary files are created temporary table space.
  • Undo:
    • It is permanent types of table space that are used to store undo data.
  • Read only:
    • It is a permanent table space it can only read, no write can take place, but table space can made read or write.
4 Types of Table Spaces

Question 7

Oracle

Question

MCQ▾

Is it possible to disable the parameter form while running the report?

Choices

Choice (4)

a.

No

b.

Yes

c.

None of the above

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

It is possible to:

  • Pass user defined values to reports by using parameter forms.
  • Not display the parameter form while running the reports.

    Below are steps to display the parameters

  • Open report in report designer.
  • Select the report
  • Select the Tools Parameter from Builder from the reports menu.
  • Select the user parameters in the parameter form needed to be enter by the user.
  • Press ok button- parameter form appears with the user parameters.
  • Change the labels on the parameter form if required.
  • Compile the report.
  • Run the report.

Developed by: