Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    QB Sycs DBMS

    Uploaded by

    Shubham Singh
    PL/SQL blocks require BEGIN and END. The maximum number of ELSE clauses in a non-nested IF clause is any number. The %Type attribute is used to declare variables based on table column definitions. A row trigger fires each time a row is affected by a triggering statement. PL/SQL is a high-performance, transaction processing language.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    QB Sycs DBMS

    Uploaded by

    Shubham Singh
    14 views1 page
    PL/SQL blocks require BEGIN and END. The maximum number of ELSE clauses in a non-nested IF clause is any number. The %Type attribute is used to declare variables based on table column definitions. A row trigger fires each time a row is affected by a triggering statement. PL/SQL is a high-performance, transaction processing language.

    Original Title

    QB_SYCS_DBMS_

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    PL/SQL blocks require BEGIN and END. The maximum number of ELSE clauses in a non-nested IF clause is any number. The %Type attribute is used to declare variables based on table column definitions. A row trigger fires each time a row is affected by a triggering statement. PL/SQL is a high-performance, transaction processing language.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    14 views1 page

    QB Sycs DBMS

    Uploaded by

    Shubham Singh
    PL/SQL blocks require BEGIN and END. The maximum number of ELSE clauses in a non-nested IF clause is any number. The %Type attribute is used to declare variables based on table column definitions. A row trigger fires each time a row is affected by a triggering statement. PL/SQL is a high-performance, transaction processing language.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    Question Bank For DBMS

    Class - SYCS
    Sr.No. Question a b c d Correct_ans points
    Which sections are required in Generic PL/SQL
    1 BEGIN , END DECLARE, BEGIN DECLARE, EXCEPTION BEGIN, EXCEPTION BEGIN , END
    Block? 1
    What is the maximum number of ELSE clauses
    2 that can be included in an IF clause that is not Any Number
    nested? 0 1 2 1 1
    The __________ attribute is used to declare
    3 variables based on definitions of columns in a
    table. %Type %Float % Integer %Null %Type 1
    4 VARCHAR1 VARCHAR2 CHAR NUMBER VARCHAR1
    ____________ is not a valid PL/SQL data type. 1
    A ________ trigger is fired each time a row in
    5 Column After
    table is affected by triggering statement. Before Row Row 1

    6 PL/SQL is a completely portable,____________ Low-performance High-performance Null-performance Stable-performance High-performance


    transaction processing language. 1
    A __________ is a numeric value or a character
    7 Literal Unary Numeric Binary
    string used to represent itself. Literal 1

    8 The lock manager maintains a structure known as


    _____________ to detect deadlock cycles. precedence graph serializable graph serial graph waits-for-graph waits-for-graph 1
    The ________ operator is used to assign a value
    9 = := == :=@ :=
    to a variable. 1
    The effect of a Transaction should persists even if
    the system crashes before all its changes are
    10
    reflected on disk. This property refers to
    __________ . Atomicity Consistency Isolation Durability Durability 1
    To make the changes permanent a
    11 _____________ statement has to be given at the Commit Commit
    SQL prompt. Savepoint Rollback Savepoint or Rollback 1
    A transaction is ___________ if it is view
    12
    quivalent to some serial schedule. conflict serializable view serializable conflict equivalent serializable view serializable 1
    The ___________ contains one entry for each
    13
    dirty page in the buffer pool. Dirty Page Table Transaction table Checkpoint Table State Table Dirty Page Table 1
    A _____________ trigger is fired each time a row
    14 in the table is affected by the triggering
    statement. row before statement after row 1
    15
    ______________ is a run time error in program. Exception Error Compilation Excecution Exception 1
    A ___________ is a special kind of a store
    procedure that executes on the table with certain
    16
    actions like insertion, deletion or updation of
    data. procedure trigger function package trigger 1
    A strict 2PL protocol allows only
    17
    _________________ schedule. conflict serializable view serializable conflict equivalent view equivalent conflict serializable 1
    A _________ marks a sequence of statements
    18 Goto
    that has to be repeated. for loop loop while loop loop 1
    Which control structure executes a sequence of
    19 satements repeatedly as long as a condition holds Conditional Control Iterative Control Sequential Control Transaction Control Iterative Control
    true? 1

    20 The __________ is the LSN of the first log record


    that caused the page to become dirty. undoNextLSN prevLSN recLSN lastLSN recLSN 1
    The __________ is the LSN of the most recent log
    21
    record for the Transaction. undoNextLSN prevLSN recLSN lastLSN lastLSN 1

    22 Either all actions of a transaction are carried out


    or none are refers to the property __________. Atomicity Consistency Isolation Durability Atomicity 1
    The most recent portion of the log is called as
    23
    __________. log tail log part LSN prevLSN log tail 1
    The ________ statement changes the flow of
    24 GoTo For
    control within a PL/SQL block. Jump If-else GoTo 1
    25 PL/SQL is ______________ of SQL. Subset Union Set Superset Proc Set Superset 1

    You might also like