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

Edit

Describe in Detail

Essay▾

What is RDBMS KERNEL?

Explanation

  • A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database.
  • Use of the Structured Query Language (SQL) to access the database, SQL was invented after the development of the relational model and is not necessary for its use.
  • The software and the data dictionary is the two important pieces of RDBMS architecture are the kernel, which consists of the system-level data structures to manage the database used by the kernel.
  • An RDBMS maintains its own list of authorized users and their associated privileges;
    • manages memory caches and paging
    • controls locking for concurrent resource usage
    • dispatches and schedules user requests
  • Sub-systems of a RDBMS:
    • I/O
    • Security
    • Language ProcessingProcess Control
    • Storage Management
    • Logging and Recovery
    • Distribution Control
    • Transaction Control
    • Memory Management
    • Lock Management

Question 70

Edit

Write in Short

Short Answer▾

What are stand-alone procedures?

Explanation

  • A procedure which is not enclosed in a package is called Stand Alone Procedure.
  • A standalone procedure is a procedure (a subprogram that performs a specific action) that is stored in the database.
  • Ex- one written in a SQL ⚹ Forms application.
  • Limitation: Not available for reference from other Oracle tools.
  • Limitation: Are compiled at run time, which slows execution.

Developed by: