Q1. Which of the following feature provides more data reliability in a DBMS?
- A.Data sharing
- B.Controlled redundancy
- C.Better data integrity✓ Correct
- D.Concurrency
Q2. After execution of “commit” statement, ____________ is updated first.
- A.Database Buffer✓ Correct
- B.Clustered-Index
- C.Non-Clustered Index
- D.Application Program
Q3. Identify the command to remove from the table
- A.DROP
- B.INSERT
- C.UPDATA
- D.DELETE✓ Correct
Q4. Which of the following is not one of the properties of Transaction?
- A.Atomicity
- B.Consistency
- C.Redundancy✓ Correct
- D.Durability
Q5. Which of the following is not a type of user interface?
- A.Graphical User Interface (GUI)
- B.Forms
- C.Database Schema✓ Correct
- D.Text based Interface
Q6. Which of the following operation allows certain selections and Cartesian product into one operation?
- A.Join✓ Correct
- B.Select
- C.Project
- D.Union
Q7. 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
Q8. Locking is maintained by-----
- A.End use
- B.Form designer
- C.Lock manager✓ Correct
- D.User interface
Q9. Which of the following is not correct 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
Q10. If D --> E, F then D --> E and D --> F. This inference rules is called as _______.
- A.Transitivity
- B.Additive
- C.Projectivity✓ Correct
- D.Augmentation
Q11. To access a files ABC sequential files access involves too much ---- as compared to direct files access
- A.Time, space and number of files
- B.Number of files
- C.Space
- D.Time✓ Correct
Q12. ____________ is used to detect the dead lock.
- A.Wait-for graph✓ Correct
- B.Cross Reference Matrix
- C.Inner Join
- D.Clustered Index
Q13. ______ 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.Button
- B.List box✓ Correct
- C.Text input
- D.Radio button
Q14. Which of the following statements creates a database named COMPANY.
- A.CREATE DATABASE company✓ Correct
- B.CREATE DB company
- C.ADD DATABASE company
- D.CREATE company DATABASE
Q15. The main memory of a computer system is also known as
- A.ROM
- B.RAM✓ Correct
- C.PROM
- D.Hard disk
Q16. Which of the following is not a DDL Command?
- A.Create table
- B.Alter table
- C.Insert into✓ Correct
- D.Create database
Q17. How we CANNOT determine the cardinalities of a system
- A.By interviewing the user
- B.Through analysis of the organization
- C.Using the system requirement
- D.Creating by ourselves✓ Correct
Q18. ----- is used to access and manipulate data
- A.DDL
- B.DML✓ Correct
- C.DCL
- D.ERD
Q19. Which of the following is incorrect regarding Indexes?
- A.It cannot be created on composite attributes.✓ Correct
- B.Index can be defined even when there is no data in the table.
- C.It supports Range selections.
- D.It can be created using ‘Create Index’ statement
Q20. A relation (from the relational database model) consists of a set of tuples, which implies that Relational model supports multi-valued attributes whose values can be represented in sets.
- A.for any two tuples, the values associated with all of their attributes may be the same.
- B.for any two tuples, the values associated with one or more of their attributes must differ.✓ Correct
- C.all tuples in a particular relation may have different attributes.
- D.all tuples in a relation must have identical attribute values.
Q21. Which of the following is not correct Regarding VIEWS
- A.VIEWS can be used to interact with database
- B.Through view user can focus on their interested data
- C.View can show one or more records from a database
- D.View cannot be update✓ Correct
Q22. Database System” is the combination of_________________.
- A.Database and DBMS✓ Correct
- B.Database and Data
- C.Data and Information
- D.Operating System and Database
Q23. If A -> B then AC -->BC This inference rules is called as _______.
- A.Transitivity
- B.Additive
- C.Augmentation✓ Correct
- D.Reflexivity
Q24. On magnetic media, data is stored in ______________
- A.Text
- B.Images
- C.Binary format✓ Correct
- D.Tables
Q25. Which of the following tells us that the link between two relation is compulsory or optional
- A.Minimum cardinality✓ Correct
- B.Maximum cardinality
- C.Existence dependency
- D.Referential dependency
Q26. Which of the following is NOT a part of Deadlock Resolution?
- A.Choose a victim
- B.A message is passed to the victim and depending on the system the transaction may or may not be started again automatically.
- C.Picking a list of all previously completed transactions and undoing all the updates.✓ Correct
- D.Rollback `victim' transaction and restart it.
Q27. 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
Q28. Dead Lock can be prevented by giving each transaction a ___________.
- A.Name
- B.Clustered Index
- C.Cartesian Join
- D.Priority✓ Correct
Q29. Partitions may become unbalanced in:
- A.Range partitioning✓ Correct
- B.Hash partitioning
- C.List partitioning
- D.Vertical partitioning
Q30. A Table can have ___________ clustered index (es).
- A.Only one✓ Correct
- B.Only two
- C.More than two
- D.Only three
Q31. Which of the following is a feature of foreign key constrain
- A.Used to enforce referential integrity✓ Correct
- B.Limit the no of values that can be placed in a column
- C.Enforces that the column will not accept null values
- D.Enforces the uniqueness of the values in a set of column
Q32. _____________ is used to sort the result set in ascending or descending order
- A.Group by Clause
- B.From Clause
- C.Where Clause
- D.Order by Clause✓ Correct
Q33. How super type properties can be transferred in sub types automatically
- A.Inheritance✓ Correct
- B.Abstraction
- C.Encapsulation
- D.Through DFD
Q34. 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
Q35. ________ 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
Q36. Which of the following is not a type of VIEWS?
- A.Materialized View
- B.Simple Views
- C.Complex View
- D.Cross Reference View✓ Correct
Q37. ------------- is not an operation of relational algebra
- A.Addition✓ Correct
- B.Union
- C.Cartesian product
- D.Set difference
Q38. Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their Cartesian product contains?
Q39. Which of the following types of partitioning reduces the chances of unbalanced partitions?
- A.Vertical
- B.List
- C.Hash✓ Correct
- D.Range
Q40. Suppose there are 5 rows and 4 columns in TABLE1 and 6 rows and 7 columns in TABLE2; what is the size of the Cartesian product incase of CROSS JOIN between these two tables?
- A.30✓ Correct
- B.35
- C.24
- D.28
Q41. Attributes on which we do not need to access the unique instances of an entity type is called.
- A.Primary key
- B.Secondary✓ Correct
- C.AlterNet key
- D.Foreign key
Q42. Which of the following is not the component of relational data model
- A.Integrity constraint
- B.Manipulation language✓ Correct
- C.Relation /table
- D.Domain constraint
Q43. To make a change in traditional file processing system was difficult due to .
- A.Independent program and data
- B.Program and data interdependence✓ Correct
- C.Slow system performance
- D.Lack of computer knowledge
Q44. DFD and CRM help to identify the
- A.Attribute
- B.Entity type✓ Correct
- C.Data model
- D.Database
Q45. ------- Record 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
Q46. A patient can only be an indoor or an outdoor patient , what do you conclude about patient entity from above statement
- A.Complete disjoint
- B.Total completeness✓ Correct
- C.Partial disjoint
- D.Partial overlapping
Q47. If in a relational R, all non key attributes are fully functionally dependent on key attributes .the relation R is in------
- A.2NF✓ Correct
- B.3NF
- C.BCNF
- D.Higher NF
Q48. ------ Is an example of non-volatile memory
- A.SRAM
- B.Cache memory
- C.Flash memory✓ Correct
- D.DRAM
Q49. If a relation contains single Key, the relation is automatically in _______.
- A.1NF
- B.2NF✓ Correct
- C.3NF
- D.4NF
Q50. Which of the following is true about a relation?
- A.We cannot determine the degree of a relation
- B.A relation is subset of a Cartesian product✓ Correct
- C.A relation is a three dimensional arrangement
- D.A relation can only have a limited number of records
Q51. The following sentence is incorrect about sub-query
- A.A sub query must be enclosed in the parenthesis
- B.A sub query must be put in the left hand of the comparison operator✓ Correct
- C.A sub query cannot contain order-by clause
- D.A query can contain more than one sub queries
Q52. Suppose there are 7 rows and 4 columns in TABLE1 and 5 rows and 3 columns in TABLE2; what is the size of the Cartesian product incase of CROSS JOIN between these two tables?
- A.35✓ Correct
- B.18
- C.21
- D.12
Q53. What is the impact of setting multiple indexes for the same key?
- A.Multiple indexes for the same key cannot be set
- B.It increases efficiency✓ Correct
- C.It decreases efficiency
- D.It will increase complexity as the access time will be increased
Q54. In DFD collector shows the---- of data to a single point
- A.Divergence
- B.Convergence✓ Correct
- C.Subtraction
- D.Separation
Q55. Three level schema Architecture allows us to separate the physical representation of data from the
- A.System view
- B.User view✓ Correct
- C.Database view
- D.Architecture view
Q56. We can apply union operation on relational only if
- A.They have the same names
- B.They do not have same domains of corresponding attributes
- C.They do not have same number of attributes
- D.They have same degree✓ Correct
Q57. In which type of join rows are joined on the basis of a common attributes
- A.Equi –join✓ Correct
- B.Theta join
- C.Left outer join
- D.Right outer join
Q58. The select the range while creating indexes ,the operator that is not used that is not used is----
- A.Equals to(==)✓ Correct
- B.Less than(<)
- C.And (&&)
- D.Between
Q59. Which of the following is the correct way to find out the size of Cartesian product in case of CROSS JOIN?
- A.The number of columns in the first table multiplied by the number of columns in the second table.
- B.The number of columns in the first table multiplied by the number of rows in the second table.
- C.The number of rows in the first table multiplied by the number of columns in the first table.
- D.the number of rows in the first table multiplied by the number of rows in the second Table.✓ Correct
Q60. DBMS and operating system both are example of
- A.Hardware
- B.Software✓ Correct
- C.Database
- D.File processing system
Q61. 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
Q62. Purpose of normalization is to
- A.Produce redundancy
- B.Create insertion problem
- C.Make maintence difficult
- D.Remove all kind of anomalies✓ Correct
Q63. 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.
Q64. Which of the following is the activity which is not performed during the development of application programs
- A.Data input programs
- B.Editing
- C.Display
- D.Data collection✓ Correct
Q65. Permanent structure of the database is also called
- A.Impression of the database
- B.Extension of the database
- C.Expansion of the database
- D.Intension of the database✓ Correct
Q66. Data is also called
- A.Organized facts
- B.Raw facts✓ Correct
- C.Information
- D.Processed facts
Q67. Controlling redundancy in database does not help to?
- A.Avoid data duplication
- B.Avoid unnecessary wastage of storage space
- C.Avoid unauthorized access to data✓ Correct
- D.Avoid data inconsistency
Q68. Which of the following feature allow many user to users to use a DBMS at the same time
- A.Robustness
- B.Concurrency✓ Correct
- C.Scalability
- D.Efficiency
Q69. A DBMS which perform all necessary associated to a database is a collection of
- A.Steps
- B.Programs✓ Correct
- C.Files
- D.Processes
Q70. Which of the following is not an operation of relational algebra
- A.Union
- B.Reminder✓ Correct
- C.Cartesian product
- D.Set different
Q71. Which of the following is not the property of Transaction?
- A.Atomicity
- B.Consistency
- C.Redundancy✓ Correct
- D.Durability
Q72. Which of the following is created by Database Management system for its usage
- A.Integrated Data Dictionary✓ Correct
- B.Free standing data dictionary
- C.Cross reference matrix
- D.Weak entity
Q73. Basic building block of relational data model
- A.Manipulation language
- B.Row
- C.Table✓ Correct
- D.Cartesian product
Q74. Major drawback of traditional file processing system is
- A.Sharing data
- B.Congestion control
- C.Data inconsistency✓ Correct
- D.Concurrency
Q75. Identify the language which is used to specify database scheme.
- A.DDL✓ Correct
- B.DML
- C.DCL
- D.TCL
Q76. Which of the following SQL statement used to control access to the data in the database?
- A.GRANT and REVOKE✓ Correct
- B.SELECT and INSERT
- C.CREATE and DROP
- D.COMMIT and ROLLBACK
Q77. Grant Command belong to which type of classification?
- A.DDL
- B.DML
- C.DCL✓ Correct
- D.TCL
Q78. Which of the following is one of the purposes of using DDL commands?
- A.Create and Destroying database✓ Correct
- B.Inserting data
- C.Updating data
- D.Deleting data
Q79. The _______ Operator allows to use wild cards in the where clause of an SQL statement.
- A.LIKE✓ Correct
- B.IN
- C.BETWEEN
- D.EXISTS
Q80. In SQL which command is used to delete rows from Table.
- A.DELETE✓ Correct
- B.DROP
- C.TRUNCATE
- D.REMOVE
Q81. Which of the following function falls in the category of Aggregate function?
- A.SUM
- B.COUNT
- C.AVG
- D.All of the above✓ Correct
Q82. The ______ condition use to retrieve values within a specific range.
- A.BETWEEN✓ Correct
- B.IN
- C.LIKE
- D.EXISTS
Q83. The _______ Function helps to reduce the need of Multiple OR condition.
- A.IN✓ Correct
- B.BETWEEN
- C.LIKE
- D.EXISTS
Q84. Objective of an order by clause is to display or arrange output of a select statement in a particular order.
- A.YES✓ Correct
- B.NO
- C.Maybe
- D.Not sure
Q85. DBMS stand for_________
- A.DATABASE MANAGEMENT SYSTEM✓ Correct
- B.DATA BASE MANAGEMENT SYSTEM
- C.DATABASE MANAGER SYSTEM
- D.DATA MANAGEMENT SYSTEM
Q86. Which of the following is used to filter rows according to some condition?
- A.WHERE✓ Correct
- B.HAVING
- C.ORDER BY
- D.GROUP BY
Q87. Which of the following is incorrect about alter table statement?
- A.Cannot be used to modify type or size of an existing column✓ Correct
- B.Can add new column
- C.Can drop column
- D.Can rename table
Q88. Which is not the function of Database Management System?
- A.Failaiour Response Service✓ Correct
- B.Data storage
- C.Data retrieval
- D.Data security
Q89. Which of the following is a string function in SQL?
- A.LEN✓ Correct
- B.SUM
- C.COUNT
- D.AVG
Q90. Which of the following is a Date function in SQL?
- A.DATEPART✓ Correct
- B.LEN
- C.UPPER
- D.CAST
Q91. Which of the following is a Conversion function in SQL?
- A.CAST✓ Correct
- B.LEN
- C.UPPER
- D.DATEPART
Q92. Which of the following is a System function in SQL?
- A.HOST_NAME✓ Correct
- B.LEN
- C.UPPER
- D.CAST
Q93. Which of the following is not an aggregate function?
- A.UPPER✓ Correct
- B.SUM
- C.COUNT
- D.AVG
Q94. Which of the following SQL clauses used to start the records in result set?
- A.ORDER BY✓ Correct
- B.GROUP BY
- C.HAVING
- D.WHERE
Q95. The ORDER BY clause can only be used in ________ statements.
- A.SELECT✓ Correct
- B.INSERT
- C.UPDATE
- D.DELETE
Q96. SQL is used for
- A.Querying data
- B.Manipulating data
- C.Defining data
- D.All of the above✓ Correct
Q97. Which of the following is the correct SQL statement for creating table in Microsoft SQL server?
- A.CREAT TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar (30))
- B.CREATE TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar (30))✓ Correct
- C.CREATE TABLE Customer (SID integer, Last_Name varchar (30))
- D.CREATE TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar)
Q98. DML does not used to
- A.Alter a Table definition✓ Correct
- B.Insert data
- C.Update data
- D.Delete data
Q99. UPDATE command belong to which type of classification?
- A.DML✓ Correct
- B.DDL
- C.DCL
- D.TCL
Q100. DDL stand For
- A.DATA DEFINITION LANGUAGE✓ Correct
- B.DATA DESCRIPTION LANGUAGE
- C.DATA DECLARATION LANGUAGE
- D.DATA DEFINITION LANGUGE
Q101. Which of the following is used to retrieve and insert information from database?
- A.DML✓ Correct
- B.DDL
- C.DCL
- D.TCL
Q102. Which of the following statement creates a database named IMDB?
- A.CREATE DATABASE IMDB✓ Correct
- B.CREATE DB IMDB
- C.CREATE DATABASE IMDB;
- D.CREATE DATABASE 'IMDB'
Q103. Which of the following is the correct syntax for adding a new column into an existing table.
- A.ALTER TABLE table_name ADD column type [(size)] [DEFAULT default]
- B.ALTER TABLE table_name ADD COLUMN column type [(size)] [DEFAULT default]
- C.ALTER TABLE table_name ADD [COLUMN] column type [(size)] [DEFAULT default]✓ Correct
- D.ALTER TABLE table_name ADD column type
Q104. Identify the basic(s) of a SELECT statement.
- A.Both SELECT and FROM✓ Correct
- B.SELECT only
- C.FROM only
- D.WHERE
Q105. The conceptual database design can be transformed into any ________.
- A.DATA MODEL✓ Correct
- B.SCHEMA
- C.TABLE
- D.RELATION
Q106. 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
Q107. GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION; What does this SQL statement do?
- A.Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table.
- B.Grant permission to Hiruni in order to grant, select and update permission to Amali.
- C.Grant permission to Amali & Hiruni to update designation of employees in the Employee table.✓ Correct
- D.Grant permission to Amali and Hiruni to update all data except designation in Employee table.
Q108. Which key word is available in SQL to enforce referential integrity?
- A.Check✓ Correct
- B.Primary Key
- C.Set Default
- D.Unique
Q109. Which of the following statements are Data Definition Language command?
- A.INSERT
- B.UPDATE
- C.GRANT
- D.TRUNCATE✓ Correct
Q110. How many clustered index(es) do each database table have?
Q111. 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
Q112. 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
Q113. 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
Q114. 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;
Q115. 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;
Q116. Which SQL query retrieves all customers 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;
Q117. 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.
- C.The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.✓ Correct
- D.The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed.
Q118. Which of the following is not true with respect to denormalization?
- A.A denormalized data model is not the same as a data model that has not been normalized
- B.Denormalization takes place before the normalization process✓ Correct
- C.It is an attempt to optimize the performance of database
- D.Denormalization process can not be initiated before the Database design
Q119. 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
Q120. Which of the following is INCORRECT with respect to file systems?
- A.At the physical level, pointer or hashed address scheme may be employed to provide a certain degree of data independence at the user level.
- B.A logical record is concerned with efficient storage of information in the secondary storage devices.✓ Correct
- C.Some physical organisations use pointers to record blocks to locate records on disk.
- D.The efficiency of a file system depends on how efficiently operations such as retrieve, insert, update, delete may be performed on the information stored in the file.
Showing the first 120 of 200 MCQs.