Ask
Login
TAGGED IN

Advanced Database Management Systems

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

ALL TAGS
1
vote
1
answer
18k
views
1
answer
Explain with suitable e.g. object identity, object structure & type constructors in OODBs.
advanced database management systems updated 18 months ago by sagarkolekar ★ 11k
1
vote
1
answer
5.2k
views
1
answer
Explain ETL phases in creating a data warehouse.
advanced database management systems updated 2.0 years ago by sagarkolekar ★ 11k
1
vote
1
answer
2.2k
views
1
answer
Compare the shadow paging recovery scheme with the log-based recovery schemed in terms of ease of implementation and overhead cost.
advanced database management systems updated 2.1 years ago by pedsangini276 • 4.7k
0
votes
1
answer
815
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 2.1 years ago by pedsangini276 • 4.7k
0
votes
1
answer
3.0k
views
1
answer
List ACID properties. Explain usefulness of each.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
1.4k
views
1
answer
List ACID properties. Explain usefulness of each.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
1.3k
views
1
answer
Explain Time stamp based ordering
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
1.6k
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 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
1.1k
views
1
answer
Explain Transaction, Lock point
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
1.7k
views
1
answer
Explain the deadlock
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
3.4k
views
1
answer
What is referential integrity? Explain with a suitable example.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
2.2k
views
1
answer
Explain the Triggers in SQL with two examples
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
1
vote
1
answer
11k
views
1
answer
Design a schema in SQL for a Library System. Show one example each for PRIMARY KEY and FOREIGN KEY constraint.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
1.9k
views
1
answer
Explain in short: dynamic SQL.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
1
vote
1
answer
12k
views
1
answer
What are the different characteristics of a Data Warehouse?
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
7
votes
1
answer
19k
views
1
answer
With the help of a diagram explain the architecture of a Data Warehouse.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
2
votes
1
answer
10.0k
views
1
answer
What is the role of meta data in a data warehouse?
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
5.4k
views
1
answer
Explain Snowflake Schema.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
1
vote
1
answer
9.3k
views
1
answer
Explain in detail the information delivery component of data warehouse architecture
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
1
vote
1
answer
4.6k
views
1
answer
Explain the role of Meta data in data ware house.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
2.1k
views
1
answer
What are ACID properties of a transaction?
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
11k
views
1
answer
Advanced recovery techniques in a database
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
1
vote
1
answer
3.7k
views
1
answer
Justify Write-Ahead Logging (WAL) protocol for a recovery algorithm that requires both UNDO & REDO.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
2.8k
views
1
answer
Explain in short the concurrency control in distributed database.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
0
votes
1
answer
2.9k
views
1
answer
Explain in short the concurrency control in distributed database.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.7k
<prev • 70 results • page 1 of 3 • next >