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

Oracle

Question

MCQ▾

Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5?

Choices

Choice (4)

a.

Yes

b.

No

c.

All of the above

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

  • Yes, MULTIPLE DOCUMENT INTERFACE (MDI) can be used in Form 4.5.
  • MDI applications enable display of multiple documents at the same time with each document display its own window.
  • A window menu item switches between window and documents.
  • Child windows are contained in parent window, which provides a workspace for all the child windows in the application.
  • Ex. Microsoft Window allows display of multiple-document of different types.

Question 18

Oracle

Question

MCQ▾

The Data Manipulation Language statements are

Choices

Choice (4)

a.

SELECT

b.

INSERT

c.

UPDATE

d.

All a., b. and c. are correct

Answer

d.

Explanation

Understanding of DML
  • Access and manipulate data in existing table.
  • Do not implicitly commit the current transaction.
  • The data manipulation language statement are:

    CALL

    DELETE

    EXPLAIN PLAN

    INSERT

    LOCK TABLE

    MERGE

    SELECT

    UPDATE

  • SELECT statement is a limited from of DML as it can only access data in the database. Cannot manipulate data in the database- can operate on the accessed data before returning the results of the query.
  • The CALL and EXPLAIN PLAN statements are supported in PL/SQL only when executed dynamically.

Developed by: