Database [3i Infotech Placement]: Sample Questions 11 - 13 of 294

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 11

Database
Edit

Write in Short

Short Answer▾

What is Record-at-a-time?

Explanation

  • The Low level or Procedural DML can specify and retrieve each record from a set of records.
  • This retrieve of a record is said to be Record-at-a-time.

Question 12

Database
Edit

Describe in Detail

Essay▾

Which system tables contain information on privileges granted and privileges obtained?

Explanation

  • USER_TAB_PRIVS_MADE and USER_TAB_PRIVS_RECD are system tables containing information on privileges granted and privileges obtained.
  • USER_TAB_PRIVS_MADE:
    • Describe the object for which the current user is the object owner.
    • Columns are the same as those in ALL_TAB_PRIVS_MADE.

      Select privileges granted to others on tables in our schema

      SQL > SELECT ⚹ FROM USER_TAB_PRIVS_MADE;

  • USER_TAB_PRIVS_RECD:
    • Describe object grants for which the current user is the grantee.
    • Its columns are the same as those in ALL_TAB_PRIVS_RECD.

Types of grants:

  • Object grants for which the current user is the grantee.
  • Object grants for enabled role or PUBLIC is the grantee.

Question 13

Database

Question

MCQ▾

Is it possible to disable the parameter form while running the report?

Choices

Choice (4)

a.

No

b.

Yes

c.

None of the above

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

It is possible to:

  • Pass user defined values to reports by using parameter forms.
  • Not display the parameter form while running the reports.

    Below are steps to display the parameters

  • Open report in report designer.
  • Select the report
  • Select the Tools Parameter from Builder from the reports menu.
  • Select the user parameters in the parameter form needed to be enter by the user.
  • Press ok button- parameter form appears with the user parameters.
  • Change the labels on the parameter form if required.
  • Compile the report.
  • Run the report.

Developed by: