22319 Database Management System Mcq pdf [ All-chapters-MCQ ]
 |
| 22319 mcq |
| Subject | subject details |
|---|---|
| Program: | Diploma in computer engineering |
| Program Code | CO |
| Scheme | I |
| Semester | 3 |
| Course: | Database Management System |
| Course Code | 22319 |
Computer science is branch with many crucial subjects and one of the best subject is data base management system 22319 as a subject code [22319]. So Msbte notes has decided to create MCQ question bank set os subject 22319 Database Management System.
We had breifly summerized the subject and created this MCQ for you all. Better you should take your book and pen and start solving the MCQ's.
This MCQ's are creating perspetive syllabus-based so students can be benifited. So if you ❤️our site and really want us to support please consider sharing with your friends that may help us a lot to keep this site free as possible.
Unit 01-Database System Concepts
1.1 Concept of Data, database, DBMS, advantages of DBMS over file processing system, Application of database
1.2 Three level Architecture for database system
1.3 Data abstraction: Different levels of data abstraction, Instance and schema, Data independence-Logical and Physical independence
1.4 Overall Structure of DBMS
1.5 Data Modeling: Record based logical model-Relational ,Network, Hierarchical
1.6 Data Modeling Using the E-R Model: Entity Relationship Model, Strong Entity set, Weak Entity set, Types of Attributes, E-R Diagrams
Unit 02 – Relational Data Model
2.1 Fundamentals of RDBMS-Record, fields, data types, tables and database
2.2 Concept of RDBMS, E. F Codd‟s Rule for RDBMS, Key concepts-Candidate key, Primary key, Foreign key.
2.3 Normalization: Normalization Concepts, Need of Normalization, Types of Normalizatoion-1NF,2NF,3NF
2.4 Introduction to structured query language, Data types in SQL, Components of SQL-DDL,DML,DCL,DQL
2.5 DDL commands: CREATE, ALTER, DROP, TRUNCATE, DESC, RENAME
2.6 Data integrity constraint: types of data integrity constraint: I/O constraint-Primary key Foreign key, Unique key constraint, business rule constraint-Null, Not Null and check constraint.
2.7 DML commands: INSERT, UPDATE, DELETE
2.8 DCL Commands: COMMIT, ROLLBACK, SAVEPOINT, GRANT and REVOKE
2.9 DQL commands: SELECT
2.10 SQL Operators: Arithmetic Operators, comparison operators, Logical Operators, Set operators, Range searching operators- Between, Pattern matching operators-LIKE. Relational Data Model MCQ
Unit 03 – Interactive SQL & Advance SQL: SQL Performance Tuning
3.1 In-built functions: string, arithmetic
3.2 Date and time, Aggregate functions
3.3 Queries using Group by, having and order by clause, Joins-inner and outer join, sub queries
3.4 Views: concept of view, the create view command, updating views ,Views and joins, sub queries, dropping views,
3.5 Sequences: creating sequences, altering sequences, Dropping sequences
3.6 Indexes: index types, creating of an index: simple unique
3.7 Composite index, dropping indexes
3.8 Synonyms: creating Synonyms, Dropping synonyms
Unit 4: PL/SQL Programming
4.1 Introduction of PL/SQL, Advantages of PL/SQL, Block structure, execution environment, PL/SQL data types, variable, constant
4.2 Control structure::conditional control. iterative control, Sequential control,
4.3 Exception handling: predefined exception, User defined exception
4.4 Cursor: implicit and explicit cursor, declaring and opening cursor, Fetching a record from cursor, cursor for loops, parameterized cursor
4.5 Procedure: advantages, creating procedure, Executing and deleting a stored procedure
4.6 Functions: advantages, creating function, Executing and deleting a stored function
4.7 Database triggers: use of database triggers, how to apply database triggers, Types of triggers, syntax for creating trigger, deleting trigger.
PL/SQL Programming MCQ
Unit 5: Database security and Transaction Processing
5.1 Database security :introduction to Database security, data security requirement, Types of database user, creating and deleting users
5.2 Protecting the data within database: database privileges, System privileges and object privileges, Granting and revoking privileges
5.3 Transaction: concept, properties and state of transaction
5.4 Database backup-types of failure, causes of failure, Database backup introduction, types of Database backup
5.5 Database recovery-concept, Recovery techniques-roll forward and roll back
Comments
Post a Comment