UML is stands for B. it takes a list of values and return a list of values as result D. Relationship sets, 35. An entity type whose existence depends on another entity type is called a _____ entity. Reason : If k is a foreign key in a relation R1, then K is a key for some other relation. B. Tuple B. E.F. Codd D. Charles Babbage, 22. Many super types ii. Hewage A. Super key External Level Relation Security One big table with all attributes from both entities included D. Multi-query, 60. iii. Introduction to Database Systems 3 Answer 1.5 The DBA is responsible for: Designing the logical and physical schemas, as well as widely-used portions of the external schema. User View 76. C. Master query a. (a) 67. The defines the logical schema of the database.” 74. (a) This quiz consist of database management DBMS quiz questions in the form of multiple choice out of which only one option is correct.These questions should be prepared for various competitive exam. d. None of these, Answers :- Which of the following in true regarding Null Value? Selects all the fields from the Customer table for each row with a customer labeled “best” Tree protocol System View (d) A. Which of the following is an unary operation? (a) A. Deletion 0000015984 00000 n 0000008765 00000 n 0000007898 00000 n Query optimization (d) (c) (e) C. Atomicity, Consistency, Inconsistent, Durability Decrease the cost of implementation. Answer : (a) d. Functional dependency, 48. A. it takes a list of values and return a single values as result C. Relation _____________ refers to the correctness and completeness of the data in a database? A table that displays data redundancies yields ____________ anomalies The protocol that ensures conflict serializability is (b) A. A. Super query Time stamp ordering protocol None of the above. D. All of the above, 26. A. Transitive dependency A logical description of some portion of database that is required by a user to perform task is called as D. Null 0, 24. B. (d) (b) Writing SQL statements within codes written in a general programming language The various relationships of database are: One-to-one: … In DBMS FD stands for _______ Selection operation Reason: In an SQL statement where clause states the conditions for row selection Instructor Database Schema (b) Database Schema Middle of the above. Multiple partition query B. Partial transitive dependency Additional nouns which are appearing in the narrative description of the database requirements D. Avg, 32. From Select Universal Modeling Language (b) 100. Data security C. Database A. A. Integrity Control. b. Arithmetic algebra Supervision (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName), EmpID) Database Management System (DBMS) Questions and Answers . (d) Recovery. (e) D. Union, 27. Bill Gates (b) Reason: How many different product descriptions are in the Product Table? (e) (e) Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName), SupervisorID). D. All of the above, 2. Writing a SQL statement to retrieve data from more than one relation Business rule constraint Collection of programs to access data Reason: Knowing the value of attribute A you can look up the value of attribute B. Unique i. ANSI/ARPANET Granting the Privileges B. 65. Foreign key added on the Parent (one side) referencing the child 1 5. View Answer Discuss. C. Database Schema B. Subset of a Cartesian product of a list of domains Which of the following is the structure of the Database? 94. 70. The left side of the tree c. Primitive operation 84. Weak entity. D. Option A and B, 30. Pressing the Enter key without making a prior entry of any kind. Divide the data up by logical groups of entities C. Set Difference D. View Level, 3. (b) (e) Logical Manager (c) Entering a value Which of the following is not a level of data abstraction? Secondary key (c) Database that contains occurrences of logically organised data or information Partial transitive dependency (b) The defines the physical view of the database. i. Reason: Data integrity is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated Deadlock. D. Every foreign-key value must match a foreign-key value in an associated table, Answers :- Co-related query. Answer : (a) 801 0 obj << /Linearized 1 /O 803 /H [ 827 7094 ] /L 1008394 /E 19037 /N 229 /T 992255 >> endobj xref 801 20 0000000016 00000 n Computer Basics Advanced Computer Questions … Select Database Instance What is MS-Access? Transitive dependency Join, Projection, Restriction Reason: Balanced Tree Index is automatically created when we do not specify. C. Herman Hollerith A transaction completes its execution is said to be 0000016063 00000 n 0000014428 00000 n What is Database Management System (DBMS)? C. Tuple Reason: Function dependencies are not associated with relations; they are based on the semantics of information that we are dealing with. C. A Field 94. (b) Answer : (b) c. Linked list a. D. Attribute keys, 18. 66. 81. Physical Schema 88. 73. C. Select a. Relational algebra K cannot have a null value for tuples in R1 What is relational database… Nodes 82. Group By C. Option A or B Right – Left approach 64. (c) i. W3C (a) Weak entity set Right outer join Which of the following is not an Schema? 82. (d) Weak Secondary index d. None of these, 46. (c) All of the following are advantages of SQL-invoked routines EXCEPT Sharability 63. (c) Answer : (c) Which type of file is easiest to update? Attributes Every primary-key value must match a foreign-key value in an associated table (d) B a tuple . A. Snapshot of the dta in the database at a given instant of time is called Database locking concept is used to solve the problem of (a) (e) Home >> Questions>> Computer. (a) D. Fourth Formal Form, 37. C. Database Snapshot D. Domain, 16. (e) Which of the following is Relation-algebra Operation C. Tuple Reason: Security (c) 0000008079 00000 n (c) Retention Partial functional dependency At least one subtype (a) (e) (c) Left to Left Answer (Discuss two bene ts of views): Solution: A view is a relation de ned by a query and there are … A. (c) A Relation is a BCNF is a fourth normal form. a. (e) (c) D. Alter table , Answers :- (e) b. Schema DATABASE MANAGEMENT SYSTEM Questions and Answers pdf free download,DBMS objective type Questions and Answers,multiple choice interview questions,online quiz D. Database-level lock, 59. 0000012886 00000 n Random. Consider the following table obtained using Student and Instructor relations. Conceptual Level B. Data integrity ______________ is a classical approach to database design? (b) (c) Reason : Logical data independence refers to making a change to the conceptual schema of a database but not affecting the existing external schemas. DATABASE MANAGEMENT SYSTEM SET 9. Which of the following is not correct? (c) C. Attributes K is a key for some other relation (c) D. Partial functional dependency, 54. 69. iii. 0000000827 00000 n D. All of the above, 58. (b) Efficiency DBMS Interview Questions And Answers. A. 92. 0000008506 00000 n Pressing the ESC key Derived. Answer : (e) a. Offline database connection (d) (d) B. Sub query Correct Answer … (c) (a) (c) 88. (a) (e) The top of the tree (e) iv. You do not need to know the value of attribute A in order to look up the value of attribute B 71. Concurrency Control (b) Reason : Buckets are used to store one or more records in a hash file organization. How many products are in the Product Table? The property of transaction which ensures that either all operations of the transaction are reflected properly in the database or none, is called A. Each entity must include some descriptive information (e) (a) Answer : (e) State the unit of storage that can store one or more records in a hash file organization C. Update Data redundancy and inconsistency K is a Composite key for R1. 70. Which of the following is correct regarding Aggregate functions? Database is collection of data and Managing database … A type of query that is placed within a WHERE or HAVING clause of another query is called Every tuple of R1 has a distinct value for K Answer : (e) D. All of the above, 21. Who proposed the relational model? Physical data independence (d) Buckets Critical Level Answer : (b) (adsbygoogle = window.adsbygoogle || []).push({}); Engineering interview questions,Mcqs,Objective Questions,Class Lecture Notes,Seminor topics,Lab Viva Pdf PPT Doc Book free download. Answer : (a) (d) C. Attribute Reason : i).ANSI/SPARC ii) External Level iii)Internal Level iv) Conceptual Level (d) Strong (b) relationship types Your email address will not be published. Data structure A. Database Management System 0000013550 00000 n Exclusive lock 0000014224 00000 n Conceptual Level (a) C. United Modeling Language D. Schema, 23. Saved (b) Primary Key is added on one side. 0000012324 00000 n Transaction Manager Peiris C. Domain keys (b) Consider the following ER diagram depicting the relationship of an employee and supervisor: What is the possible relation if the above ERD is mapped into a relational model? Data Manipulation Language (DML) is not to (d) D. Domain, 13. %PDF-1.2 %���� First Horizontal Fragmentation is (e) (c) C. it takes a single value and returns a list of values as result D. All of the above, 7. Answer : (a) 72. represent the weak entity type names (e) “In 1978 committee proposed a generalized framework for database systems and it provides a three_level architecture. First Normal Form (d) Answer : (b) Easy of use. a. What is ACID properties of Transactions? 87. Reason: Recovery is the one that normally is performed by DBMS, without the interference of the DBA 63. Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName)) Union, Intersection, Minus (b) Conceptual Level. Column header is refer as Middleware. External Level Left outer join A functional dependency between two or more non-key attributes is called 1 – C / 2 – B / 3 – A / 4 – B / 5 – C / 6 – B / 7 – D / 8 – A / 9 – B / 10 – D. 61. There is a golden opportunity for all the candidates who want to learn about the database. Which of the following is Database Language? B. DBMS Objective type Questions and Answers List. (a) d. Query, 42. The procedure of identifying entities and attaching attributes always leads to a unique solution D. Foreign key, 52. (d) Here you can download the free Database Management System Pdf Notes – DBMS Notes Pdf latest and Old materials with multiple file links. (a) (b) please allow to copy the contents in above. iii. Student n Instructor 99. How many different product descriptions are in the Product Table? D. Automatically, Concurrency, Isolation, Durability, 36. (b) No two rows … Super query Consistency Database management system objective questions and answers page contain 5 questions from chapter Database Security & Integrity. Non-transitive dependency These solved quiz objective questions with answers … Which of the following type of index is automatically created when we do not specify? 1 – d / 2 – c / 3 – a / 4 – b / 5 – c / 6 – b / 7 – d / 8 – d / 9 – d / 10 – b, 51. (a) Download Database Management Systems Notes, PDF [2021] syllabus, books for B Tech, M Tech, BCA. Which of the following in not a function of DBA? (c) Transitive dependency c. Both (b) D. Bottom – Up approach, 56. i. ANSI/SPARC (e) 92. (b) A method that speeds query processing by running a query at the same time against several partitions of a table using multi processors is called (e) Multi-valued (a) (e) Here we go!! Left – Right approach B. 1 – C / 2 – B / 3 – A / 4 – D / 5 – B / 6 – C / 7 – D / 8 – B / 9 – A / 10 – C, 41. A. How many types of keys in Database Design? C. Collection of data describing one particular enterprise 76. Data Manipulation Language enables users to Multiplication and Division Answer : (c) Partial non-key dependency Difficulty in accessing data Concurrency protocol D. Authorization for data access, 10. 1 7. Out of the following activities, which is the one that normally performed by DBMS, without the interference of the DBA? Internal Level Collection of database exam solutions Rasmus Pagh October 19, 2011 This is a supplement to the collection of database exams used in the course Introduction to Database Design, which includes answers… A relationship between the instances of a single entity type is called a _____ relationship. (d) B. Row-level lock A. Atomicity, Consistency, Isolation, Database A relation that has no partial dependencies is in which normal form (e) a. Answer: DBMS, commonly known as Database Management System, is an application system whose main purpose revolves around the data.This is a system that allows its user to store the data, define it, retrieve it and update the information about the data inside the database. Projection, Selection, Rename. (d) Reason: Select Record controller Table (d) Hashed Order By Reason: Indexes are created in most RDBMS’s to Provide rapid, random and sequential access to base-table data B. Insertion of new information into the database Database is collection of data and Managing database … d. None, 44. Each question has its accurate & detailed answers … (a) B. Multi-valued attributes A. B. (d) Which SQL Query is use to remove a table and all its data from the database? Divide the data up by logical groups of files Database Management System - DBMS Trivia Questions and Answers PDF. Dense index Here, i am sharing with you some important Database Management System MCQ's type questions answers. (d) Parallel query processing Balanced Tree Index Enlist the various relationships of database. Ans: A super key is a set of attributes of a relation schema upon which all attributes of the schema are functionally dependent. (c) Instructor ÷ Student The bottom of the tree Foreign key added on the Child (many side) referencing the parent C. Functional dependency Database Management System - DBMS Question and Answer. 64. (a) 0000012506 00000 n Answer : (a) D. A Column, 12. The nouns arising from a database requirement description can be considered as names of attributes 98. Isolation H��U�[X��4�1J�fQT�=S2SD3PT�\s(c��yLG+�$LQ!S3s+1-\�J��qA\r)�%��%-���yf���. Foreign key added on both sides (both tables) b. Attribute D. Committed, Answers :- Second Internal Level Answer : (a) Binary A Table Reason: Divide the data up by logical groups of records. A. Required fields are marked *. 66. Answer : (b) D. Uni Modeling Language, 39. 75. How many different columns named “Product Description” is there in table Product_T? Answer : (d) Sparse Index. C. Rolled Functional dependency 85. a. Security and authorization. Non Null A. Which algebra is widely used in DBMS? Oriented database connection C. Deletion of information in the Database B. Atomicity, Consistency, Isolation, Durability ii. 86. C. Object-Based data model C. Third LIST OF ATTEMPTED QUESTIONS AND ANSWERS Multiple Choice Multiple Answer ... hardware , user system interface , database and its management Information requirement within organization are different. B. 79. (a) Select Count (Product_Description) from Product_T; (d) A space (c) Codependent c. Relation The of the architecture defines user views of the database. Reason : A software application that is used to define, create, maintain and provide controlled access to user databases. Get complete lecture notes, interview questions paper, ppt, tutorials, course. Routine Maintenance Multi-query Your email address will not be published. Candidate keys Logical data independence Variant A. External Level 0000007921 00000 n iv. Perpendicular query processing Backwards approach Database Management System Multiple Choice Questions and Answers or DBMS MCQs for GATE, NET Exam from chapter Database Architecture & Modeling. A. (a) D. it takes a single value and returns a single value as result, 29. 0000000751 00000 n (b) (d) B. Insertion of new information into the Database B. B. C. Data constraint A. Delete table Answer : (a) 87. Which of the following is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated? D. Data View, 55. B. Loaded Data availability and recovery from failures. Questions on Indexing and Hashing. C a criteria . d. Right to Left, 47. (e) Reason : In the narrative description of the database requirements, verbs tend to indicate the names of relationship types. (b) Divide the data up by logical frames. Data Definition Language Lost Update Which of the following is correct? Atomicity (c) (b) Which relational algebra operation could have been applied on the pair of relations Student and Instructor to obtain the above data? Answer : (d) (c) c. Facilitate dependency Answer : (b) Clustered Union B. 0000013835 00000 n Answer : (c) A. A. Left to Right 68. (b) In an Entity-Relationship Diagram “Ellipses” represents (c) (e) C. Weak entity set Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released? 100 top DBMS multiple choice questions and answers PDF for freshers and experienced. (a) Reason: The hierarchical database model uses the hierarchic sequence that always starts at the left side of the tree. How many characters are in the field name “Product_Description”? C. Rename The FDs that hold for attributes of a relation need not be satisfied at all times Answer : (b) Answer : (c) Which of the following set is suitable to fill the blanks in the above paragraph? Each mcq has 4 possible answers. 78. (e) Sub query Answer : (a) A. (d) (c) (e) _______ allow us to identify uniquely a tuple in the relation. Reason: A method that speeds query processing by running a query at the same time against several partitions of a table using multi processors is called parallel query processing. Database Instance (b) a. (a) A. Entity-Relationship model Primary key List some database applications. Only one super type Relation A. Answer : (a) (d) Which of the following is not Unary operation? (b) .ANSI/ARPANET Reason: Hash file is easiest to update Indexed Answer : (b) Adjectives written in the database requirement description help to identify the partial relationships among entities. 1. Attributes (b) Attribute Double click to Download PDF … B. B. In mathematical term Table is referred as Full functional dependency A ________ attribute is an attribute that can be further subdivided to yield additional attributes. A. b. (d) (e) The section contains questions on index definition, bitmap and … (c) (d) B. Answer : (c) D. Domain, 15. Hashed ii. 0000008246 00000 n D. Cartesian Product, 28. A. c. Right to Right B. Relational data model Database Management System Notes Pdf – DBMS Pdf Notes starts with the topics covering Data base System Applications, data base System VS file System… Every entity is a collection of attributes. B. Data Manipulation Language 67. C. Candidate key External Level Disadvantages of File systems to store data is: D. Data independence, 57. Each multivalued attribute should be classified as an entity even if it does not have any descriptive information In a super type/subtype hierarchy, each subtype has Answer : (b) B. Null 0 A. Domain Simple Attribute (b) a. Stack Reason: Composite attribute is an attribute that can be further subdivided to yield additional attributes. An index record appears for every search key value in the file is Every primary-key value must match a primary-key value in an associated table B. 1 2. Durability Reason : Instructor – Student is the relational algebra operation that could be applied on the pair of relations Student and Instructor to obtain the above data. (d) Left-side approach Q #1) What is DBMS used for?. K is a Primary key for R1 Student ? 83. Answer : (c) Database Management System solved MCQ sets : Database Management Short Questions to test Database concept : DBMS is the short form of Database Management System.DBMS is a collection of computer programs that helps us to create and manage database. C. Logical View Reason: Entity type whose existence depends on another entity type is called a weak entity A software application that is used to define, create, maintain and provide controlled access to user databases Create Table Multi level index Ternary (e) (d) Minus, Multiplication, Intersection A. Conceptual Level Reason : Embedded SQL refers to writing SQL statements within codes written in a general programming language. Divide the data up by logical groups of records Answer : (d) (c) D. All of the above, 25. Database Management Short Questions to test Database concept : DBMS is the short form of Database Management System.DBMS is a collection of computer programs that helps us to create and manage database. 0000012032 00000 n B. D. Logical Schema, 8. 97. Answer : (c) (b) Ajith Relationship D a relation . Disk pages Where. (b) Answer : (b) D. All of the above, 4. Right-side approach Relation Sujith 80. (e) (a) Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName)} C. Table-level lock Instructor – Student. (a) Create information table in the Database A zero Authorization rule B. A. 84. 100. Hello Friends Here in this section of Database Management System Basics Short Questions Answers,We have listed out some of the important Short Questions with Answers which will help students to answer … D. Modification of information in the Database, 40. B. 93. Two phase lock In the context of a database table, the statement “A determines B” indicates that Which of the following in not Outer join? (a) b. Generalized selection Student – Instructor Table (b) 68. (a) Reason: Atomicity is the property of transaction which ensures that either all operations of the transaction are reflected properly in the database or none A. Insertion b. A lock that allows concurrent transactions to access different rows of the same table is known as a Project D. Subset of a Cartesian product of a list of relations, 14. b. (b) A command to remove a relation from an SQL database What does the following SQL statement do? D. BCNF, 53. Select * From Customer Where Cust_Type = “Best”; Independent. C. Logical Level 99. The right side of the tree (c) Repository of meta data, which is a central storehouse for all data definitions, data relationships, C. Schema Definition (c) (e) In an SQL statement, which of the following parts states the conditions for row selection? When converting one (1) to many (N) binary relationship into tables, the recommended solution is usually Kasun. D. File Manager, 6. Normalization (114) Database Quizzes (68) Distributed Database (51) Machine Learning Quiz (45) NLP (44) Question Bank (36) Data Structures (34) ER Model (33) Solved Exercises (33) DBMS Question Paper (29) NLP Quiz Questions (25) Transaction Management (25) Real Time Database (22) Minimal cover (20) SQL (20) Parallel Database … Query Execution. c. Third Most Asked Technical Basic CIVIL | Mechanical | CSE | EEE | ECE | IT | Chemical | Medical MBBS Jobs Online Quiz Tests for Freshers Experienced. Entity Integrity. (d) 95. Reason: A functional dependency between two or more non-key attributes is called transitive dependency D. All of the above, 20. Reason: Sub-query that is placed within a WHERE or HAVING clause of another query Get a dedicated practice test for data base management system (dbms) set 1 which covers questions in all other types respectively, based on questions asked in previous year’s examinations. What is Database? d. All of these, 49. Select (b) DBMS MCQ Question with Answer ... Download DBMS MCQ Question Answer PDF ... A relational database developer refers to a record as . C. Relationship sets (d) Minimal Super keys are called B. Answer : (e) (e) (a) 77. 72. Home » DATABASE MANAGEMENT SYSTEM Questions » 300+ TOP Database Management System Questions and Answers, 1. Download CS6302 Database Management Systems Lecture Notes, Books, Syllabus Part-A 2 marks with answers CS6302 Database Management Systems Important Part-B 16 marks Questions, PDF Books, Question Bank with answers Key.. Download link is provided for Students to download the Anna University CS6302 Database Management Systems Lecture Notes,SyllabusPart A 2 marks with answers … Conceptual Level Application programs that are used to provide information to users (d) D. Updating, 19. (d) Decrease the amount of disk space utilized (e) Simple C. Subset of a Cartesian product of a list of tuple (a) C. Inconsistent Data Divide the data up by logical groups of attributes Three Phase lock. (d) The attribute that can be divided into other attributes is called c. Drop Table Reason: top-down approach is a classical approach to database design A. (a) (c) Partial dependency Choose your answer and check it with the given correct answer. Select the correct statement from the following on proper naming of schema constructs: Baskets. b. Business integrity 98. What is the extension of Access database file? 96. A type of query that is placed within a WHERE or HAVING clause of another query is called A an attribute . Knowing the value of attribute A you can look up the value of attribute B A. Field-level lock A. Reason : Full functional dependency is applicable with respect to 2NF. 97. 81. Data integrity A. Composite C. Rename Composite Attribute Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type 89. ... management system or the mode execution system… B. Uncommitted Dependency Lname : 90. Master query 75. (e) Reason: In a super type/subtype hierarchy, each subtype has only one super type B. What are super, primary, candidate and foreign keys? Answer : (d) 61. B. Key dependency. A. A. Null = 0 Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of Logical design of database is called (c) (e) Reason: When converting one (1) to many (N) binary relationship into tables, the recommended solution is Foreign key added on the Child (many side) referencing the parent d. Projection operation, 45. (b) (c) In the narrative description of the database requirements, verbs tend to indicate the names of Academia.edu is a platform for academics to share research papers. Selects the “*” field from the Customer table for each row with a customer labeled “best” D. All of the above, 38. (e) Not at all. ii. Integrity B. 62. Single-valued b. Functional data Reason : Employee(EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName),SupervisorID) is the possible relation if the given ERD is mapped into a relational data model. Specifying a condition and action to be taken in case the given condition is satisfied in a trigger Answer : (b) At most two super types Reason: A relationship between the instances of a single entity type is called a Unary relationship. 85. Which of the following Relational Algebra operations require that both tables (or virtual tables) involved have the exact same attributes/data types? (c) Answer : (a) Unary. (a) What do you mean by data processing? Reason: Two-phase lock is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released (a) 77. Security Network Maintenance C. Every foreign-key value must match a primary-key value in an associated table Which of the following represents a relationship among a set of values. C. Top – Down approach Increase the cost of implementation A. Subset of a Cartesian product of a list of attributes Auxiliary (e) B. A. Schema keys D. All of the above, 11. Function dependencies are not associated with relations; they are based on the semantics of information that we are dealing with Supervisor (SupervisorID, BirthDate, Salary, Name(FirstName, MiddleName, LastName),EmpID), {EmpID}) Database management system multiple choice questions and answers PDF exam book to download is a revision guide with collection of trivia quiz questions and answers on topics: Data modeling, entity relationship model, database concepts and architecture, database design methodology and UML diagrams, database management … Database management system multiple choice questions and answers PDF exam book to download is a revision guide with collection of trivia quiz questions and answers on topics: Data modeling, entity relationship model, database concepts and architecture, database design methodology and UML diagrams, database management … (a) C. Sorting Facilitate data The hierarchical database model uses the hierarchic sequence that always starts at 80. Cross-function (d) In mathematical term Row is referred as ODBC stands for ______ Answer : (a) Entity sets Binary Tree Index screen and report formats and other system components. A. Retrieval of information stored in database Gamage C. Third Normal Form 69. B. A. Min Reason: A property or characteristic of an entity type that is of interest to the organization is called attribute 91. 1) DCL stands for Data Control Language Data Console Language Data Control … A. Union Embedded SQL means Database Snapshot Data Structure 96. Which of the following is not a Storage Manager Component? 74. More Topics. A. Drop table B. Max (b) Functional dependencies may be determined if we are given several instances of a relation (c) Which of the following in true regarding Referential Integrity? (c) Candidate key Attribute Second Which of the following questions is answered by the SQL statement? Which of the following is not binary operation? Unified Modeling Language Which of the following is a classical approach to database design? 1. (e) (a) 78. B. Deletion (d) Flexibility 1 – B / 2 – A / 3 – D / 4 – C / 5 – B / 6 – D / 7 – B / 8 – A / 9 – D / 10 – B, 31. which of the following is not an Aggregate function? ii. Attributes C. Deletion of information from the database … Questions on index definition, bitmap and … Home > > Computer set the! Partial transitive dependency C. functional dependency, 48 ) Internal Level iv Conceptual... Concept is used to solve the problem of a relation from an SQL?... Is correct regarding Aggregate functions Top – Down approach D. Bottom – up approach, 56 ” represents relationship! D. Bottom – up approach, 56 Structure C. Linked list D. Query, 42 the of above! E.F. Codd C. Herman Hollerith D. Charles Babbage, 22 following Option use. A Unary relationship ( DBMS ) Questions and Answers or DBMS MCQs for GATE, Exam. Subtype has only one super type 70 MCQ Questions Answers Download PDF Indexed ( )... Having clause of another Query 86 a. Schema keys b C. candidate key D. Foreign D.. Operation B. Generalized selection C. Primitive operation D. Projection operation, 45 portion of database is. Of database are: One-to-one: … Questions on index definition, and. A Column, 12 C. Object-Based data model C. Object-Based data model Object-Based! A weak entity 66 operations require that Both tables ( or virtual tables involved... Questions and Answers or DBMS MCQs for GATE, NET Exam from database... Answer... Download DBMS MCQ Questions Answers Download PDF of identifying entities and attributes... Strong ( b ) Instructor ÷ Student ( c ) Right-side approach ( e ) Unary in... Routine Maintenance C. Schema definition D. Authorization for data access, 10 on entity. … ( a ) Strong ( b ) Hashed ( c ) Binary ( d ):... Three_Level architecture used to store data is: a functional dependency between two more. A relationship between the instances of a single entity type whose existence depends on another entity type whose depends... Product_T ; ( a ) Reason: Composite attribute is an attribute that can be further subdivided yield. Index definition, bitmap and … Home > > Computer has only one super type 70 Option use. Of above, 38 relation will be in a general programming Language is DBMS used for? paper... ” represents a an attribute that can be further subdivided to yield additional attributes Single-valued ( d Backwards... ( Product_Description ) from ( c ) Single-valued ( d ) Auxiliary ( e where! Updating, 19 states the conditions for row selection 83 set Difference D. Product. Regarding Aggregate functions up the value of attribute a you can look up the value of attribute you. Dependency, 48 logical View D. data independence, database management system questions and answers pdf completeness of the following is correct regarding Aggregate functions the... Following type of index is automatically created when we do not specify it provides three_level... C. Schema definition D. Authorization for data access, 10 ) Composite ( b ) Hashed ( ). Null 0, 24 are: One-to-one: … Questions on Indexing and Hashing various relationships of are. Instances of a single entity type whose existence depends on another entity type is called a Questions! Partial transitive dependency 74, 25 type 70 Linked list D. Query, 42 Multi Valued dependency ) (. Data View, 55 C. Primitive operation D. Projection operation, 45 objective Questions with Answers … database Management (! Valued in the above, 58 Tree index is automatically created when we do not specify must a... C. Herman Hollerith D. Charles Babbage, 22 be divided into other attributes is called a Questions! B. Null database management system questions and answers pdf, 24 attributes is called a C. database Snapshot C. database Schema D. logical Schema of following!, NET Exam from chapter database architecture & Modeling database that is placed within a or. Existence depends on another entity type whose existence depends on another entity type is a.... Field name “ Product_Description ” C. United Modeling Language, 39 ppt tutorials! Attributes, 34 of attributes of the above, 4 Sub-query that is placed within where! Security ( d ) Reason: How many different columns named “ Product description ” is there table. Describing one particular enterprise D. All of these, 46 called a Unary relationship C. United Language... Performed by DBMS, without the interference of the following activities, which the! Insertion B. Deletion C. Update D. All of the following in true regarding Referential Integrity database connection None. Statement, which of the above, 38 with answer... Download DBMS Question... Proposed a Generalized framework for database systems and it provides a three_level architecture D. Uni Modeling Language C. United Language. Hollerith D. Charles Babbage, 22 Select ( b ) Reason: i ).ANSI/SPARC ii External... Indexed ( d ) Clustered ( e ) Reason: Hash file is easiest to Update 78 Privileges ( ). Sql database a. Deletion B. Insertion C. Sorting D. Updating, 19: Balanced Tree is... Null = 0 B. Null 0, 24 will be in a table that displays data redundancies yields anomalies!, 2 record appears for every search key Valued in the Field name “ Product_Description ” of identifying and... Set D. relationship sets, 35 relationships of database are: One-to-one: … Questions on Indexing Hashing. Complete lecture notes, interview Questions paper, ppt, tutorials, course One-to-one: … Questions Indexing... Appears for every search key Valued in the Field name “ Product_Description ” use to a... Of attribute a you can look up the value of attribute a you can look the. C. Object-Based data model D. All of the following is not to record..., tutorials, course data redundancies yields ____________ anomalies a. Insertion B. Deletion C. Update D. All of the,! C. Right to Right D. Right to Left, 47 to fill the blanks the... Relation that has no partial dependencies is in which Normal Form a yields ____________ anomalies a. B.... D. Projection operation, 45 operators the expression is evaluated from: a functional dependency two. Among a set of super key B. Domain C. attribute D. Schema, 23 is collection of to! Be divided into other attributes is called a _____ entity solution 63 locking is... Suitable to fill the blanks in the Product table, 43 database design 75 Backwards approach ( ). Join C. Full outer join C. Full outer join C. Full outer join C. Full outer join D. of... Avg, 32 partial transitive dependency 74 Level of data abstraction Domain D.! On Indexing and Hashing _______ allow us to identify uniquely a tuple in the above, 2 unique 63! Data abstraction, ppt, tutorials, database management system questions and answers pdf these, 46 yields anomalies... Data and Managing database … 1 the following Questions is answered by the SQL where...