Category Home -> Database Management System (DBMS)

MCQ Quiz List - Category: Database Management System (DBMS)

An overview of database management system, database system Vs file system, Database system concepts and architecture, data models schema and instances, data independence and database language and interfaces, Data definitions language, DML, Overall Database Structure.Data Modeling using the Entity Relationship Model: ER model concepts, notation for ER diagram, mapping constraints, keys, Concepts of Super Key, candidate key, primary key, Generalization, aggregation, reduction of an ER diagrams to tables, extended ER model, relationships of higher degree. Relational data model concepts, integrity constraints: entity integrity, referential integrity, Keys constraints, Domain constraints, relational algebra, relational calculus, tuple and domain calculus, Introduction to SQL: Characteristics of SQL. Advantage of SQL. SQL data types and literals. Types of SQL commands. SQL operators and their procedure. Tables, views and indexes. Queries and sub queries. Aggregate functions. Insert, update and delete operations. Joins, Unions, Intersection, Minus, Cursors in SQL. Design & Normalization Functional dependencies, normal forms, first, second, third normal forms, BCNF, inclusion dependences, loss less join decompositions, normalization using FD, MVD, and JDs, alternative approaches to database design. Transaction Processing Concepts Transaction system, Testing of serializability, Serializability of schedules, conflict & view serializable schedule, recoverability, Recovery from transaction failures, log based recovery, checkpoints, deadlock handling. Concurrency Control Techniques Concurrency control, locking Techniques for concurrency control, Time stamping protocols for concurrency control, validation based protocol, multiple granularity, Multi version schemes, Recovery with concurrent transaction.
Showing results 1 - 10 of total 16
Short by   Show Results per page.



Sr. No: Paper: Action:
1 Basic Database Management Concept/Database Management System (DBMS)/
(900 Seconds, 10 marks)
View (7245)| Take Test (1154)
2 Database Management Basics/Database Management System (DBMS)/
(3600 Seconds, 50 marks)
View (1806)| Take Test (342)
3 Database Management System (DBMS) Multiple Choice Questions(MCQs) - Objective Question Set -2/Database Management System (DBMS)/
(1200 Seconds, 20 marks)
View (1109)| Take Test (194)
4 Database Management System (DBMS) Multiple Choice Questions(MCQs) - Objective Question Set -3/Database Management System (DBMS)/
(1200 Seconds, 20 marks)
View (768)| Take Test (104)
5 Database Management System (DBMS) Multiple Choice Questions(MCQs) - Objective Question Set -4/Database Management System (DBMS)/
(1200 Seconds, 20 marks)
View (719)| Take Test (102)
6 Database Management System (DBMS) Multiple Choice Questions(MCQs) - Objective Question Set -5/Database Management System (DBMS)/
(1200 Seconds, 20 marks)
View (727)| Take Test (94)
7 Database Management System (DBMS) Multiple Choice Questions(MCQs) - Objective Question Set -6/Database Management System (DBMS)/
(1200 Seconds, 20 marks)
View (742)| Take Test (113)
8 Oracle Database Management System ( Oracle DBMS) Multiple Choice Questions(MCQs) - Objective Question Set -1/Database Management System (DBMS)/
(900 Seconds, 20 marks)
View (615)| Take Test (62)
9 Oracle Database Management System ( Oracle DBMS) Multiple Choice Questions(MCQs) - Objective Question Set -2/Database Management System (DBMS)/
(1200 Seconds, 20 marks)
View (496)| Take Test (52)
10 Oracle Database Management System ( Oracle DBMS) Multiple Choice Questions(MCQs) - Objective Question Set -3/Database Management System (DBMS)/
(1200 Seconds, 20 marks)
View (609)| Take Test (57)