3i Infotech Placement: Sample Questions 35 - 36 of 1245

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

Question 35

Question

MCQ▾

Conditional results after execution of an instruction in a microprocessor are stored in

Choices

Choice (4)

a.

register

b.

accumulator

c.

flag register part of PSW (Program Status Word)

d.

flag register

Answer

c.

Explanation

Processor Status Word
  • Conditional results after execution of an instruction in a microprocessor are stored in flag register part of PSW (Program Status Word) .
  • A status register, flag register or condition code register is a collection of status flag bits for a processor.
  • A status register is a hardware register containing information about the state of the processor.
  • The status register thus lets an instruction take action contingent on the outcome of a previous instruction.

Question 36

Question

MCQ▾

ENQUEUE_RESOURCES parameter information is derived from

Choices

Choice (4)

a.

DB_BLOCK_BUFFERS

b.

LOG BUFFER

c.

PROCESS or DDL_LOCKS & DML_LOCKS

d.

DB_BLOCK_SIZE

Answer

c.

Explanation

Define Differents Types of Locks
  • ENQUEUE_RESOURCES parameter information is derived from PROCESS or DDL_LOCKS & DML_LOCKS.
  • ENQUEUE_RESOURCES sets the max resources that can be concurrently locked by the lock manager.
  • DDL_LOCK

  • DDL_LOCK protects the definition of a schema object while the object is referenced in DDL operation.

    DDL_LOCK prevents other DDL operations from referencing or altering the same object.

  • DDL lock requested on an object that already has a DDL lock on it causes the lock to wait.

Three types of DDL locks:

  • Exclusive DDL lock
    • CREATE CLUSTER, DROP/ALTER TABLE, CREATE/ALTER/DROP INDEX, and CREATE/ALTER TABLESPACE require an exclusive lock on the object they are working on.
  • Shared DDL Lock
    • Required on the objects they refer to: audit, noaudit, comment, create.
    • Also create table when the cluster clause isn՚t specified.
  • Breakable Parse Locks
    • SQL statement or PL/SQL object in the library cache holds a breakable parse lock for each object it references, until the statement is aged out of the shared pool.
Three Types of DDL Locks
  • DML_LOCK

  • Obtained on a table that is undergoing a DML operation (insert, update, delete) .
  • DML_LOCK specifies the maximum number of DML locks for each table modified transaction.
  • Example, three users modifying data in one table would require lock on three entries. If three users are modifying data in two tables, then lock on six entries would be required.

Developed by: