Database Management System – Set 4 January 28, 2025 by aasi Home › Computer Operator › DBMS DBMS Database Management System – Set 4 📝 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 4 Dear ! This is Database Management System – Set 4 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) Which of the following database object does not physically exist ? Base table Index View None of these 2 / 50 2) This family of products is IBM’s cross – platform relational database management system. DBA DB2 PHP RDF 3 / 50 3) E- R model uses this symbol to represent weak entity set ? Dotted rectangle Diamond Doubly outlined rectangle None of these 4 / 50 4) This is an open standard application programming interface (API) for accessing a database. Universal Data Access Open Database Connectivity Topic Map Query language Open Data-Link Interface 5 / 50 5) In case of entity integrity , the primary key may be not Null Null Both Null & Not Null Any value 6 / 50 6) ‘AS’ clause is used in SQL for Selection operation Rename operation Join operation Projection operation 7 / 50 7) For which two constraints are indexes created `when the constraint is added ? a. Primary key b. Unique c. Not null d. Both (a) and (b) 8 / 50 8) DBMS helps to achieve a. Data independence b. Centralized control of data c. Both (a) and (b) d. None 9 / 50 9) The view of total database content is Conceptual view Internal view External view None 10 / 50 10) The database environment has all of the following components except : User Separate files Database Database administrator 11 / 50 11) Which privilege is required to create a database ? SYSDBA DBA SYSOPER RESOURCE 12 / 50 12) When is the SGA created in an oracle database environment ? When the database is created When a user process is started when the database is mounted when the instance is started 13 / 50 13) A relational database developer refers to a record as A criteria A relation A tuple An attribute 14 / 50 14) DML is provided for Description of logical structure of database Addition of new structures in the database system Manipulation & processing of database system Definition of physical structure of database system 15 / 50 15) The statement in SQL which allows to change the definition of a table is Alter Update Create Select 16 / 50 16) Which are the physical structures that constitute the oracle database ? control file Log file Log file All of the these 17 / 50 17) Which of the following is another name for week entity ? Child Owner Dominant All of these 18 / 50 18) The conceptual model is dependent on hardware dependent on software dependent both on hardware and softawre independent of both hardware and software 19 / 50 19) ………………… produces the relation that has attributes of R1 and R2 Cartesian product Difference Intersection product 20 / 50 20) This is a collection of descriptions about data objects that is created for the benefit of programmers and others who might need to refer to them data dictionary stored procedure Virtual File Allocation table catalog 21 / 50 21) Which database level is closed to the users ? External Internal Physical Conceptual 22 / 50 22) Which of the following is valid SQL type ? CHARACTER NUMERIC FLOAT All of these 23 / 50 23) Which type of file is part of the oracle database ? Control file Password file Parameter Archived log file 24 / 50 24) In an E-R diagram an entity set is represent by a The data definition language (DDL) The data manipulation language (DML) The data manipulation administrator (DBA) A query language 25 / 50 25) This is a collection of data items organized as a set of formally – described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables . relational database array file allocation table splay tree 26 / 50 26) In the relational modes , cardinality is termed as : Number of tuples Number of attributes Number of tables Number of constraints 27 / 50 27) In a Hierarchical model records are organized as Graph List Links Tree 28 / 50 28) What type of failure occurs when oracle fails due to an operating system or computer hardware failure ? Application failure Instance Failure Media failure Rollback failure 29 / 50 29) SET concept is used in : Network Model Hierarchical Model Relational Model None of these 30 / 50 30) In creating a database , this is the process of organizing it into tables in such a way that the results of using the database are always unambiguous . probability normalization data modeling query by example 31 / 50 31) Which statements are used to UNLOCK the user ? Alter user Scott account lock; Modified user Scott account unlock; Alter user Scott account unlock Alter user Scott unlock 32 / 50 32) ………….. data type can store unstructured data RAW CHAR NUMERIC VARCHAR 33 / 50 33) Count function in SQL return the number of values Distinct values Groups Columns 34 / 50 34) In an E-R diagram environment has all of the following components except : rectangle Square Ellipse Triangle 35 / 50 35) What is the type of oracle backup in which all uncommitted changes have been removed from the Data files ? Full backup Consistent backup Inconsistent backup Differential backup 36 / 50 36) ODBC stands for Object Database Connectivity Oral Database Connectivity Oracle Database Connectivity Open Database Connectivity 37 / 50 37) In the relational models , cardinality is termed as : Number of tuples Number of attributes Number of tables Number of constraints 38 / 50 38) Key to represent relationship between tables is called primary key Secondary key Foreign key None of these 39 / 50 39) Which of the following is an advantage of view ? Data security Derived columns Hiding of complex queries All of these 40 / 50 40) A subschema expresses The logical view the physical view the external view all of these 41 / 50 41) Relational calculus is a procedural language Non-procedural language Data definition language High level language 42 / 50 42) The language which has recently become the de-facto standard for interfacing application programs with relational database system is Oracle SQL DBase None 43 / 50 43) The method of access which uses key transformation is known as Direct Hash Random Sequential 44 / 50 44) In a relation a. Ordering of rows is immaterial c. No two rows are identical c. Both (a) and (b) d. None of these 45 / 50 45) An advantage of the database management approach is Data is dependent on programs Data redundancy increases Data is integrated and can be accessed by multiple programs None 46 / 50 46) The language used in application programs to request data from the DBMS is referred to as the DML DDL VDL SDL 47 / 50 47) Which of the following are the properties of entities ? Groups Table Attributes Switchboards 48 / 50 48) Relational calculus is a procedural language Non-procedural language Data definition language High level language 49 / 50 49) A set of possible data values is called Attribute Degree Tuple Domain 50 / 50 50) Which two files are used during operation of the DBMS ? Query language and utilities DML and query language Data dictionary and transaction log Data dictionary and query language 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
