DBMS MCQs Quiz Multiple Choice Questions & Answers

1. _____________ function divides one numeric expression by another and returns theremainder.

1. POWER
2. MOD
3. ROUND
4. REMAINDER

2. Which of the operations constitute a basic set of operations for manipulating relational data?

1. Predicate calculus
2. Relational calculus
3. Relational algebra
4. None of the above

3. Key to represent relationship between tables is called

1. Primary key
2. Secondary Key
3. Foreign Key
4. None of these

4. Relational calculus is a

1. Procedural language.
2. Non- Procedural language.
3. Data definition language.
4. High level language.

5. Transaction processing is associated with everything below except

1. producing detail, summary, or exception reports.
2. recording a business activity.
3. confirming an action or triggering a response.
4. maintaining data.

6. Which of the following operation is used if we are interested in only certain columns of atable?

1. PROJECTION
2. SELECTION
3. UNION
4. JOIN

7. _________ data type can store unstructured data

1. RAW
2. CHAR
3. NUMERIC
4. VARCHAR

8. In an E-R diagram attributes are represented by

1. rectangle.
2. square.
3. ellipse.
4. triangle.

9. In an E-R diagram an entity set is represent by a

1. rectangle.
2. ellipse.
3. diamond box.
4. circle.

10. A file manipulation command that extracts some of the records from a file is called

1. SELECT
2. PROJECT
3. JOIN
4. PRODUCT

11. A data manipulation command the combines the records from one or more tables is called

1. SELECT
2. PROJECT
3. JOIN
4. PRODUCT

12. Which of the following is a legal expression in SQL?

1. SELECT NULL FROM EMPLOYEE;
2. SELECT NAME FROM EMPLOYEE;
3. SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
4. None of the above

13. AS clause is used in SQL for

1. Selection operation.
2. Rename operation.
3. Join operation.
4. Projection operation.

14. The users who use easy-to-use menu are called

1. Sophisticated end users.
2. Naïve users.
3. Stand-alone users.
4. Casual end users.

15. It is better to use files than a DBMS when there are

1. Stringent real-time requirements.
2. Multiple users wish to access the data.
3. Complex relationships among data.
4. All of the above.

16. An entity set that does not have sufficient attributes to form a primary key is a

1. strong entity set.
2. weak entity set.
3. simple entity set.
4. primary entity set.

17. A DBMS query language is designed to

1. support end users who use English-like commands.
2. support in the development of complex applications software.
3. specify the structure of a database.
4. all of the above.

18. The DBMS language component which can be embedded in a program is

1. The data definition language (DDL).
2. The data manipulation language (DML).
3. The database administrator (DBA).
4. A query language.

19. Which one of the following statements is false?

1. The data dictionary is normally maintained by the database administrator.
2. Data elements in the database can be modified by changing the data dictionary.
3. The data dictionary contains the name and description of each data element.
4. The data dictionary is a tool used exclusively by the database administrator.

20. A subschema expresses

1. the logical view.
2. the physical view.
3. the external view.
4. all of the above.

21. A data dictionary is a special file that contains:

1. The name of all fields in all files.
2. The width of all fields in all files.
3. The data type of all fields in all files.
4. All of the above.

22. NULL is

1. the same as 0 for integer
2. the same as blank for character
3. the same as 0 for integer and blank for character
4. not a value

23. Hierarchical model is also called

1. Tree structure
2. Plex Structure
3. Normalize Structure
4. Table Structure

24. The RDBMS terminology for a row is

1. tuple.
2. relation.
3. attribute
4. degree

25. In a relational model, relations are termed as

1. Tuples.
2. Attributes
3. Tables.
4. Rows.

26. Architecture of the database can be viewed as

1. two levels.
2. four levels.
3. three levels.
4. one level.

27. What is a relationship called when it is maintained between two entities?

1. Unary
2. Binary
3. Ternary
4. Quaternary

28. Cross Product is a:

1. Unary Operator
2. Ternary Operator
3. Binary Operator
4. Not an operator

29. Which of the following operations need the participating relations to be unon compatible?

1. UNION
2. INTERSECTION
3. DIFFERENCE
4. All of the above

30. To delete a particular column in a relation the command used is:

1. UPDATE
2. DROP
3. ALTER
4. DELETE

31. A report generator is used to

1. update files.
2. print files on paper.
3. data entry.
4. delete files.

32. The database environment has all of the following components except:

1. users.
2. separate files.
3. database.
4. database administrator.

33. Count function in SQL returns the number of

1. values.
2. distinct values.
3. groups.
4. columns.

34. It is possible to define a schema completely using

1. VDL and DDL.
2. DDL and DML.
3. SDL and DDL.
4. VDL and DML.

35. _________ is a virtual table that draws its data from the result of an SQLSELECT statement.

1. View
2. Synonym
3. Sequence
4. TrAnsaction

36. Which one of the following is not true for a view:

1. View is derived from other tables.
2. View is a virtual table.
3. A view definition is permanently stored as part of the database.
4. View never contains derived columns.

37. A relational database developer refers to a record as

1. a criteria.
2. a relation.
3. a tuple.
4. an attribute.

38. Which of the following is correct:

1. a SQL query automatically eliminates duplicates.
2. SQL permits attribute names to be repeated in the same relation.
3. a SQL query will not work if there are no indexes on the relations
4. None of these

39. Cartesian product in relational algebra is

1. a Unary operator.
2. a Binary operator.
3. a Ternary operator.
4. not defined.

40. The result of the UNION operation between R1 and R2 is a relation that includes

1. all the tuples of R1
2. all the tuples of R2
3. all the tuples of R1 and R2
4. all the tuples of R1 and R2 which have common columns

41. The statement in SQL which allows to change the definition of a table is

1. Alter.
2. Update.
3. Create.
4. select.

42. A set of possible data values is called

1. attribute.
2. degree.
3. tuple.
4. domain.

43. Which of the following database object does not physically exist?

1. base table
2. index
3. view
4. none of the above

44. The ______ operator is used to compare a value to a list of literals values that have beenspecified.

1. BETWEEN
2. ANY
3. IN
4. ALL

45. The physical location of a record is determined by a mathematical formula that trAnsformsa file key into a record location is :

1. B-Tree File
2. Hashed File
3. Indexed File
4. Sequential file.

46. _______ produces the relation that has attributes of R1 and R2

1. Cartesian product
2. Difference
3. Intersection
4. Product

47. The natural join is equal to :

1. Cartesian Product
2. Combination of Union and Cartesian product
3. Combination of selection and Cartesian product
4. Combination of projection and Cartesian product

48. Which of the following is a valid SQL type?

1. CHARACTER
2. NUMERIC
3. FLOAT
4. All of the above

49. Which of the following is another name for weak entity?

1. Child
2. Owner
3. Dominant
4. All of the above

50. The view of total database content is

1. Conceptual view.
2. Internal view.
3. External view.
4. Physical View.