BSc CS Sem 3 BSc CS Semester 3 (2020 2021) 2021 DBMS Question Paper - Mumbai University | munotes
Loading PDF...
Older exam
2021 - IoT
Semester-end · BSc CS Semester 3 (2020 2021)
→
Newer exam
2021 - CoreJava
Semester-end · BSc CS Semester 3 (2020 2021)
→
Questions asked in this paper
What is the maximum number of ELSE clauses
2 that can be included in an IF clause that is not Any Number
The attribute is used to declare
table is affected by triggering statement. Before Row Row
PL/SQL is a completely portable, Low-performance High-performance Null-performance Stable-performance High-performance
string used to represent itself. Literal
The lock manager maintains a structure known as
to detect deadlock cycles. precedence graph serializable graph serial graph waits-for-graph waits-for-graph
The operator is used to assign a value
The effect of a Transaction should persists even if
reflected on disk. This property refers to
To make the changes permanent a
11 statement has to be given at the Commit Commit
quivalent to some serial schedule. conflict serializable view serializable conflict equivalent serializable view serializable
dirty page in the buffer pool. Dirty Page Table Transaction table Checkpoint Table State Table Dirty Page Table
A trigger is fired each time a row
14 in the table is affected by the triggering
is arun time errorin program. |Exception Error Compilation Excecution Exception
A is a special kind of a store
16 procedure that executes on the table with certain
actions like insertion, deletion or updation of
that has to be repeated. for loop while loop
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
20 The is the LSN of the first log record
22 Either all actions of a transaction are carried out
or none are refers to the property Consistency Isolation Durability Atomicity
control within a PL/SQL block. Jump If-else GoTo
2 that can be included in an IF clause that is not Any Number
The attribute is used to declare
table is affected by triggering statement. Before Row Row
PL/SQL is a completely portable, Low-performance High-performance Null-performance Stable-performance High-performance
string used to represent itself. Literal
The lock manager maintains a structure known as
to detect deadlock cycles. precedence graph serializable graph serial graph waits-for-graph waits-for-graph
The operator is used to assign a value
The effect of a Transaction should persists even if
reflected on disk. This property refers to
To make the changes permanent a
11 statement has to be given at the Commit Commit
quivalent to some serial schedule. conflict serializable view serializable conflict equivalent serializable view serializable
dirty page in the buffer pool. Dirty Page Table Transaction table Checkpoint Table State Table Dirty Page Table
A trigger is fired each time a row
14 in the table is affected by the triggering
is arun time errorin program. |Exception Error Compilation Excecution Exception
A is a special kind of a store
16 procedure that executes on the table with certain
actions like insertion, deletion or updation of
that has to be repeated. for loop while loop
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
20 The is the LSN of the first log record
22 Either all actions of a transaction are carried out
or none are refers to the property Consistency Isolation Durability Atomicity
control within a PL/SQL block. Jump If-else GoTo
Read from the scan above, so a character or two may differ. The scan is the original.
Something wrong on this page? Report it and we will check it against the scan.
Quick Help
No. The full paper opens straight away, with no login and nothing to pay.
Related Resources
Something wrong with this paper? Report it.
Connected Papers
BSc CS / Sem 3 · 72 papers
2017 - ATKT Combinatorics And Graph Theory
2017 - ATKT Database Management System
2017 - ATKT Operating System
2017 - ATKT Skill Enhancement Web Programming
2016 - ATKT COMPUTER III
2016 - ATKT COMPUTER II
2015 - ATKT Computer I
2014 - Comp I ADD
2014 - Comp II ADD 15 1
2014 - Comp III ADD
2014 - ATKT Comp III
2014 - ATKT Maths I
Questions? Email contact@munotes.in
Done!