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

Oracle

Question

MCQ▾

EXP command is used

Choices

Choice (4)

a.

To import data from the exported dump file

b.

To create Rollback segments

c.

To take Backup of the Oracle Database

d.

All of the above

Answer

c.

Explanation

  • EXP command takes Backup of the Oracle Database.
  • Expert utility to write data from an oracle database into an operating system file in binary format.
  • Provides simple mechanism to transfer data between oracle databases.
  • Extracts objects, followed by their related objects.
  • Backup stored outside the database.
  • An Export file is an Oracle binary-format dump file typically located on disk or tape.
  • Dump files can only be read by oracle import utility.

EXP Includes below Options

  • Export full database
  • Export one or more user
  • Export one or more table
  • Export all object in tablespace
  • Logging the export messages
  • Controlling output dump filename
  • Export only selected rows from a table.
  • Controlling constraints, grants, triggers and indexes.

Question 125

Oracle

Question

MCQ▾

With which function of a summary item in the COMPUTE AT option required?

Choices

Choice (4)

a.

Sum

b.

Standard deviation

c.

Variance

d.

% of Total function

Answer

d.

Explanation

Define Item Based on Summary
  • With % of Total function of a summary item the COMPUTE AT option is required.
  • The value of a column summarizes data on a record-by-record basis on the default report column, in the preceding example, where % total displays default tabular column.
  • The result of a column calculated as one final result appears once at the bottom of the report.
  • Unlike other columns a summary column are not selected from the database.

Ex. To find total sportswear sales for all months for each district. Use the TOTAL function to calculate the total sales. To see a total for each district, specify “district” as the dimension of the results.

LIMIT product TO ‘sportswear’

REPORT W 15 HEADING ‘Total Sale’ TOTAL (sale district)

Developed by: