Unit 1
What is DDL (Data Definition Language)?
What are the primary DDL commands and their functions?
What is DML (Data Manipulation Language)?
What are the key DML commands and their purposes?
What is DML (Data Manipulation Language)?
What are the primary DML commands and their functions?
What are the key DDL commands and their purposes?
Write the SQL commands for creating database, creating table with syntax and examples.
Write the SQL commands for inserting records in a table with syntax and example.
What are views in SQL? Write the syntax for creating view in SQL
What are primary structured data types in object database systems?
Unit 2
What is a data model in the context of database systems?
What are the main components of a data model?
How does the relational data model represent data?
How do conceptual, logical, and physical data models differ?
What are the challenges in implementation of ORDBMS?
Distinguish between RDBMS and ORDBMS.
Explain the working of Parallel Databases?
Explain shared Disk Architecture.
Explain parallel query mechanism.
Explain shared memory Architecture.
Unit 3
Distinguish between Distributed Database and Centralized Database
What is Data Fragmentation in Distributed Databases
Explain Client-Server Architecture in Distributed Databases.
What are Distributed Database Access Primitives ?
Write the major database access primitives of distributed database.
Write the Integrity Constraints in distributed databases.
Explain Share Nothing Architecture in Distributed Databases.
What is horizontal fragmentation in distributed database?
Explain any two transparencies in distributed databases.
Explain Peer to Peer Architecture in Distributed Databases.
Explain hybrid fragmentation with example in distributed database.
Unit 4
Explain the framework for distributed database design.
Explain with an overview of Database Fragmentation.
What is query equivalence ? What are rules of query equivalence transformations ?
Explain the rules of transforming a global query into fragmented query.
What are distributed grouping functions in distributed database.
What are parametric queries in distributed databases.
Explain the framework for distributed database design.
What are common aggregate functions used in distributed databases
Unit 5
Explain the basic query optimization framework in detail .
What are the strategies for query optimizations.
What are cost components of Query Execution.
Write a note on Information Retrieval System in DBMS.
Describe IR Model in DBMS.
Distinguish Database Management System over Information Retrieval System.
Explain Query Processing in DBMS.
Explain how the query processing is being optimized.
Write a note on Information Retrieval System in DBMS.
What are cost components of Query Execution?
Explain the basic query optimization framework in detail .
Explain rule based and cost based query optimization.
What is Indexing in DBMS ? What are the indexing methods ?
Unit 6
What is Data mining ? What are various data mining application ?
What are advantages of Data Mining ?
Explain how classification is done in data mining classification technique.
Apply k-means clustering algorithm to cluster the datapoints {2,4,10,12,3,20,30,11,25} into two clusters.
Take M1=4, M2=11
Form cluster with Ɛ=3.5 and min pts=3 for the following set of data points S1(5,7), S2(8,4), S3(33),
S4(4,4), S5(3,7), S6(6,7), S7(6,1), S8(5,5). Use DBSCAN Algorithm.
What is Knowledge Discovery Data process in data mining ?
What is clustering in data mining ? How does k mean clustering algorithm work ?
What are parameters required for DBSCAN algorithm ?
What is Ranking of Web pages in data mining ? Explain
Explain centroid based clustering algorithm in data mining.
What are decision trees in data mining ? Explain
