\

  Database Management System
Easy Medium Difficult
2019 DEC 1. Query optimizer 1. B-Tree

2. SQL-Count(*)

3. ER-Diagram

4. Natural Join

5. Cloud computing

6. Normal Forms(5)

 1. Order of schema
2019 JUNE 1. Keys

2. Hadoop tools

3. Relational query language

4. Relational algebra

5. Association with multiplicities

6. Git(Distributed Version Control System)

 1. DML

2. BCNF

3. Referential Integrity

 1. Hadoop Functions
2018  DEC 1.DW basics

2.Data Scrubbing

3.Clustering index

4.SQL command(DROP)

5.Software stack(cloud)

 1.SQL query(GROUP BY)

2.Finding of candidate keys

3.Attribute number of spaces

4.Hadoop cluster(facebook),Hadoop streaming

5.Transaction management(redo log record)

—
2018  JULY 1.join basics

2.Hierarchical database, a hashing function

3.E-R Model

 1.SQL query on COUNT(*)

2.Transactions management-conflict serializable

3.Normal Forms

4.Primary key attribute of relation

5.DBMS Miscellaneous

6.Relational Database anomalies

7.Hash table using closed hashing

—