Final Exam 3230 DBMS Questions With Correct
Answers
When |you |read |from |and/or |write |to |a |database, |you |have |created |a(n) |
____________________. |- |CORRECT |ANSWER✔✔-Transaction
Most |real-world |database |transactions |are |formed |by |two |or |more |____________________ |
requests. |- |CORRECT |ANSWER✔✔-database
A |transaction |is |a |____________________ |unit |of |work |that |must |be |either |entirely |
completed |or |aborted. |- |CORRECT |ANSWER✔✔-logical
To |ensure |consistency |of |the |database, |every |transaction |must |begin |with |the |database |in |a |
known |____________________ |state. |- |CORRECT |ANSWER✔✔-consistent
Although |the |DBMS |is |designed |to |recover |a |database |to |a |previous |consistent |state |(when |an
|interruption |prevents |the |completion |of |a |required |set |of |transactions), |the |transactions |
themselves |are |defined |by |the |end |user |or |programmer |and |must |be |____________________ |
correct. |- |CORRECT |ANSWER✔✔-semantically
Incomplete |or |improper |transactions |can |have |a |devastating |effect |on |database |
__________________ |- |CORRECT |ANSWER✔✔-integrity
____________________ |databases, |whether |mainframe |or |LAN-based, |are |typically |subject |to |
multiple |concurrent |transactions. |- |CORRECT |ANSWER✔✔-Multiuser
, The |ANSI |has |defined |standards |that |govern |SQL |database |transactions. |Transaction |support |is
|provided |by |two |SQL |statements: |____________________ |and |ROLLBACK. |- |CORRECT |
ANSWER✔✔-COMMIT
If |a(n) |____________________ |is |issued |before |the |termination |of |a |transaction, |the |DBMS |
will |restore |the |database |only |for |that |particular |transaction, |rather |than |for |all |transactions, |
in |order |to |maintain |the |durability |of |the |previous |transactions. |- |CORRECT |ANSWER✔✔-
ROLLBACK
____________________ |control |is |important |because |the |simultaneous |execution |of |
transactions |over |a |shared |database |can |create |several |data |integrity |and |consistency |
problems. |- |CORRECT |ANSWER✔✔-Concurrency
The |____________________ |establishes |the |order |in |which |the |operations |within |concurrent |
transactions |are |executed. |- |CORRECT |ANSWER✔✔-scheduler
A |transaction |____________________ |is |released |when |a |transaction |is |completed, |so |
another |transaction |can |lock |the |data |item |for |its |exclusive |use. |- |CORRECT |ANSWER✔✔-lock
Most |multiuser |______________________________ |automatically |initiate |and |enforce |locking |
procedures, |where |all |locking |information |is |managed |by |the |lock |manager. |- |CORRECT |
ANSWER✔✔-Database |Management |Systems
Lock |____________________ |indicates |the |level |of |lock |use. |- |CORRECT |ANSWER✔✔-
granularity
____________________-level |locks |are |less |restrictive |than |database-level |locks, |but |they |
create |traffic |jams |when |many |transactions |are |waiting |to |access |the |same |table. |- |CORRECT |
ANSWER✔✔-table
Answers
When |you |read |from |and/or |write |to |a |database, |you |have |created |a(n) |
____________________. |- |CORRECT |ANSWER✔✔-Transaction
Most |real-world |database |transactions |are |formed |by |two |or |more |____________________ |
requests. |- |CORRECT |ANSWER✔✔-database
A |transaction |is |a |____________________ |unit |of |work |that |must |be |either |entirely |
completed |or |aborted. |- |CORRECT |ANSWER✔✔-logical
To |ensure |consistency |of |the |database, |every |transaction |must |begin |with |the |database |in |a |
known |____________________ |state. |- |CORRECT |ANSWER✔✔-consistent
Although |the |DBMS |is |designed |to |recover |a |database |to |a |previous |consistent |state |(when |an
|interruption |prevents |the |completion |of |a |required |set |of |transactions), |the |transactions |
themselves |are |defined |by |the |end |user |or |programmer |and |must |be |____________________ |
correct. |- |CORRECT |ANSWER✔✔-semantically
Incomplete |or |improper |transactions |can |have |a |devastating |effect |on |database |
__________________ |- |CORRECT |ANSWER✔✔-integrity
____________________ |databases, |whether |mainframe |or |LAN-based, |are |typically |subject |to |
multiple |concurrent |transactions. |- |CORRECT |ANSWER✔✔-Multiuser
, The |ANSI |has |defined |standards |that |govern |SQL |database |transactions. |Transaction |support |is
|provided |by |two |SQL |statements: |____________________ |and |ROLLBACK. |- |CORRECT |
ANSWER✔✔-COMMIT
If |a(n) |____________________ |is |issued |before |the |termination |of |a |transaction, |the |DBMS |
will |restore |the |database |only |for |that |particular |transaction, |rather |than |for |all |transactions, |
in |order |to |maintain |the |durability |of |the |previous |transactions. |- |CORRECT |ANSWER✔✔-
ROLLBACK
____________________ |control |is |important |because |the |simultaneous |execution |of |
transactions |over |a |shared |database |can |create |several |data |integrity |and |consistency |
problems. |- |CORRECT |ANSWER✔✔-Concurrency
The |____________________ |establishes |the |order |in |which |the |operations |within |concurrent |
transactions |are |executed. |- |CORRECT |ANSWER✔✔-scheduler
A |transaction |____________________ |is |released |when |a |transaction |is |completed, |so |
another |transaction |can |lock |the |data |item |for |its |exclusive |use. |- |CORRECT |ANSWER✔✔-lock
Most |multiuser |______________________________ |automatically |initiate |and |enforce |locking |
procedures, |where |all |locking |information |is |managed |by |the |lock |manager. |- |CORRECT |
ANSWER✔✔-Database |Management |Systems
Lock |____________________ |indicates |the |level |of |lock |use. |- |CORRECT |ANSWER✔✔-
granularity
____________________-level |locks |are |less |restrictive |than |database-level |locks, |but |they |
create |traffic |jams |when |many |transactions |are |waiting |to |access |the |same |table. |- |CORRECT |
ANSWER✔✔-table
