Ask
Login
TAGGED IN

Advanced Database Management Systems

Follow this tag to get notifications whenever a new post is added

ALL TAGS
3
votes
1
answer
25k
views
1
answer
What is JOIN? Explain different types of join with example
database management systems advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
6.8k
views
1
answer
Discuss Data Definition and Manipulation Commands in SQL.
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
4.4k
views
1
answer
Short notes on Data Control Commands in SQL
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
2
votes
1
answer
5.1k
views
1
answer
Write a note on views in SQL
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
2.1k
views
1
answer
What do you mean by serializability schedule? How would you test whether a given schedule S is conflict serializable?
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
6.7k
views
1
answer
Describe concurrency control based on timestamp ordering
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
3.5k
views
1
answer
Explain Time stamp based ordering
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
2.2k
views
1
answer
Compare the shadow paging recovery scheme with the log-based recovery schemes in terms of ease of implementation and overhead cost.
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
4
votes
1
answer
40k
views
1
answer
Describe the shadow paging recovery technique
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
1.5k
views
1
answer
Explain deadlock in brief
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
4.2k
views
1
answer
Explain deadlock handling
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
4.7k
views
1
answer
When a transaction is rolled back under timestamp ordering, it is assigned a new timestamp, Why can it not simply keep its old timestamp?
advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
1
vote
1
answer
20k
views
1
answer
Draw a query tree for the following Sql query
database management systems advanced database management systems updated 3.0 years ago by binitamayekar ★ 6.6k
0
votes
1
answer
12k
views
1
answer
What are the roles of analysis, Redo & Undo phases in ARIES? Explain with suitable e.g.
advanced database management systems updated 3.0 years ago by teamques10 ★ 68k
9
votes
1
answer
57k
views
1
answer
Define transaction? Explain transaction state diagram and properties of transaction
advanced database management systems updated 3.0 years ago by pedsangini276 • 4.8k
0
votes
1
answer
2.2k
views
1
answer
Describe ACID Properties or List ACID properties. Explain usefulness of each
advanced database management systems updated 3.0 years ago by pedsangini276 • 4.8k
0
votes
1
answer
4.2k
views
1
answer
Describe conflict serializability and view serializability with examples
advanced database management systems updated 3.0 years ago by pedsangini276 • 4.8k
0
votes
1
answer
4.0k
views
1
answer
Log Based Recovery
advanced database management systems updated 3.0 years ago by pedsangini276 • 4.8k
0
votes
1
answer
3.8k
views
1
answer
Describe the three phases of the ARIES recovery method.
advanced database management systems updated 3.0 years ago by pedsangini276 • 4.8k
3
votes
1
answer
8.5k
views
1
answer
Write short note on checkpoint
advanced database management systems updated 3.0 years ago by pedsangini276 • 4.8k
<prev • 70 results • page 3 of 3 • next >