#1
July 2nd, 2014, 05:08 PM
| |||
| |||
RDBMS Important topics for placement exam
Can you give me important topics for Database Management Systems (DBMS) for placement examination of good companies ? Here I am giving you important topics for Database Management Systems (DBMS) for placement examination of good companies below : RDBMS Topics Difference between DBMS & RDBMS Functions performed by DBMS Understanding Database Principles of conceptual Database Design Relational Algebra and calculus Theory of Relational Algebra Nine operations Types of Users of DBMS Evolution of DBMS Traditional File Processing System and its Disadvantages Advantages of DBMS (In Depth) Drawbacks of Database systems Components of Data Base Management system File oriented system or file organization Properties of RDBMS Database Development example-to-create-tables-in-sql.html What is ROWID? Using pre-defined functions Explain Codd’s rule. Data Models (Part 1) (Entity,Attributes,Mapping Cardinalities) Data Models (Part 2)(Specialization, Generalization, Aggregation, ER Model) Data Models (Part 3) (Network,Hierarchical and Relational Data Model) Difference between Access and SQL server How many triggers you can have on a table? How to invoke a trigger on demand? Difference between stored procedure and triggers Cursors , its Types , its attributes and its uses What are keys and its Types? What are SQL Joins? What is aggregation, decomposition, generalization in RDBMS? What are partial, alternate, artificial, compound and natural key ? What is Functional Dependency, Multivalued dependency & Fully Functional dependency ? What is Data Independence? What is a view and How it is related to data independence? Difference between store procedure and Function Types of Normalization or Normal forms DBA, Database Designers & Application Programmers Triggers , its Types and its Uses What is a view ? What are its advantages and disadvantages ? What are Joins Explain Codd’s rule ? What is integrity? What are the different integrity checks? What is NULL value? What is a transaction processing system? What are the different transaction systems are there? What is MYSQL ? What is MS SQL Server? What is Oracle? What is MS Access? SQL Syntax (clauses) ?? What is SQL Data Types? What is an Operator in SQL? What is SQL?, Why SQL? and What is SQL Process? SQL - CREATE Table Denormalizing a Database What is an index? Its advantages and disadvantages... ACID Properties of Relational DBMS What is a constraint? What are the different constraints available? Client-Server Technology Overview of Query Processing Query Processing Strategies Important Queries Entity - Relationship Model and Its features Requirement for dbms Last edited by Neelurk; March 17th, 2020 at 02:13 PM. |
|