Database-Oracle [3i Infotech Placement]: Sample Questions 40 - 41 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 40

Oracle

Question

MCQ▾

Can you copy the PROGRAM UNIT into an Object group?

Choices

Choice (4)

a.

No

b.

Yes

c.

None of the above

d.

All of the above

Answer

a.

Explanation

What Are Object Groups
  • No, we cannot copy the PROGRAM UNIT into an object group.
  • Program unit procedures can be used when form items are to be accessed
  • Better to use database procedures.
  • Execute one or more statements that can receive or return zero or more parameter lists.

Object group

  • Object group is container for a group of objects.
  • Defined when we want to package related objects to copy them in another module.
  • Once we create an object group, we add and remove objects to it.
  • Way to bundle objects into higher-level building block to be used in the other parts of an application or in subsequent development projects.
  • They copy an object creating a separate, unique version of that object in the target module.

Question 41

Oracle

Question

MCQ▾

Databases overall structure is maintained in a file called …

Choices

Choice (4)

a.

Redo log file

b.

Data file

c.

Control file

d.

Question does not provide sufficient data or is vague

Answer

c.

Explanation

Understanding of Control File
  • Databases overall structure is maintained in a file called control file.
  • Whenever the database is open, the control file must be available for writing database server.
  • The control file and the database are created at the same time.
  • When database is created at least one copy of the control file is created.
  • When database is open the control file must be available for writing the oracle database server.
  • Oracle database should have at least two control files, each stored on a different disk in case control files is lost or corrupted.

Developed by: