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

Oracle

Question

MCQ▾

What are the different file extensions created by Oracle Reports?

Choices

Choice (4)

a.

. REP file & . RDF file

b.

. RDF file & . RPX file

c.

. RDX file & . RDF file

d.

All of the above

Answer

a.

Explanation

. REP File Type

  • Stores single executable report with no source code or comments in binary executable format.
  • Not modifiable and portable as binary files only if no PL/SQL code is present.
  • Report definitions can be stored as . rep files through any of bellowing methods:
    • Select FILE ADMINISTRATION COMPILE REPORT
    • Select FILE ADMINISTRATION CONVERT

. RDF File Type

  • Stores single report definition along with source code and comment in binary executable format.
  • Modified only in report builder and portable in its binary format.
  • Store. rdf files through any of following methods:
    • Select FILE SAVE
    • Select FILE SAVE AS
    • Select FILE ADMINISTRATION CONVERT

Question 103

Oracle

Question

MCQ▾

EMPNO ENAME SAL

A822 RAMASWAMY 3500

A812 NARAYAN 5000

A973 UMESH 2850

A500 BALAJI 5750

Use these data for the following Questions

Select SAL from EMP E1 where 3 > (Select count (⚹) from Emp E2 where E1. SAL > E2. SAL) will retrieve

Choices

Choice (4)

a.

5000,2850

b.

3500,5000, 2850

c.

2850,5750

d.

5000,5750

Answer

b.

Explanation

  • The two select statements work in nested way.
  • The outer one: “Select SAL from EMP E1” selects salary from table employee as E1
  • The iner one: “Select count (⚹) from Emp E2 where E1. SAL > E2. SAL” selects for each employee number of employees with lower salaries and counts them
  • The outer select returns those employees which have fewer than 3 employees with lower salaries

Developed by: