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

Oracle

Question

MCQ▾

What SYSTEM VARIABLE is used to refer DATABASE TIME?

Choices

Choice (4)

a.

$ $ dbtime $ $

b.

$ $ time $ $

c.

$ $ datetime $ $

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

  • $ $ dbtime $ $ SYSTEM VARIABLE is used to refer DATABASE TIME.
  • $ $ dbtime $ $ retrieves the current time for local datatbase.
  • Database time is the total time by the all user processes that are actively working in the database.
  • Variable $ $ dbtime $ $ can be used to design a default value for a text item using the initial value properties.
  • When connect to a remote database it may be in a different time.

Syntax of system variable:

$ $ dbtime $ $

Question 53

Oracle

Question

MCQ▾

If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated

Choices

Choice (4)

a.

For all the records retrieved

b.

Only for 10 records

c.

For all the records in the referenced table

d.

All of the above

Answer

b.

Explanation

  • If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated only for 10 records.
  • Summary report contains one column with value or values consisting of a summary of other data.
  • Column totalling sales, column that averages commissions, and column that shows maximum amounts are examples of summary columns.
  • Counts for regular or aggregate records beneath a given refinement are retrieved, using these properties:
    • As a property on each dimension value.
    • As a property on each dimension value- for aggregated records.
  • Value summary columns are calculated by summarizing data retrieved from another column.

Developed by: