Database-MySQL [3i Infotech Placement]: Sample Questions 75 - 76 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 75

Edit

Describe in Detail

Essay▾

What command is used to get back the privileges offered by the GRANT command?

Explanation

Understanding of REVOKE Command
  • REVOKE command is used to get back the privileges offered by the GRANT command.
  • It takes back permission from user.
  • Removes user access rights or privileges to the database objects.
  • We can revoke any combination of SELECT, INSERT, UPDATE, DELETE, REFERENCEs, ALTER, or ALL.

SQL REVOKE Command:

REVOKE privilege_name

ON object_name

FROM {user_name|PUBLIC|role_name}

  • privilege_name:
    • Access right or privilege granted to the user.
  • object_name:
    • The name of a database object like TABLE, VIEW, STORED PROC and SEQUENCE.
  • user_name:
    • The name of the user which access right is being granted.
  • role_name:
    • A set of privileges grouped together.

Question 76

Question

MCQ▾

Oracle precompile translates the EMBEDDED SQL statements into

Choices

Choice (4)

a.

Oracle LIBRARY

b.

Oracle REPORTS

c.

Oracle FORMS

d.

None of the above

Answer

d.

Explanation

Understanding of Embedded SQL
  • The engine translates the embedded SQL statements into standard oracle runtime library call.
  • Generated modified source program can compile, link, and execute in the usual way.
  • Client-server program written using Precompiler.

Ex.

  • The Pro ⚹ C Precompiler used for C
  • Pro ⚹ Cobol used for Cobol, SQLJ for Java etc.
  • Programming tools enable SQL statements in high-level programs.
  • Client-server program written using Precompiler.

    Benefit of Precompiler

  • Increases productivity.
  • Creates performant and customized application.
  • Allows monitoring of resource use, SQL statement execution, and various run-time indicators.
  • Provides compile time type checking of object types and collections, and automatic type conversion from database types to C data types.

Developed by: