Database & DBMS Introduction
1. What is Database
Database is an organized collection of related data that is stored in an efficient and compact manner. The word organized means that data is stored in such a way that the user can use this data easily. The word related means a database is normally created to store the data about a particular topic.
For example, a database is created tor students, it will contain data about the students such as roll no, name, address, etc. Similarly, if the database is about the employees of an organization, it will contain the data of employees such as employee ID, grade and salary, etc. All data in the database is arranged in tables.
The word efficient means that the user can search the required data quickly. The word compact means that the stored data occupies as little space as possible in computer.
2. What is DBMS(Database Management System)
A database-management system is a computer application that interacts with end-users, other programs, and the database itself to capture and analyze data. A general-purpose DBMS allows the definition, creation, querying, update, and administration of databases. The DBMS provides users and programmers with a systematic way to create, retrieve, replace and manage data. A DBMS makes it viable for end-users to create, read, update and delete information in a database.
The DBMS basically serves as an interface between the database and end-users or software programs, ensuring that data is consistently organized and remains easily accessible. DBMSs include MySQL, PostgreSQL, EnterpriseDB, MongoDB, MariaDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, MemSQL, SQLite and IBM DB2.
3. What is Relational Database Model
Relational database model invented by Dr. R. F. Codd to solve the data integrity and data redundancy problems by using mathematics rules. In a relational database model, data is stored in relations. Relation is another term used for table. A table in a database has a unique name that identifies its contents. Every table have a column that uniquely identifies each row in the table.
Audience
This database mcqs series may help students or jobs seekers who are preparing their NTS educators, PPSC lecturers, FPSC, CSS, database administrator jobs, database manager jobs, database developer jobs, senior database administrator jobs, SQL engineer jobs, data modeler jobs, Oracle Apps DBA jobs, Teradata DBA jobs, senior Oracle application DBA jobs or other database related jobs test and interview.
List of Database MCQS Sets
Database MCQs Questions With Answers Set 1 - Click MeDatabase MCQs set 1 includes the MCQs related to the topics such as introduction to database, data and information, file processing system, components of database environment, database approach, database management systems, basics of database and history of the database system.
Database MCQs Questions With Answers Set 2 - Click MeThis database management system MCQs set 2 includes the MCQs related to the topics such as basics of the database, components of a database, database advantages and disadvantages, components of database environment, introduction to database, data redundancy, data integrity, data security, data consistency and database approaches.
Database MCQs Questions With Answers Set 3 - Click MeDBMS MCQs questions with answers set 3 includes the MCQs related to the topics such as database environment, three-level-architecture, mapping, data independence, introduction to database models, database development process, database administrator, data dictionary, logical database design, physical database design and functions of database management system.
Database MCQs Questions With Answers Set 4 - Click MeDBMS MCQs questions with answers set 4 contains the MCQs which covers the topics such as entity-relationship model, introduction to E-R model, components of E-R model, types of entities, types of attributes, types of entity relationships, degree of relationships, ternary relationship, cardinality relationship, one-to-one relationship, one-to-many relationship, many-to-many relationship, single-values attributes, multi-valued attributes and so on.
Database MCQs Questions With Answers Set 5 - Click MeDatabase Management System – DBMS (MCQs) set 5 contains the MCQs which covers the topics such as entity-relationship model MCQs, composite attributes, types of identifiers, composite identifiers, degree of relationships, recursive relationship and so on.
Database MCQs Questions With Answers Set 6 - Click MeDatabase Management System Quiz set 6 contains the MCQs of entity-relationship models, extended entity-relationship model, relationship attributes in entity-relationship model, entity-relationship modeling and normalization, data integrity, types of database constraints, components of entity-relationship model, types of entities, types of attributes, relational database model, relational database management system, relational keys and types of relations.
Database MCQs Questions With Answers Set 7 - Click MeDatabase MCQs with answers set 7 includes the MCQs of the semantic object model, semantic objects, semantic object attributes, attribute cardinality, semantic object views and all types of objects.
Database MCQs Questions With Answers Set 8 - Click MeDatabase MCQs with answers set 8 includes the MCQs of relational database model, basics of relational database model, primary key, attributes, cardinality and candidate key.
Database MCQs Questions With Answers Set 9 - Click MeDBMS mcqs with answers set 9 includes the mcqs of relational data integrity, referential integrity, datebase anomalies, types of anomalies, normalization, functional dependency, first normal form, second normal form, third normal form, transitive dependency, fourth normal form and Boyce-Codd normal form (BCNF).
Database MCQs Questions With Answers Set 10 - Click MeDBMS MCQ questions with answers set 10 includes the mcqs of datebase anomalies, types of normalization, transitive dependency, multi-valued dependencies, fourth normal form, Boyce-Codd normal form (BCNF) and various database keys concepts.
Database MCQs Questions With Answers Set 11 - Click MeDBMS MCQ questions with answers set 11 includes SQL mcqs, SQL basics questions and answers, SQL query mcq questions and Answer, SQL quiz questions, SQL online test and SQL objective questions.
Database MCQs Questions With Answers Set 12 - Click MeDBMS MCQ questions with answers set 12 has 30 mcq on sql queries. This sql multiple choice questions with answers set help you to prepare for your IT, computer science related jobs competitive exams. SQL mcq online test 12 also helpful to learn the basics of sql quries, its structure, clauses, keywords, and rules to write sql query.
- Database MCQs Questions With Answers Set 13 (Coming Soon....)
- Database MCQs Questions With Answers Set 14 (Coming Soon....)
- Database MCQs Questions With Answers Set 15 (Coming Soon....)
Note: We are working to update our site daily, all those parts which are currently on coming soon will be added very soon. So keep in touch with us to get fresh content daily.