The left side of the tree In DBMS FD stands for _______ Counts all records and displays the value. Key dependency. (d) Database Schema Snapshot of the dta in the database at a given instant of time is called (b) D. Logical Schema, 8. 1. Database tuning: The DBA is responsible for evolving the database… Computer Basics Advanced Computer Questions … External Level D a relation . Answer : (c) Adjectives written in the database requirement description help to identify the partial relationships among entities. D. Domain, 16. C. Buffer Manager (b) (b) Out of the following activities, which is the one that normally performed by DBMS, without the interference of the DBA? b. 73. B. Row-level lock (d) b. Arithmetic algebra (d) Selects fields with a “*” in them from the Customer table K is a Primary key for R1 Answer : (e) Which of the following is not correct? C. Collection of data describing one particular enterprise (e) Multi-query Nodes A. Application programs that are used to provide information to users C. Rolled Database Management System Notes Pdf – DBMS Pdf Notes starts with the topics covering Data base System Applications, data base System VS file System… Every tuple of R1 has a distinct value for K B. First 66. (d) Which of the following is Relation-algebra Operation Sujith C. Tuple Which of the following is not a level of data abstraction? B. 70. B. Null 0 Transaction Manager C. Rename Database Instance Answer : (e) (a) Reason: In an SQL statement where clause states the conditions for row selection 81. Which relational algebra operation could have been applied on the pair of relations Student and Instructor to obtain the above data? d. None of these, Answers :- 0000008079 00000 n Left – Right approach Reason : A software application that is used to define, create, maintain and provide controlled access to user databases. Physical Schema 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? iv. Selects the “*” field from the Customer table for each row with a customer labeled “best” Column header is refer as Selection operation Answer : (b) C. Deletion of information from the database (d) Instructor 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) 63. (b) Database is collection of data and Managing database … Your email address will not be published. (a) Entering a value In an Entity-Relationship Diagram “Ellipses” represents Middleware. Saved Select the correct statement from the following on proper naming of schema constructs: Decrease the amount of disk space utilized External Level D. Attribute keys, 18. Union How many different product descriptions are in the Product Table? D. Domain, 13. Which of the following is not binary operation? Bill Gates A. When converting one (1) to many (N) binary relationship into tables, the recommended solution is usually A. Which of the following is the structure of the Database? Business rule constraint (b) Answer : (d) (b) Buckets C. Set Difference Partial dependency Partial transitive dependency A transaction completes its execution is said to be 89. Balanced Tree Index Multiple partition query 90. Conceptual Level (b) Answer : (b) What does the following SQL statement do? Minimal Super keys are called 63. a. Stack 1. B. (e) A Database Management System (DBMS) is (b) trailer << /Size 821 /Info 799 0 R /Root 802 0 R /Prev 992244 /ID[] >> startxref 0 %%EOF 802 0 obj << /Type /Catalog /Pages 783 0 R /Metadata 800 0 R >> endobj 819 0 obj << /S 9009 /Filter /FlateDecode /Length 820 0 R >> stream First Normal Form 83. Right – Left approach d. Functional dependency, 48. (a) In mathematical term Row is referred as 80. ... management system or the mode execution system… Knowing the value of attribute A you can not look up the value of attribute B (c) 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 Answer : (a) (e) D. All of the above, 11. 68. Logical design of database is called 0000015984 00000 n Hewage Reason : Logical data independence refers to making a change to the conceptual schema of a database but not affecting the existing external schemas. a. Offline database connection Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName)) Reason : If k is a foreign key in a relation R1, then K is a key for some other relation. The defines the physical view of the database. Student n Instructor D. All of the above, 25. Exclusive lock (a) (d) C. Logical View (b) Which of the following is correct? (b) (e) Project A. Field-level lock Critical Level (c) Answer : (b) Derived. (e) Reason: How many different product descriptions are in the Product Table? Selects all the fields from the Customer table for each row with a customer labeled “best” ii. Answer : (c) Answer : (b) Decrease the cost of implementation. A. Insertion Instructor – Student. More Topics. Database is collection of data and Managing database … C. Attribute A. Min Attributes Project 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 … Answer : (d) C. Object-Based data model A. 1 – C / 2 – B / 3 – A / 4 – D / 5 – B / 6 – C / 7 – D / 8 – B / 9 – A / 10 – C, 41. Instructor ÷ Student Primary Consider the following table obtained using Student and Instructor relations. Difficulty in accessing data D. Multi-valued attributes, 34. (a) (d) D. Foreign key, 52. b. Generalized selection (e) (c) Answer : (c) Sequential Unary. (b) C. Top – Down approach C. Domain keys (b) 1 3. Reason: Knowing the value of attribute A you can look up the value of attribute B. (a) d. None of these, 46. B. Tuple A lock that allows concurrent transactions to access different rows of the same table is known as a Granting the Privileges A. Subset of a Cartesian product of a list of attributes Ans: A super key is a set of attributes of a relation schema upon which all attributes of the schema are functionally dependent. Strong Which of the following in true regarding Referential Integrity? Answer : (b) A. Sub query State the unit of storage that can store one or more records in a hash file organization Reason : In the narrative description of the database requirements, verbs tend to indicate the names of relationship types. Answer : (a) 65. Which of the following is correct regarding Aggregate functions? 82. B. E.F. Codd D. Domain, 15. The property of transaction which ensures that either all operations of the transaction are reflected properly in the database or none, is called C a criteria . (c) The hierarchical database model uses the hierarchic sequence that always starts at (a) The bottom of the tree 62. (e) (c) Foreign key added on the Child (many side) referencing the parent Alter Table Which of the following concept is applicable with respect to 2NF? 100 top DBMS multiple choice questions and answers PDF for freshers and experienced. D. it takes a single value and returns a single value as result, 29. d. Fourth, 50. Parallel query processing Codependent C. Relation C. Deletion of information in the Database Data redundancy and inconsistency iv. Reason: Function dependencies are not associated with relations; they are based on the semantics of information that we are dealing with. 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. B. Questions 81 To 90 D. Tables, 5. Reason: A null value is created or represented by Pressing the Enter key without making a prior entry of any kind (a) (d) (a) Hashed 91. Download Database Management Systems Notes, PDF [2021] syllabus, books for B Tech, M Tech, BCA. Lost Update Peiris Which of the following option is use to retrieval of data? Table Non-transitive dependency What is Database Management System (DBMS)? Two phase lock Partial functional dependency (c) b. Collection of interrelated data 94. Query Execution. 64. If an object only requires an identifier, it should be classified as an attribute 0000014428 00000 n Consistency A. (a) 77. (b) Divide the data up by logical groups of entities A. (b) Answer : (b) Answer : (a) DBMS Objective type Questions and Answers List. K is a key for some other relation Isolation (e) Writing a SQL statement to retrieve data from more than one relation (e) (a) 87. (a) In an SQL statement, which of the following parts states the conditions for row selection? 83. (c) Which of the following represents a relationship among a set of values. b. (c) Answer : (a) A. Super key Answer : (d) 100. (b) D. Schema, 23. (e) d. Query, 42. (e) C. Sorting D. All of the above, 26. Academia.edu is a platform for academics to share research papers. Which of the following is not Modification of the Database 0000012886 00000 n One big table with all attributes from both entities included relationship types Independent. B. (e) (a) Record controller Flexibility K is a Composite key for R1. Data Manipulation Language Which of the following is not Unary operation? A database management software (DBMS) includes Secondary index 88. Provide rapid, random and sequential access to base-table data (c) Required fields are marked *. The defines the logical schema of the database.” Repository of meta data, which is a central storehouse for all data definitions, data relationships, B. Disk pages (e) C. Query Language Data independence. A property or characteristic of an entity type that is of interest to the organization is called an D. All of the above, 7. We are answering all the questions on the database … (b) Recovery. Writing SQL statements within codes written in a general programming language (a) A. it takes a list of values and return a single values as result None of the above. (c) (d) The procedure of identifying entities and attaching attributes always leads to a unique solution The minimal set of super key is called 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 … First Foreign key added on both sides (both tables) b. Functional data Choose your answer and check it with the given correct answer. “In 1978 committee proposed a generalized framework for database systems and it provides a three_level architecture. Top-down approach Secondary key A. Disadvantages of File systems to store data is: (c) Data Structure A. Schema keys (a) Multi-valued Security (a) Database Management System (DBMS) Questions and Answers . Foreign key added on the Parent (one side) referencing the child Hashed C. Subset of a Cartesian product of a list of tuple 73. A space C. Table-level lock Integrity Candidate keys D. View Level, 3. (c) 96. B. 99. (c) A ________ attribute is an attribute that can be further subdivided to yield additional attributes. For database systems and it provides a three_level architecture associated table b C. Herman Hollerith D. Charles Babbage,.... Is automatically created when we do not specify Simple ( c ) Security ( d ) Group by ( )!, 10 complete lecture notes, interview Questions paper, ppt, tutorials, course to. Correct answer … ( a ) Reason: Full functional dependency between two or more records in a,... Manager, 6 C. Both D. None of above, 26 data C. facilitate dependency D. partial functional dependency 54... C. Linked list D. Query, 42 attribute b ) Backwards approach ( b ) Reason: the of! To identify uniquely a tuple in the Field name “ Product_Description ”, 58 is said to a! Key is called a its execution is said to be a and … Home > Computer... Single entity type is called a None of above, 2 up logical... Yields ____________ anomalies a. Insertion B. Deletion C. Update D. All of the following database management system questions and answers pdf to... Top-Down approach is a set of premitted values of each attribute is an attribute that be. Left to Right D. Right to Right C. Right to Right D. Right Left! Question with answer... Download DBMS MCQ Question with answer... Download DBMS MCQ Questions Download. Level iv ) Conceptual Level 98 Schema upon which All attributes of the following is a!: Top-down approach is a a Field D. a Column, 12 Codd C. Hollerith! Domain C. attribute D. Schema, 17 Questions paper, ppt, tutorials, course …! D. All of these, 46, 22 transaction completes its execution is to. Subdivided to yield additional attributes premitted values of each attribute is called as a connection D. None above... Database Schema D. logical Schema of the above, 9 keys D. attribute keys, 18 dependency.! Select 82 list D. Query, 42, 2, 55 following concept is used to store one or non-key! B. tuple C. relation D. Schema, 17 a View can be helpful a... There is a classical approach to database design search key Valued in the Field name “ Product_Description?. _______ allow us to identify uniquely a tuple in the relation will be in general. D. Projection operation, 45, 23 to retrieval of data abstraction Normal. Dbms MCQs for GATE, NET Exam from chapter database architecture & Modeling: a parts! Or more non-key attributes is called a Unary relationship, 30 many different Product descriptions are in database... B. Insertion C. Sorting D. Updating, 19 a _____ entity, tutorials, course time is called a. dependency... D. functional dependency is applicable with respect to 2NF the logical Schema, 23 key B. Domain C. D.! Instance C. database Schema D. All of the database Schema of the above, 58 entity set relationship... ) External Level iii ) Internal Level iv ) Conceptual Level 98 normally performed by,... ) Single-valued ( d ) Group by ( d ) Auxiliary ( e Recovery. Sql Query is use to remove a table C. Drop table D. None of above, 4 a. B.... A. super key is a a single entity type is called a data... Offline database connection b following type of index is automatically created when we not... Table name > b table obtained using Student and Instructor relations database D.. The data in a database attribute keys, 18 D. Foreign key D. Foreign key D. Foreign,... To remove a table to identify uniquely a tuple in the database completes its execution said. Bottom – up database management system questions and answers pdf, 56 Divide the data in a general programming Language that displays redundancies! Buffer Manager D. file Manager, 6 suitable to fill the blanks in the file 39... Regarding Referential Integrity All attributes of a single entity type is called a _____ relationship respect to 2NF to?... Sql refers to the correctness and completeness of the following activities, which is the Structure of the in! - DBMS Trivia Questions and Answers PDF there is a classical approach to database 75!: One-to-one: … Questions on index definition, bitmap and … Home > > Questions > > Computer System... Architecture defines user views of the following is correct regarding Aggregate functions following concept is used to data... … Questions on index definition, bitmap and … Home > > Computer Questions... Variant ( e ) Derived the DBA the conditions for row selection 83 hierarchy... Manager C. Buffer database management system questions and answers pdf D. file Manager, 6 placed within a where or clause! Interference of the following is a set of values PDF... a Relational developer! Single entity type is called transitive dependency b ) Unary approach C. –... Name > b Projection operation, 45, 35 many characters are in the Product table, 8 E.F. C.... Description of some portion of database are: One-to-one: … Questions on index,... Database. ” which of the above, 21. who proposed the Relational model functional. – Instructor ( b ) Hashed ( c ) Student n Instructor ( b ) Reason: many... Relationship sets, 35 constraint D. data independence, 57 said to be a man-agement! Indexing and Hashing PDF... a Relational database developer refers to writing SQL within..., without the interference of the following is not a function of DBA data and Managing …! Clause states the conditions for row selection 83 dependent on the primary key C. Foreign key D. All of following., 20 1 ) What is DBMS used for? into other attributes is called as a a! Composite attribute C. Multi-valued attribute D. Derived attribute, 33 selection C. Primitive operation D. Projection operation,.! Applicable with respect to 2NF the mode execution system… database Management System ( )! Type whose existence depends on another entity type is called as a yield additional attributes B. Multi-valued attributes,.! C. Inconsistent data D. All of the database of the following type of index is automatically created when we not. Data in a general programming Language C. Select D. Avg, 32 exact same attributes/data types be divided into attributes! Is time stamp ordering protocol of identifying entities and attaching attributes always leads to a Privileges ( )! ) Top-down approach ( c ) How many different Product descriptions are in the Product?. Relationship among a set of values committee proposed a Generalized framework for database systems and it a... Existence depends on another entity type is called transitive dependency b to learn about the database following a... These, 46 written in a general programming Language database that is required by a user perform. Table that displays data redundancies yields ____________ anomalies a. Insertion B. Deletion C. Update D. of!: How many different Product descriptions are in the Field name “ Product_Description ”: One-to-one …... Gate, NET Exam from chapter database architecture & Modeling a _____ relationship Null 0, 24 system… database System. ” which of the following in not a Storage Manager Component … ( )! Iii ) Internal Level iv ) Conceptual Level 98 hierarchy, each subtype has only one type! Operators the expression is evaluated from: a data and Managing database … 1 MCQ Question with answer Download... Schema are functionally dependent on the primary key C. Foreign key, relation! Key is a classical approach to database design b ) How many different columns named “ description... Sql database a. Delete table < table name > b and completeness of the DBA partial is... One-To-One: … Questions on Indexing and Hashing D. All of the database database are: One-to-one: Questions! ( d ) How many products are in the above, 21. who proposed the Relational?! Us to identify uniquely a tuple in the Product table to retrieval of data non-key attributes called... Attributes C. weak entity set D. relationship sets, 35, 6, 44 Codependent. The Schema are functionally dependent do not specify with the given correct answer codes in... Attributes of a single entity type is called a _____ relationship has only one type... Many different Product descriptions are in the Product table above paragraph Uncommitted dependency Inconsistent! Attribute C. Multi-valued attribute D. Derived attribute, 33 Query, 42 codes written a... Gates B. E.F. Codd C. Herman Hollerith D. Charles Babbage, 22 operations require that Both (. The Schema are functionally dependent on the primary key, the relation will be in a database ) Composite b! It provides a three_level architecture to learn about the database Composite attribute is an attribute can! C. candidate key D. All of the following is correct regarding Aggregate functions from ( ). Table that displays data redundancies yields ____________ anomalies a. database management system questions and answers pdf B. Deletion Update! Accessing data C. collection of data a record as of another Query 86 more non-key attributes is called _____... D. Schema, 8, 37 values of each attribute is an attribute that can be further subdivided yield! Quiz objective Questions with Answers … database Management System or the mode execution database! All the candidates who want to learn about the database at a given instant of time is called a. B.. Data up by logical groups of records only one super type 70 Full outer C.! Different Product descriptions are in the Product table each attribute is functionally dependent on the primary key,.. Level C. logical Level D. View Level, 3 uniquely a tuple in the above,.. Mcq Question answer PDF... a Relational database developer refers to a solution... In true regarding Null value about database management system questions and answers pdf database columns named “ Product description ” is in. Performed by DBMS, without the interference of the following in true regarding Null value following is not Level.