Skip to content
Gyanrush
Courses
How it works
Help
Sign in
Start free
Open Gyanrush
Courses
How it works
Help
Sign in
Start free
Open Gyanrush
Courses
University
MCA Semester 1
CAP570
C
A
P
5
7
0
CAP570
Advanced Database Techniques
6 units · 22 topics · 226 questions · 22 topic notes
Practise CAP570 free
Open Gyanrush
End-term exam
5
3
53 days left
Days left to Fri, 18 Dec, 13:30
Unit 1
Basics of database
Overview, importance, applications and types of databases
10 questions · MTE
Database architecture and components
10 questions · MTE
Database schemas and types of data models
10 questions · MTE
Conceptual, logical and physical database design
10 questions · MTE
Unit 2
E-R modeling
ER modelling basics: entities, attributes, relationships and ER diagram notations
10 questions · MTE
Conversion of ER models to relational schemas
10 questions · MTE
ACID properties
9 questions · MTE
Constraints on relations and types of keys
10 questions · MTE
Unit 3
Database normalisation
Functional dependencies and anomalies
10 questions · MTE
Normal forms 1NF, 2NF and 3NF
10 questions · MTE
BCNF and denormalization
10 questions · MTE
Unit 4
Database joins
Concept and need of database joins
9 questions · ETE
Inner, left, right and self joins
12 questions · ETE
Views
9 questions · ETE
Transaction control: COMMIT, ROLLBACK and SAVEPOINT
10 questions · ETE
Unit 5
PL/SQL
PL/SQL overview and differences between SQL and PL/SQL
9 questions · ETE
Benefits and features of PL/SQL
10 questions · ETE
Basic structure of a PL/SQL block
12 questions · ETE
Unit 6
Advanced databases
Current trends in database technology and big data
10 questions · ETE
OLAP and OLTP
11 questions · ETE
Cloud databases and NewSQL
10 questions · ETE
NoSQL databases
15 questions · ETE