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

Oracle

Question

MCQ▾

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger?

Choices

Choice (4)

a.

Yes

b.

No

c.

Question does not provide sufficient data or is vague

d.

All of the above

Answer

b.

Explanation

  • No, we cannot use GO_BLOCK package in a PRE_TEXT_ITEM trigger.
  • PRE_TEXT_ITEM is fired before entering into text item.
  • It is a navigational trigger
  • It perform an action before oracle form navigates to a text item from the record level.
  • GO_BLOCK or GO_ITEM would take us to another item and cannot be used here.

Question 131

Oracle

Question

MCQ▾

Size of Tablespace can be increased by …

Choices

Choice (4)

a.

Cannot be increased

b.

Adding one or more Datafiles

c.

Increasing the size of one of the Datafiles

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

  • Size of tablespace can be increased by adding one or more datafiles.
  • The max datafile size is 32gb for a tablespace defined with an 8K block size and 64gb for a tablespace.
  • It is defined with a 16K block size.
  • If our tablespace is larger than these max file sizes, we will need multiple datafiles.

Question 132

Oracle

Question

MCQ▾

In a CLIENT/SERVER environment, which of the following would not be done at the client?

Choices

Choice (4)

a.

Responding to user events.

b.

User interface part

c.

Data validation at entry line

d.

None of the above

Answer

d.

Explanation

Understanding of Client-Server Application
  • In the oracle database environment, the database application and the database are divided into client-server architecture.
    • The client runs the database application, for ex, SQL ⚹ Plus basic data entry program, that accesses database information and interacts with a user.
    • The server runs the oracle database software and shared data access to an oracle database
  • The client application and database can run on the same compute- however greater efficiency is achieved when the client portions and server portion are run by different computers.

Oracle client-server architecture provide following benefits:

  • Client applications are not responsible for performing data processing. The server present data using display capability of client.
  • The shared memory and multitasking facilities of its operating system.
  • Client application is not dependent on the physical location of data.
  • In networked environments, we can use client workstations to access the server effectively.

Developed by: