MCQs - Muiltiple Choice Questions - Objective Questions Collections for Computer Jobs Examinaitons
This section presents the multiple choice questions (MCQs) from following topics of Database Management System and Design.
Introduction, A Database Model, Relational Database Model, Integrity, RDBMS, SQL and Embedded SQL, Writing Basic SQL SELECT Statements, Restricting and Sorting data, Single Row Functions, Displaying Data from Multiple Tables, Aggregation Data Using Group Functions, Sub Queries, Manipulating Data and Creating &Managing Tables, Creating Views and Controlling User Access, Using Set Operators, Datetime Function, Database Design: Logical Design, Conceptual Design, Mapping Conceptual to Logical, Pragmatic issues, Physical Design, Integrity and Correctness, Relational Algebra, Relational Calculus. Normalization: 1NF, 2NF, 3NF, BCNF, 4NF,5NF, DKNF. Architecture of DBMS: Client-server, Open Architectures, Transaction Processing, Multi-User & Concurrency, and Backup & Recovery Database, Basic Concept of major RDBMS products: Oracle, Sybase, DB2, SQL Server and other Databases.