Database Management System – Set 3 January 28, 2025 by aasi Home › Computer Operator › DBMS DBMS Database Management System – Set 3 📝 Model Practice Set ⚡ Instant Answers & Explanation 🎯 Exam Oriented 0% Report a question What’s wrong with this question? You cannot submit an empty report. Please add some details. 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 Database Management System – Set 3 Dear ! This is Database Management System – Set 3 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) Which of the following is record based logical model ? Network Model Object oriented model E-R model None of these 2 / 50 2) A ……….. Norma form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute. First Second Third Fourth 3 / 50 3) ………. is a special type of stored procedure that is automatically invoked whenever the data in the table is modified Procedure Trigger Cursor None 4 / 50 4) To drop a column that is used as a foreign key , first : Drop the primary key Drop the table containing the foreign key Drop the foreign key constraint All of the above must be done 5 / 50 5) In DBMS , Data is presented as a collection of ………. Relation Table Attribute Entity 6 / 50 6) A key more than one attribute is called Composite key Primary key Candidate key None 7 / 50 7) Referential integrity control relationships between: Attributes in a table Operations of an object Instances of a class Table in a database 8 / 50 8) A transparent DBMS ? Keeps its physical structure hidden from users Keep its logical structure hidden from users Cannot hide sensitive information from users None 9 / 50 9) It is better to use files than a DBMS when there are Stringent real- time requirements Multiple users wish to access the data Complex relationships among data All of these 10 / 50 10) The tables generated on compilation of data definition language are stored in ? Data abstraction Data dictionary Data file Meta data 11 / 50 11) A field or a combination of fields that has a unique value is called: Foreign key Secondary key Primary key Alternate key 12 / 50 12) The level of data abstraction describes how the data is actually stored is ? Physical level Conceptual level Storage level File level 13 / 50 13) Objects based data models are used in describing the abstraction of the following levels ? Conceptual and view Only physical Physical and conceptual Only conceptual 14 / 50 14) ……….. is a full form of SQL Standered Query language Strured query language Serial query language None 15 / 50 15) In the ………… Norma form , a composite attribute is converted to individual attributes First Second Third Fourth 16 / 50 16) An attribute or set of attributes that uniquely identifies an entity is called Super key Primary key Candidate key None 17 / 50 17) In E-R Diagram relationship type is represented by Ellipse Dashed ellipse Rectangle Diamand 18 / 50 18) DBMS is a collection of ………. that enables user to create and maintain a database Key Program Translator None 19 / 50 19) Which of the following is a comparison operator in SQL ? = LIKE BETWEEN All of these 20 / 50 20) Which of the operations constitute a basic set of operations for manipulating relational data ? Predicate calculus Relational calculus Relational algebra None of these 21 / 50 21) …….. defines the structure of a relation which consists of a fixed set of attribute- domain pairs . Schema Program Instance None 22 / 50 22) The DBMS utility, ………. allows to reconstruct the correct state of database from the backup and history of transactions Backup Recovery Monitering Scankdisk 23 / 50 23) Which are the two ways in which entities can participate in a relationship ? Passive and active Total and partial Simple and Complex All of these 24 / 50 24) What SQL command will allow you to change the table STUDENT to add the constraint named Grade Check that states that the values of the Grade column must be greater than 0 ? ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0 ); ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0) ; ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0) None of these is correct 25 / 50 25) In an ER model , ………. is described in the database by storing its data . Entity Attribute Relationship Notation 26 / 50 26) Most popular commercial database Oracle My SQL MY Access PHP 27 / 50 27) Most popular commercial database Oracle My SQL MY Access PHP 28 / 50 28) The overall design of a database is called Schema of the database The screen of database Structure of the database View of the database 29 / 50 29) Related fields in a database are grouped to form? Data field Data Record Menu Bank 30 / 50 30) The DBMS acts as an interface between what two components of an enterprise- class database system? Database application and the database Data and the database The user and the database application Database application and SQL 31 / 50 31) A primary key is combined with a foreign key creates Parent – child relationship between the tables that connect them Many to Many relationship between the tables that connect them Network model between the tables that connect them None of these 32 / 50 32) Which one of the following is a direct benefit of database normalization? Higher query processing efficiency Smaller number of tables Reduced I/O for most queries Reduced data redundancy 33 / 50 33) An association of several structures of data base can be expressed graphically by ? Tuple Record Relationships Field 34 / 50 34) It is possible to define a scheme completely using VDL and DDL DDL and DML SDL and DDL VDL and DML 35 / 50 35) What rows will this select statement return ? SELECT * FROM product WHERE order number > = 1000 All rows in the products table whose order number is greatest than or equal to 1000 All rows in the products table whose order number is less than or equal to 1000 The first 1000 rows of the product table All rows in the products table whose order number is greater than 1000 36 / 50 36) The physical location of a record is determined by a mathematical formula that transform a file key into a record location is : B-Tree File Hashed File Indexed File Sequential 37 / 50 37) A file manipulation command that extracts some of the records from a file is called SELECT PROJECT JOIN PRODUCT 38 / 50 38) The ……….. operator is used to compare a value to a list of literals values that have been specified BETWEEN ANY IN ALL 39 / 50 39) Which of the following operation is used if we are interested in only certain columns of a table PROJECTION SELECTION UNION JOIN 40 / 50 40) To select all columns from the table the syntax is : Select all from table_ name Select * from table_name Select from table_name None 41 / 50 41) A DBMS query language is designed to Support end users who use English – like commands. Support in the development of complex application software. Specify the structure of a database. All of these 42 / 50 42) The level of abstraction describes only part of the entire database is called? Conceptual level View level Procedural level None of these 43 / 50 43) Which of the following products was the first to implement true relational algebra in a pc DBMS ? Oracle R:base IDMS dBase-II 44 / 50 44) In E-R Diagram relationship type is represented by Ellipse Dashed ellipse Rectangle Triangle 45 / 50 45) ……… is a virtual table that draws its data from the result of an SQL SELECT statement . View Synonym Sequence transaction 46 / 50 46) ………. requires that data should be made available to only authorized users. Security Data integrity Privacy None 47 / 50 47) A data dictionary is a special file that contains: The name of all fields in all files The width of all fields in all files The data type of all fields in all files All of these 48 / 50 48) Which SQL command can be used to delete columns from a table ? MODIFY TABLE TableName DROP ColumnName MODIFY TABLE TableName Drop ColumnName ALTER TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP ColumnName 49 / 50 49) In a relational schema , each tuple is divided into fields called Relation Domain Query All 50 / 50 50) A table joined with itself is called Join Self Join other join Equi join Your score isThe average score is 0%🎉 Challenge alert! 💡 Share this quiz with your friends and see who scores the highest! 🏆🤩🔥 LinkedIn Facebook Follow Us @ 0% Restart quiz Exit We’d love to hear your thoughts! 📝 Share your valuable review with us. 🙌 🌟 Thank you for your support! Your feedback means the world to us. 🙏💖 Send feedback
