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

Edit

Write in Short

Short Answer▾

What is the parameter substitution symbol used with INSERT INTO command?

Explanation

  • & parameter substitution symbol used with INSERT INTO.
  • INSERT INTO command is not used before a substitution variable.
  • It is used to add new records into a database table with values for all its column.
  • Can be combined with a SELECT to insert records.

Syntax of INSERT INTO command

INSERT INTO table_name (column_name)

VALUE (values)

Question 107

Edit

Describe in Detail

Essay▾

What is Transaction Manager?

Explanation

  • Part of an application that controls the coordination of transactions over one or more resources.
  • Maintains a log in storage on disk.
  • Records transaction starts, enlistments, and commits decisions in the log.
  • Reads log when it restarts to reconstruct the most recent state, using the log to make its state durable, when if the transaction manager fails,

Responsibility

  • Demarcation
    • Starting and finishing transactions by means of begin, commit and rollback methods.
  • Controlling the Transaction Context:
    • Transaction contexts contain all the information that helps a transaction manager to monitor a transaction.
    • Transaction managers are in charge of building transaction contexts and connecting them to the existing thread.
  • Coordinating the Transaction:
    • Transaction managers generally have the ability to harmonize a transaction over various resources. This feature demands the two-phase commit protocol.
  • Recovery From Failure:
    • Transaction managers are accountable to guarantee that the resources are not kept in an inconsistent state in case of a system or application failure.

Developed by: