Database MCQ Questions Answers

1. The _____ model uses the term connectivity to label the relationship types.

2. Entity attributes and primary keys are not present in the _____ data model.

3. The last value generated by a sequence is stored in the ____ pseudocolumn.

4. The conversion of an unnormalized table to first normal form requires the removal of ____.

5. Oracle 12c, ms sql server, and tamino are examples of _____ data models.

6. One remedy for the inconsistencies caused by concurrent processing is ________.

7. In access, dates are enclosed in number signs and are entered using the format ____.

8. In many cases, a subquery can be restated as a/an ______________.

9. In the broadest definition, a(n) ____ is a collection of information.

10. In the _____ model, each parent can have many children, but each child has only one parent.

11. In object-oriented terms, a(n) ____________________ defines an objects behavior.

12. Data redundancies occur from ____________________ of data on every row entry.

13. Creating the conceptual design and selecting dbms software are part of the ____ phase of the dblc.

14. The traditional systems development life cycle (sdlc) is divided into _____ phases.

15. _____ fragmentation refers to the division of a relation into attribute subsets.

16. To override the order of precedence in an arithmetic expression, you can use __________________.

17. Making sure all ____ are identified is a very important part of a database designers job.

18. A(n) ____________________ is a collection of similar objects with a shared structure and behavior.

19. A(n) _____ relationship is also known as an identifying relationship.

20. The process of creating an information system is known as _____.

21. The stddev function can be used with ____ columns.

22. To avoid the display of a security warning when opening a database, place the database ____.

23. The ____ wildcard symbol represents any individual character.

24. Sql server supports ________________ of the ansi-standard data types

25. Non-overlapping subtypes are subtypes that contain a(n) ____ subset of the supertype entity set.

26. Most data that can be encountered are best classified as _____.

27. A trigger is stored and compiled on the ____.

28. The product of two tables is formally called the ____ product.

29. The relationships between the sizes of different parts of a work make up its ________.

30. Access does not support the ____ data type.

31. A(n)_____ specifically reserves access to the transaction that locked the object.

32. In the internet, the movement from one network to another network is termed a _______.

33. Recovering a database via rollforward involves ________.

34. The way patient records are created, filed, and maintained is called a(n) ____.

35. Decision makers can access analytical databases using an executive __________.

36. Dbmss available for use on personal computers include ____ and corel paradox.

37. Data warehouses are sometimes called hypercubes because they _____.

38. Data integrity with real-time systems involves the acid test, which involves ________.

39. Current data distribution philosophy makes it easy for ____ end users to access the database.

40. A(n) _____ is a logical storage area in oracle.

41. In a database, bits can be organized into bytes, and each byte represents is a(n) ______.

42. Ideally, an entity identifier is composed of _____ attribute(s).

43. A(n) ____ limits access to systems, such as computer databases.

44. Flat, raised, sunken, etched, shadowed, and chiseled are options for the ____ control property.

45. The ____ establishes the naming conventions for tables, fields, and indexes in the data dictionary.

46. The default comparison condition for the subtype discriminator attribute is the _____ comparison.

47. ____________________ is a process to help reduce the likelihood of data anomalies.

48. A(n) ____ is a piece of data required by an action in a macro.

49. Some very specialized applications may require normalization beyond the _____.

50. A/an ___________________ report shows a summary but no details.

51. A(n) ____ is a query that is embedded (or nested) inside another query.

52. The _____ component of a case tool produces the information system's input/output formats.

53. The term _________________________ refers to scattered locations storing the same basic data.

54. A programming language typically used for cgi scripts is ____.

55. From a structural point of view, 2nf is better than _____.

56. Older systems that often contain data of poor quality are called ________ systems.

57. A(n) ____ database stores each database fragment at a single site.

58. A subquery can be coded in a where, from, select, or ______________ clause.

59. A subquery is a/an ______________ statement thats coded within another sql statement.

60. A subquery must include a(n) ____ clause.

61. Set the ____ property to no to prevent users from using the tab key to navigate to a control.

62. The sql command ________ adds one or more new columns to a table.

63. The maximum width of the number datatype is ____ digits.

64. To create a new table by using a select statement, you code the ___________________________ clause.

65. The conceptual model can handle _____ relationships and multivalued attributes.

66. You use the ____ clause to list data in a specific order.

67. ____ is an example of assistive output devices.

68. To eliminate duplicate rows in a query, the ________ qualifier is used in the sql select command.

69. Oracle 11g is an example of a(n) ____.

70. A table that contains a repeating group is called a(n) ____.

71. A verb associating two nouns in a business rule translates to a(n) ____ in the data model.

72. To add new data to a table, use the ____ command.

73. A total completeness constraint is represented by _____.

74. The extended entity relationship model (eerm) is sometimes referred to as the ____.

75. A(n) ____________________ is a specific request issued to the dbms for data manipulation.

76. A specialization hierarchy can have _____ level(s) of supertype/subtype relationships.

77. The crows feet notation on an erd is a type of _______ constraint.

78. To include all fields in a sql query, use the ____ symbol after the word select.

79. _____ refer to databases focused on addressing the concerns of a specific problem or business unit

80. A(n) ____ is an application programs or an individual users picture of the database.

81. In sql server, you can use the ____ function to obtain today?s date.

82. Vba procedures are created, modified, and displayed in the ____ window.

83. Only one ____ constraint can exist for each table.

84. A ____ identifier is composed of more than one attribute.

85. ____ allow a web site to store information on the client computer for later retrieval.

86. In a dataflow diagram (dfd), a(n) ___________ portrays the transformation of data.

87. ________ integrates data from various operational systems.

88. A ____ query creates a new table using the query results.

89. A(n) ____ has a central security database that is used by all computers that are members of it.

90. The default orientation for printing a report many be changed using the ____ feature of access.

91. Knowing the ____ number of entity occurrences is very helpful at the application software level.

92. A _____ is a central storehouse of information about a system's data.

93. A _____ attribute can be further subdivided to yield additional attributes.

94. _____ occurs when applications cannot access data associated with other applications.

95. The maintenance and evolution phase of the database life cycle (dblc) involves _____.

96. _____ relationships occur when there are multiple relationship paths between related entities.

97. A(n) ____ is responsible for setting up and managing large databases within an organization.

98. A ________ check would be used to restrict the fines for speeding violations from $50 to $250.

99. A(n) _____ is a computer application that contains records or files.

100. ____ can describe any type of data.