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.
|
|
|
Disclaimer
PS Exam is all about Computer Science and Computer Jobs Exam Preparation, for those who are pursuing Career in Information Technology Field!
Our revenue source is advertisements and provide you Free Multiple Choice Questions, Free Quizes, Ebooks and Class Notes, Questions and Answers, Resources to help you prepare better, all for FREE. This site uses Google Adsense and other third party advertisements. The links with double underline are advertisements from Infolinks.