dbms maroc-evasion.info - Free download as PDF File .pdf), Text File .txt) or read online for free. Free download of DBMS MCQs E-Book by shuseel baral. Available in PDF, ePub and Kindle. Read, write reviews and more. Data Base Management Systems. (DBMS). Study Material (Objective Type questions with Answers). Shared by Akhil Arora. Powered by maroc-evasion.info8AmbitionZ. com.
|Language:||English, Spanish, Arabic|
|Genre:||Science & Research|
|Distribution:||Free* [*Registration needed]|
Our + Database Management System questions and answers focuses on all areas of Database Management System subject covering + topics in. Database management system multiple choice questions has DBMS MCQs. Database management system quiz questions and answers pdf, MCQ on. DATABASE MANAGEMENT SYSTEM Questions and Answers pdf free download ,DBMS objective type Questions and Answers,multiple Engineering interview questions,Mcqs,Objective Questions,Class Notes,Seminor.
B Index. C Integrity constraint. D Functional dependency. Ans: A The rule that a value of a foreign key must appear as a value of some specific table is called a referential constraint.
Referential integrity constraint is concerned with foreign key Q. A It requires that an entity belongs to no more than one level entity set. B The same entity may belong to more than one level.
C The database must contain an unmatched foreign key value. D An entity can be joined with another entity in the same level entity set.
Ans: A Disjoint less constraint requires that an entity belongs to no more than one level entity set. Disjoint less constraint means that an entity can be a member of at most one of the subclasses of the specialization. B Physical schema. C Subschema. D Super schema. Ans: According to the levels of abstraction, the schema at the intermediate level is called conceptual schema. Note: All the options given in the question are wrong.
B Specialization. C Aggregation. D Inheritance. Subset of a Cartesian product of a list of tuple D. Subset of a Cartesian product of a list of relations.
In mathematical term Table is referred as A. Relation B. Attribute C. Tuple D. In mathematical term Row is referred as A. Superkey B. Domain C. Attribute D. Minimal Superkeys are called A.
Schema keys B.
Candidate keys C. Domain keys D. Attribute keys. Which of the following is not Modification of the Database A. Deletion B.
Insertion C. Sorting D. Which of the following is Relation-algebra Operation A. Select B. Union C.
Rename D. Which of the following in not Outer join? Left outer join B. Right outer join C. Full outer join D. Who proposed the relational model? Bill Gates B. Codd C. Herman Hollerith D. Charles Babbage. Set of premitted values of each attribute is called A.
Domain B. Tuple C. Relation D. Which of the following in true regarding Null Value? Null 0 D. Null 0. Logical design of database is called A. Database Instance B. Database Snapshot C. Database Schema D. Snapshot of the dta in the database at a given instant of time is called A. Database Instance C. Database Snapshot D. Which of the following is not Unary operation? Project C. Which of the following is not binary operation? Union B.
Set Difference D. Cartesian Product. Which of the following is correct regarding Aggregate functions? The Primary key must be A. Non Null B. Unique C. Option A or B D.
Option A and B. A command to remove a relation from an SQL database A. Min B. Max C. Select D. The attribute that can be divided into other attributes is called A.
Simple Attribute B. Composite Attribute C. Multi-valued Attribute D. Derived Attribute. Attributes B. Weak entity set C.
Relationship sets D. Multi-valued attributes. Multi-valued attributes C. Weak entity set D. Relationship sets. Atomicity, Consistency, Isolation, Database B. Atomicity, Consistency, Isolation, Durability C. Atomicity, Consistency, Inconsistent, Durability D. Automatically, Concurrency, Isolation, Durability.
If every non-key attribute is functionally dependent on the primary key, the relation will be in A. First Normal Form B. Second Normal Form C. Third Normal Form D. Fourth Formal Form. Database locking concept is used to solve the problem of A.
Lost Update B. Uncommitted Dependency C. Inconsistent Data D. UML is stands for A. Universal Modeling Language B. Unified Modeling Language C. United Modeling Language D. Uni Modeling Language. Create information table in the Database B. Insertion of new information into the Database C. Deletion of information in the Database D. Modification of information in the Database. Which of the following in true regarding Referential Integrity?
Every primary-key value must match a primary-key value in an associated table B. Every primary-key value must match a foreign-key value in an associated table C. Every foreign-key value must match a primary-key value in an associated table D. Every foreign-key value must match a foreign-key value in an associated table Answers: Which of the following option is use to retrieval of data?
Stack b. Data Structure c. Linked list d. Offline database connection b. Oriented database connection c. Database management systems quiz has 51 multiple choice questions MCQs.
Disk storage, file structures and hashing quiz has 74 multiple choice questions MCQs. Entity relationship modeling quiz has 50 multiple choice questions MCQs. File indexing structures quiz has 20 multiple choice questions MCQs. Functional dependencies and normalization quiz has 27 multiple choice questions MCQs. Query processing and optimization algorithms quiz has 10 multiple choice questions MCQs.
Relational algebra and calculus quiz has 62 multiple choice questions MCQs.
Relational data model and database constraints quiz has 35 multiple choice questions MCQs.