Q1. Which of the following constraints enforces entity integrity?
- A.PRIMARY KEY
- B.FOREIGN KEY
- C.CHECK
- D.NOT NULL✓ Correct
Q2. A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
- A.strong
- B.weak✓ Correct
- C.business
- D.relationship
Q3. A ______ is used to maintain a connection between the users of the database system.
- A.Mail server
- B.File Server✓ Correct
- C.Client-server
- D.None of the given.
Q4. Which of the following most certainly implies the need for an entire table to implement?
- A.A binary relationship
- B.A ternary relationship✓ Correct
- C.A recursive relationship
- D.An identifying relationship
Q5. A collection of concepts that can be used to describe the structure of a database
- A.Database
- B.DBMS
- C.Data model✓ Correct
- D.Data
Q6. Incase of Context-level Diagram, the system is represented by
- A.One process atleast✓ Correct
- B.Two processes atleast
- C.One process only
- D.Any number of processes
Q7. User rights information is stored in
- A.Physical database
- B.Catalog✓ Correct
- C.Logical database
- D.Buffer
Q8. A description on a particular collection of data using the given data model
- A.Database
- B.Schema✓ Correct
- C.None of the above.
- D.Relation
Q9. Which of the following is NOT a component of a DFD?
- A.Dataflow
- B.Datastore
- C.External entities
- D.Relationship between external entities✓ Correct
Q10. Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
- A.User accessible catalog
- B.Data processing
- C.Authorization service
- D.Recovery service✓ Correct
Q11. Which of the following is correct regarding Dataflow diagram?
- A.Single DFD is required to represent a system
- B.The dataflow must be bidirectional
- C.Created at increasing levels of detail✓ Correct
- D.Used to represent the relationships among the external entities
Q12. Controlling redundancy in a database management system DOES NOT help to
- A.avoid duplication
- B.avoid unnecessary wastage of storage space
- C.avoid unauthorised access to data✓ Correct
- D.avoid inconsistency among data
Q13. Which of the following concepts is applicable with respect to 3NF?
- A.Full functional dependency
- B.Any kind of dependency
- C.Transitive dependency✓ Correct
- D.Partial functional dependency
Q14. Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?
- A.Join✓ Correct
- B.Union
- C.Cartesian Product
- D.Set Difference
Q15. Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
- A.Physical data independence.
- B.Concurrency control
- C.Logical data independence.✓ Correct
- D.Functional dependency
Q16. Which of the following statements is true about the views?
- A.view is always a complete set of all the tables in a database
- B.View can not be used for retrieving data
- C.The results of using a view are not permanently stored in the database.✓ Correct
- D.Rows can not be updated or deleted in the view
Q17. Which of the following is not one of the properties of Transaction?
- A.atomicity
- B.consistency
- C.redundancy✓ Correct
- D.durability
Q18. Which of the following is INCORRECT about VIEWS?
- A.It is not possible to left out the data which is not required for a specific view.✓ Correct
- B.A database view displays one or more database records on the same
- C.Views can be used as security mechanisms
- D.Views are generally used to focus the perception each user.
Q19. Each course section is assigned a particular faculty member, and each course section corresponds to a particular course. Conceptually, what is the relationship between faculty and course (not course section).
- A.1:1
- B.1:M
- C.M:M✓ Correct
- D.Ternary
Q20. Which of the following is used to add or drop columns in an existing table?
- A.ALTER✓ Correct
- B.HAVING
- C.SELECT
- D.THEN
Q21. Which of the following is a correct way of selecting all the columns from a table called PERSONS?
- A.SELECT FROM * Persons
- B.SELECT * FROM Persons✓ Correct
- C.SELECT * WHERE Persons
- D.SELECT WHERE * Persons
Q22. Which of the following is NOT a feature of Indexed sequential files?
- A.Records are stored in sequence and index is maintained.
- B.Dense and nondense types of indexes are maintained.
- C.Track overflows and file overflow areas can not be ensured.✓ Correct
- D.Cylinder index increases the efficiency
Q23. Consider the given relations Student and Instructor as given below. Please note that Fname and Lname also denote the First Name and Last Name respectively. Which of the following statements is correct with respect to the two relations given above?
- A.The two relations are not union-compatible since their attribute names differ.✓ Correct
- B.The two relations are union-compatible since they have the same type of tuples.
- C.The set operations such as CARTESIAN PRODUCT and DIVISION can be pplied on these two relations.
- D.To find out the students who are not instructors, it is necessary to perform the operation
Q24. Student ÷Instructor. 86. Which of the following serves as a milestone or reference point in the log file?
- A.Constraints
- B.Relations
- C.Check points✓ Correct
- D.Triggers
Q25. Which of the following are the general activities, which are performed during the developmentof application programs?
- A.Data input programs
- B.Editing
- C.Display
- D.All of given✓ Correct
Q26. Browser based forms are developed in the following tools EXCEPT
- A.HTML
- B.Scripting language
- C.Front
- D.Web-based Forms✓ Correct
Q27. Which of the following is not a form of optical disk?
- A.CD ROM
- B.WORM
- C.Erasable Optical
- D.EEPROM✓ Correct
Q28. Only one type of constraint can be enforced in any table by CREATE command
Q29. Which of the following is disadvantage of chaining technique to handle the collisions?
- A.Unlimited Number of elements
- B.Fast re-hashing
- C.Overhead of multiple linked lists✓ Correct
- D.Maximum number of elements must be known
Q30. An entity can be logically connected to another by defining a ____.
- A.hyperlink
- B.common attribute✓ Correct
- C.primary key
- D.superkey
Q31. You can’t modify more than one table at a time through a view.
Q32. Which of the following is one of the purposes of using DML commands?
- A.Creating databases
- B.Destroying databases
- C.Inserting data in tables✓ Correct
- D.Non of the above
Q33. What is the alternate name of Data Dictionary?
- A.Index
- B.Metadata
- C.Data
- D.System Catalog✓ Correct
Q34. IN function helps reduce the need to use multiple AND conditions.
Q35. Which of the following is not true about De-normalization?
- A.It is the process of attempting to optimize the performance of a database
- B.De-normalization is a technique to move from lower to higher normal forms of database modeling✓ Correct
- C.It enhances the performance of DB
- D.In de-normalization it is required to add redundant data
Q36. Which of the following gives all the fields from employee table named as EMP?
- A.SELECT * from EMP;✓ Correct
- B.SELECT emp* from EMP'
- C.SELECT emp_id where EMP;
- D.SELECT * where EMP;
Q37. Which of the following types of partitioning reduces the chances of unbalanced partitions?
- A.Vertical
- B.List
- C.Hash✓ Correct
- D.Range
Q38. While recovering data, which of the following files does a recovery manager examines atfirst?
- A.A system file
- B.Log file✓ Correct
- C.Data dictionary
- D.Metadata
Q39. Laser records data by burning microscopic holes in the surface of the disk with a
- A.Hard disk
- B.RAM
- C.Optical disk✓ Correct
- D.Floppy disk
Q40. Which of the following is NOT a feature of a good interface?
- A.Consistency
- B.Process based
- C.Data structure based✓ Correct
- D.User friendly
Q41. Clickhere for detail 111. Which key word is available in SQL to enforce referential integrity?
- A.Check
- B.Primary Key✓ Correct
- C.Set Default
- D.Unique
Q42. How many clustered index(es) do each database table have?
Q43. Which of the following is true about DELETE command?
- A.is DDL Command.
- B.Resets identity of the table
- C.cannot activate a trigger
- D.Can be Rolled back✓ Correct
Q44. Which of the following is not a feature of TRANSACTION?
- A.Users should be able to regard the execution of each transaction as atomic.
- B.Each transaction, run by itself.
- C.must preserve the consistency of the database
- D.dependant on other concurrent transactions✓ Correct
Q45. Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI?
- A.SELECT * FROM CUST WHERE last_name='ALI';✓ Correct
- B.SELECT * FROM CUST WHERE last_name=ALI;
- C.SELECT * FROM CUSTOMER WHERE name=ALI;
- D.SELECT * FROM CUSTOMER WHERE last_name=ALI;
Q46. Which of the following is incorrect with respect to indexed sequential files?
- A.New records are added to an overflow file
- B.Record in main file that precedes it is updated to contain a pointer to the new record
- C.The overflow is merged with the main file during a batch update
- D.Multiple indexes for the same key field cannot be setup✓ Correct
Q47. DML commands are used for:
- A.inserting data into databases✓ Correct
- B.creating databases
- C.destroying databases
- D.creating DB objects
Q48. Identify the correct statement.
- A.Entity integrity constraints specify that primary key values can be composite.
- B.Entity integrity constraints are specified on individual relations.✓ Correct
- C.Entity integrity constraints are specified between weak entities.
- D.When entity integrity rules are enforced, a tuple in one relation that refers to another relation must refer to an
Q49. The main memory of a computer system is also known as
- A.ROM
- B.RAM✓ Correct
- C.PROM
- D.Hard disk
Q50. Which of the following will be deleted relating to a table if you use TRUNCATE command?
- A.all rows in a table✓ Correct
- B.indexes
- C.table structure and its columns
- D.constraints
Q51. Which of the following is not true about relational tables?
- A.Column values are of the same kind.
- B.Each row is unique.
- C.Each column must have a unique name.
- D.The sequence of rows is significant.✓ Correct
Q52. What is the maximum limit of keys in context with Indexed sequential files?
- A.7
- B.255✓ Correct
- C.1
- D.235
Q53. Which of the given techniques is/are used to improve query performance in database?
- A.Good File organization
- B.Indexing✓ Correct
- C.Both Indexing and Good File organization
- D.Select only one record per query
Q54. Partitions may become unbalanced in:
- A.Range partitioning✓ Correct
- B.Hash partitioning
- C.List partitioning
- D.Vertical partitioning
Q55. ALTER TABLE exams ALTER COLUMN Q_description varchar(50) Syntax of ALTER TABLE isNOT correct.
Q56. In which of the following, Materialized Views are suitable
- A.Data warehousing
- B.Decision support
- C.Mobile computing
- D.All of the Given✓ Correct
Q57. A software package designed to store and manage databases
- A.Database
- B.DBMS✓ Correct
- C.Data model
- D.Data
Q58. A superkey that does not contain a subset of attributes that is itself a superkey is called a .
- A.candidate key✓ Correct
- B.primary key
- C.superkey
- D.secondary key
Q59. A relationship exists when an association is maintained within a single entity.
- A.unary✓ Correct
- B.ternary
- C.binary
- D.weak
Q60. Which of the following is NOT one of the ways of resolving deadlocks?
- A.Undoing all the updates made by the particular transaction which is the cause of deadlock.
- B.A message is passed to the victim and depending on the system the transaction may or may not be
- C.Picking a list of all previously completed transactions and undoing all the updates.✓ Correct
- D.Rollback `victim' transaction and restart it.
Q61. Which of the following statements are Data Definition Language command?
- A.INSERT
- B.UPDATE
- C.GRANT
- D.TRUNCATE✓ Correct
Q62. Suppose there are 4 rows and 3 columns in TABLE1 and 6 rows and 5 columns in TABLE2; what is the size of the Cartesian product incase of CROSS JOIN between these two tables?
- A.24✓ Correct
- B.20
- C.18
- D.15
Q63. Which of the following is one of the purposes of using DDL commands?
- A.inserting records into databases
- B.updating records into databases
- C.manipulating databases
- D.creating and destroying databases✓ Correct
Q64. What is the impact of setting multiple indexes for the same key, in index sequential files?
- A.Multiple indexes for the same key can not be set
- B.It increases efficiency✓ Correct
- C.It decreases efficiency
- D.It will increase complexity as the access time will be increased
Q65. Consider a transaction which includes following operations Z= Z + 10 Write Z ... Suppose that the value of Z after addition and the execution of this operation is 17. Now against the write operation the entry made in the log file will be What does Z reflects in the above entry?
- A.Object being updated✓ Correct
- B.Identity of the transaction
- C.Object value
- D.Identity of the next transaction to be executed
Q66. Which of the following is not true regarding DB transactions?
- A.A set of database operations that are processed partly✓ Correct
- B.A database transaction is a logical unit of database operations
- C.A database transaction must be atomic
- D.A database transaction must contains the ACID property
Q67. Which of the following is not true about input forms?
- A.Provide an easy, effective, efficient way to enter data into a table
- B.Especially useful when the person entering the data is not familiar with the inner workings
- C.Provide different controls to add data into the tables
- D.One input forms can populate one table at a time✓ Correct
Q68. Which of following is NOT generally the aim of data partitioning and placement of data?
- A.Reduce Workload
- B.Balance Workload
- C.Merging different relations✓ Correct
- D.Speed up rate of useful works.
Q69. Which of the following is Advantage of Re-Hashing technique to handle the collisions?
- A.Collisions don’t use primary table space
- B.Unlimited number of elements
- C.Fast access through use of main table space✓ Correct
- D.Overhead of multiple linked lists
Q70. Materialized views and Indexes are NOT similar by the following way(s).
- A.They consume storage space
- B.They must be refreshed when the data in their master tables changes.
- C.They can be accessed directly using a SELECT statement✓ Correct
- D.All of the Given
Q71. Who is responsible for authorizing access to the database, for coordinating andmonitoring its use ?
- A.Database Designers
- B.Database Administrators✓ Correct
- C.End Users
- D.Application Programmers
Q72. Which of the following SQL keywords is not used with DDL statements?
- A.Table
- B.Update✓ Correct
- C.Create
- D.Alter
Q73. Identify the constraint that limits the values that can be placed in a column.
- A.NOT NULL
- B.CHECK✓ Correct
- C.FOREIGN KEY
- D.UNIQUE
Q74. Which of the following enforces a relation into 1st normal form?
- A.The domain of attribute must include only atomic values.✓ Correct
- B.Every non-key attribute is fully functionally dependent on primary key
- C.non-key attribute is non-transitively dependent on primary key.
- D.Every non-key attribute is partially dependent on super key
Q75. Which of the following is NOT a feature of HASH ACCESS?
- A.indexes to search or maintain✓ Correct
- B.Very fast direct access
- C.Inefficient sequential access
- D.Use when direct access is needed, but sequential access is not.
Q76. Which of the following is true about application programs?
- A.develop before the database design
- B.Tools selection is made after the development database
- C.meant to perform different operations by the user✓ Correct
- D.must to design before the designing and developing database
Q77. Which of following is not the feature of Indexes?
- A.consume storage space.
- B.must be refreshed when the data in their master tables changes
- C.improve the performance of SQL execution when they are used for query rewrites
- D.can be accessed directly using a SELECT statement✓ Correct
Q78. Which of the following is not a type of user interface?
- A.Graphical User Interface (GUI)
- B.Forms
- C.DB tables✓ Correct
- D.Text based
Q79. In SQL queries, while creating tables or relations in database, key columns may be specified by
- A.Data type
- B.Null
- C.Not Null✓ Correct
- D.Owner
Q80. The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
- A.specialization✓ Correct
- B.uniqueness
- C.inheritance
- D.completeness
Q81. In a conceptual model for a university, what type of relationship exists between Grade and Student entities?
- A.1:1
- B.1:M✓ Correct
- C.M:M
- D.Ternary
Q82. Which of the following should not be a property of a database transaction?
- A.Atomicity
- B.Isolation
- C.Durability
- D.Divergence✓ Correct
Q83. Consider the following diagram depicting a kind of a relationship type where X and Z are entities and Y is a relationship type: Select the correct statement among the following on the above diagram.
- A.The relationship type Y is of cardinality ratio 1 : N✓ Correct
- B.The diagram depicts existence dependencies.
- C.The participation of X in the Y relationship type is total.
- D.The participation of Z in the Y relationship type is partial.
Q84. Identify the correct statement about ANSI/SPARC architecture.
- A.The external level is not concerned with individual user perceptions
- B.The internal level, in a database system, will always be relational
- C.Any given database has exactly one conceptual schema and one physical schema, but it may have several
- D.A data definition language is used to define the internal schema.✓ Correct
Q85. Identify the advantage of DELETE command over TRUNCATE.
- A.Can be Rolled back.✓ Correct
- B.is DDL Command.
- C.cannot activate a trigger.
- D.faster and uses fewer system
Q86. Which of the following statements are Data Manipulation Language command?
- A.INSERT✓ Correct
- B.GRANT
- C.TRUNCATE
- D.CREATE
Q87. In which of the following situations, Clustering is suitable:
- A.Frequently updating
- B.Relatively static✓ Correct
- C.Relatively deletion
- D.Relatively dynamic
Q88. DML stands for _____________.
- A.Dynamic Modeling Language
- B.Data Manipulation Language✓ Correct
- C.Data Management Language
- D.Domain Modeling Language
Q89. INSERT INTO statement is used to enter values into__________.
- A.Not null columns only
- B.Only particular column
- C.All columns✓ Correct
- D.Key value columns only Correct
Q90. From the following options, choose the correct statement for the third normal form.
- A.Non-key attribute is dependent on another non-key attribute.
- B.There is partial dependency in the relation.
- C.There is redundant data in the relation.
- D.No non-key attribute is dependent on another non-key attribute. Correct✓ Correct
Q91. If a relation is not in third normal form, then anomalies are due to ________.
- A.Partial dependency
- B.Transitive dependency✓ Correct
- C.Reflexive dependency
- D.Full functional dependency Correct
Q92. ___________ SQL statement is used to enter values into columns.
- A.ENTER INTO
- B.INSERT TOP
- C.PUT INTO
- D.INSERT INTO Correct✓ Correct
Q93. A relation is in third normal form if ________.
- A.It is already in second normal form.
- B.It has multivalued attributes.
- C.It has a partial dependency.
- D.It has a transitive dependency. Correct✓ Correct
Q94. Which of the following is NOT related to the basic SELECT statement?
- A.FROM
- B.SELECT
- C.WHERE
- D.NOT NULL Correct✓ Correct
Q95. A transitive dependency occurs when _________.
- A.Part of the key is dependent on a key attribute.
- B.Non-key attribute is dependent on another non-key attribute.✓ Correct
- C.Non-key attribute is not dependent on another non-key attribute.
- D.Primary key attribute is dependent on a non-key attribute. Correct
Q96. Which of the following is the correct syntax for creating a database table?
- A.CREATE MYSQL TABLE name;
- B.CREATE TABLE name;✓ Correct
- C.CREATE TABLE;
- D.TABLE name CREATE; Correct
Q97. __________ is a DML command.
- A.SELECT✓ Correct
- B.CREATE
- C.ALTER
- D.DROP Correct
Q98. Which of the following is true about TRUNCATE?
- A.Can be Rolled back.
- B.Activates Triggers.
- C.is DML Command.
- D.Resets identity of the table.✓ Correct
Q99. Which of the following serves as a milestone or reference point in the log file?
- A.Constraints
- B.Relations
- C.Check points✓ Correct
- D.Transactions identities
Q100. Which of the following is the correct description of cache hit?
- A.When data is found in the cache✓ Correct
- B.When data is removed in the cache
- C.The number of times the cache is accessed directly by the processor
- D.When data is lost from the cache
Q101. Which key word is available in SQL to enforce referential integrity?
- A.Check
- B.Primary Key✓ Correct
- C.Set Default
- D.Unique
Q102. Identify the correct statement with respect to normalization.
- A.Normalization is a formal technique that can be used only at the starting phase of the database design.
- B.Normalization can be used as a top-down standalone database design technique. for✓ Correct
- C.The process of normalization through decomposition must achieve the lossless join property at any cost
- D.The process of normalization through decomposition must achieve the dependency reservation property
Q103. Which of the following is not true regarding Indexes?
- A.Index can be defined even when there is no data in the table
- B.It support Range selections
- C.It can be created using ‘Create Index’ statement
- D.It can not be created on composite attributes✓ Correct
Q104. _______is a control that enables users to select one option from an associated list; users can also type an option.
- A.Combo box✓ Correct
- B.Button
- C.Text box
- D.Static area
Q105. _______ records data by burning microscopic holes in the surface of the disk with a laser.
- A.Hard disk
- B.RAM
- C.Optical disk✓ Correct
- D.Floppy disk
Q106. _______ is a control that users click to perform an action, set or toggle a state, or set an option.
- A.Button✓ Correct
- B.Text box
- C.Input form
- D.Report
Q107. Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order By CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where REGION = 'E' Order By CUSTOMER The above statement:
- A.Has an error - the string should be in double quotes.
- B.Has an error - ORDER BY clause.✓ Correct
- C.Does not have an error.
- D.Has an error - the string in single quotes 'NORTH' and 'SOUTH'.
Q108. A relation (from the relational database model) consists of a set of tuples, which implies that
- A.all tuples in a relation must be distinct.✓ Correct
- B.relational model supports multi-valued attributes whose values can be represented in sets.
- C.for any two tuples, the values associated with all of their attributes may be the same.
- D.all tuples in a particular relation may have different attributes.
Q109. ______ is a control that presents a set of choices from which a user can select one or more items; items can be text, graphics, or both.
- A.Text input
- B.Report
- C.Button
- D.List box✓ Correct
Q110. Which of the following concept is applicable with respect to 2NF?
- A.Non-transitive dependency
- B.Full functional dependency✓ Correct
- C.Partial dependency
- D.Transitive dependency
Q111. Instructor. 86. Which of the following serves as a milestone or reference point in the log file?
- A.Constraints
- B.Relations
- C.Check points✓ Correct
- D.Triggers
Q112. Instructor.
- A.Constraints
- B.Relations
- C.Check points✓ Correct
- D.Transactions identities
Q113. Database Management Systems
- A.view is always a complete set of all the tables in a database
- B.View can not be used for retrieving data
- C.The results of using a view are not permanently stored in the database.✓ Correct
- D.Rows can not be updated or deleted in the view
Q114. Database Management Systems (Session - 1)
- A.User accessible catalog
- B.Data processing
- C.Authorization service
- D.Recovery service✓ Correct
Q115. Database Management Systems (Session - 4)
- A.Table
- B.Update✓ Correct
- C.Create
- D.Alter
Q116. Database Management Systems (Session - 3)
- A.Hard disk
- B.RAM
- C.Optical disk✓ Correct
- D.Floppy disk
Q117. Database Management Systems Solved MCQS June 26,2012 CS403- Database Management Systems
- A.User accessible catalog
- B.Data processing
- C.Authorization service
- D.Recovery service✓ Correct
Q118. Which of the following is true for the relational model?
- A.Degree of a relation is the number of rows in a relation.
- B.Null value is a blank or zero value given to an attribute value when its value is inapplicable or its value is
- C.Complex key is a key consisting of more than one attribute.
- D.Constraint is a rule that restricts the values in a database.✓ Correct
Q119. Which of the following functions are NOT performed by a database administrator?
- A.Planning, designing and implementing database systems
- B.Establishing standards and procedures for database systems
- C.Communicating with database users✓ Correct
- D.Allocation of storage locations and data structures
Q120. Which of the following is not a benefit of normalization?
- A.Minimize insertion anomolies
- B.Minimize deletion anomolies
- C.Minimize updation anomolies
- D.Maximize redundancy✓ Correct
Showing the first 120 of 144 MCQs.