Database-MySQL [3i Infotech Placement]: Sample Questions 5 - 7 of 162

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

Question 5

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 6

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 7

Edit

Describe in Detail

Essay▾

Does PL/SQL support “overloading” . Explain.

Explanation

  • Yes, PL? SQL supports “overloading” - define more than one function with the same name.
  • Programs different in other ways so that at runtime the PL/SQL engine can figure out which of the programs to execute.
  • PL/SQL does not look only at the referenced name, to resolve a procedure or function call- considerers count and data types of formal parameters.
  • Below some circumstances it is cause the PL/SQL
    • Apply the same action to different kinds or combinations of data.
    • Allow developers to use a program in the most natural and intuitive fashion.
    • Make it easy for developers to specify, unambiguously and simply, the kind of action desired.

Developed by: