We are now share DBMS MCQ'S For MSBTE Computer Diploma students who are learn in 2nd year or 3rd semester. This MCQ are very important regarding Test exam and final board exam in this MCQ pdf file we cover all units . We try our best to provide you this MCQ which are highly chances to comes to exam.
What is DBMS?
• DBMS means Database management system it's also called DMS.
•DBMS is a collection of interrelated data & set of programs to access the data.
•The primary goal of a DBMS is to provide a way to store & retrieve database
information that both convenient & efficient.
Examples of DBMS
• MySQL
• FoxPro
• MS-Access
• Oracal
• SQLite
• IBM Db2
Note: Scroll Down to Get/Download MCQ'S
Application of Database Systems
1.Banking -
For customer information, accounts, and loans, and banking transactions.
2. Airlines :-
For reservations and schedule information. Airlines were among the first to use
databases in a geographically distributed manner—terminals situated around the world accessed the central database system through phone lines and other data networks.
3.Universities :-
For student information, course registrations, and grades.
4.Credit Card Transactions:-
For purchases on credit cards and generation of monthly statements.
5. Telecommunication:-
For keeping records of calls made, generating monthly bills, maintaining balances on prepaid calling cards, and storing information about the communication networks.
6. Finance:-
For storing information about holdings, sales, and purchases of financial
instruments such as stocks and bonds.
7. Sales:- For customer, product, and purchase information.
8. Manufacturing:-
For management of supply chain and for tracking production of items in factories, inventories of items in warehouses/stores, and orders for items.
9. Human resources:-
For information about employees, salaries, payroll taxes and benefits, and for generation of paychecks.
10. Railway Reservation Systems:-
For reservations and schedule information.
11. Web:-
For access the Back accounts and to get the balance amount.
12. E –Commerce:-
For Buying a book or music CD and browse for things like watches, mobiles from the Internet.
What is RDBMS?
A Relational Database management System(RDBMS) is a database management
system based on the relational model introduced by E.F Codd. In relational model, data is stored in relations(tables) and is represented in form of tuples(rows).
E.F.Codd’s Rules for RDBMS
Rule 1: Information rule
All information(including metadata) is to be represented as stored data in cells of tables.
The rows and columns have to be strictly unordered.
Rule 2: Guaranted Access
Each unique piece of data(atomic value) should be accesible by : Table Name +Primary Key(Row) + Attribute(column).
Rule 3: Systematic treatment of NULL
Null has several meanings, it can mean missing data, not applicable or no value. It should be handled consistently. Also, Primary key must not be null, ever. Expression on NULL must give null.
Rule 4: Active Online Catalog
Database dictionary(catalog) is the structure description of the complete Database and
it must be stored online. The Catalog must be governed by same rules as rest of the
database. The same query language should be used on catalog as used to query database.
Rule 5: Powerful and Well-Structured Language
One well structured language must be there to provide all manners of access to the data
stored in the database. Example: SQL, etc. If the database allows access to the data without the use of this language, then that is a violation.
Rule 6: View Updation Rule
All the view that are theoretically updatable should be updatable by the system as well.
Rule 7: Relational Level Operation
There must be Insert, Delete, Update operations at each level of relations. Set operation like Union, Intersection and minus should also be supported.
Rule 8: Physical Data Independence
The physical storage of data should not be the matter to the system. If say, some file
supporting table is renamed or moved from one disk to another, it should not effect the
application.
Rule 9: Logical Data Independence
If there is change in the logical structure(table structures) of the database the user view of data should not change. Say, if a table is split into two tables, a new view should give result as the join of the two tables. This rule is most difficult to satisfy.
Rule 10: Integrity Independence
The database should be able to enforce its own integrity rather than using other programs. Key and Check constraints, trigger etc, should be stored in Data Dictionary. This also make RDBMS independent of front-end.
Rule 11: Distribution Independence
A database should work properly regardless of its distribution across a network. Even
if a database is geographically distributed, with data stored in pieces, the end user should get an impression that it is stored at the same place. This lays the foundation
of distributed database.
Rule 12: Non-subversion Rule
If low level access is allowed to a system it should not be able to subvert or bypass
integrity rules to change the data. This can be achieved by some sort of locking or
encryption.
Category of SQL
1. Data Definition Language (DDL)
2. Data Manipulation Language (DML)
3. Data Control Language (DCL)
4. Transaction Control Language (TCL)
DDL Commands
• Create
• Alter
• Drop
• Truncate
• Rename
• Describe
DML Commands
• Insert
• Update
• Delete
• Select
DCL Commands
• Grant
• Revoke
TCL Commands
• Commit
• Savepoint
• Rollback
DOWNLOAD MCQ
Conclusion
Thank you for reading this blog post! We hope you enjoyed it and if you want to learn more about our Projects and study material, please check out our website again. Thanks for reading!