> > Database MCQs > Database Organization & Design MCQs

Database Organization & Design MCQ

Database Organization & Design

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

Determinants

Interrelation constraints

Nonkey columns

Repeating groups

Answer

Correct Answer: Repeating groups

Note: This Question is unanswered, help us to find answer for this one

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

Entity relationship

Hierarchical

Constraints

XML Hybrid

Answer

Correct Answer: XML Hybrid

Note: This Question is unanswered, help us to find answer for this one

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

Lost updates

Checkpointing

Rollback

Resource locking

Answer

Correct Answer: Resource locking

Note: This Question is unanswered, help us to find answer for this one

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

DD/MON/YYYY

YYYY/MON/DD

MM/DD/YYYY

DD/MM/YY

Answer

Correct Answer: MM/DD/YYYY

Note: This Question is unanswered, help us to find answer for this one

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

Aggregate function

Join

Object

Average

Answer

Correct Answer: Join

Note: This Question is unanswered, help us to find answer for this one

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

Index

Hierarchy

Field

Database

Answer

Correct Answer: Database

Note: This Question is unanswered, help us to find answer for this one

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

Entity Relationship

Hierarchical

Relational

Network

Answer

Correct Answer: Hierarchical

Note: This Question is unanswered, help us to find answer for this one

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

Application

Program

Relationship

Method

Answer

Correct Answer: Method

Note: This Question is unanswered, help us to find answer for this one

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

Duplication

Same

Both of these

None of these

Answer

Correct Answer: Duplication

Note: This Question is unanswered, help us to find answer for this one

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

Database initial study

Database design

Implementation and loading

Testing and evaluation

Answer

Correct Answer: Database design

Note: This Question is unanswered, help us to find answer for this one

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

Five

Four

Three

Two

Answer

Correct Answer: Five

Note: This Question is unanswered, help us to find answer for this one

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

Data

Horizontal

Vertical

Mixed

Answer

Correct Answer: Vertical

Note: This Question is unanswered, help us to find answer for this one

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

Parentheses

Brackets

Distinct

Asterisk

Answer

Correct Answer: Parentheses

Note: This Question is unanswered, help us to find answer for this one

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

Business rules

Derived attributes

Cardinalities

None of these

Answer

Correct Answer: Business rules

Note: This Question is unanswered, help us to find answer for this one

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

Connectivity

Entity set

Class

Constraint

Attribute

Answer

Correct Answer: Class

Note: This Question is unanswered, help us to find answer for this one

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

Degree

Minimum

Solid

Small circle

Answer

Correct Answer: Solid

Note: This Question is unanswered, help us to find answer for this one

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

Systems development

Database development

Network development

Enterprise

Answer

Correct Answer: Systems development

Note: This Question is unanswered, help us to find answer for this one

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

Numeric

Date

Character

All of the above

Answer

Correct Answer: Numeric

Note: This Question is unanswered, help us to find answer for this one

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

Find unmatched query

In a trusted folder

Input mask

A lookup field

Answer

Correct Answer: In a trusted folder

Note: This Question is unanswered, help us to find answer for this one

20. The ____ wildcard symbol represents any individual character.

Dollar sign ( $ )

Underscore ( _ )

Asterisk ( * )

Percent sign ( % )

Answer

Correct Answer: Underscore ( _ )

Note: This Question is unanswered, help us to find answer for this one

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

All

None

Some, but not all

One

Answer

Correct Answer: Some, but not all

Note: This Question is unanswered, help us to find answer for this one

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

Entity

Unique

Subtypes

Nonunique

Answer

Correct Answer: Unique

Note: This Question is unanswered, help us to find answer for this one

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

Historical

Unstructured

Semistructured

Structured.

Answer

Correct Answer: Semistructured

Note: This Question is unanswered, help us to find answer for this one

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

Server

False

Client

trigger

Answer

Correct Answer: Server

Note: This Question is unanswered, help us to find answer for this one

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

Duplicate

DROP TABLE

DROP VIEW

CREATE TABLE

Answer

Correct Answer: CREATE TABLE

Note: This Question is unanswered, help us to find answer for this one

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

Spiritual

Hierarchical

Supernatural

Hierarchical scale

Answer

Correct Answer: Hierarchical scale

Note: This Question is unanswered, help us to find answer for this one

27. Access does not support the ____ data type.

CURRENCY

DECIMAL

INT

CHAR

Answer

Correct Answer: DECIMAL

Note: This Question is unanswered, help us to find answer for this one

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

Shared lock

Exclusive lock

Binary lock

Deadlock

Answer

Correct Answer: Exclusive lock

Note: This Question is unanswered, help us to find answer for this one

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

Partially replicated

Unreplicated

Fully replicated

Partitioned

Answer

Correct Answer: Unreplicated

Note: This Question is unanswered, help us to find answer for this one

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

Tab Index

On Tab

Left Tab

Tab Stop

Answer

Correct Answer: Tab Stop

Note: This Question is unanswered, help us to find answer for this one

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

Create table

Alter table

Create view

Create relationship

Answer

Correct Answer: Alter table

Note: This Question is unanswered, help us to find answer for this one

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

255

Answer

Correct Answer: 38

Note: This Question is unanswered, help us to find answer for this one

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

INTO

Job

HAVING

None of these

Answer

Correct Answer: INTO

Note: This Question is unanswered, help us to find answer for this one

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

1:1

M:N

1:M

1:N

Answer

Correct Answer: M:N

Note: This Question is unanswered, help us to find answer for this one

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

Composite

Foreign

Domain

Primary

Answer

Correct Answer: Composite

Note: This Question is unanswered, help us to find answer for this one

36. Use the ________ tag to configure a section of a web page that is physically separated from others.

Align

Padding

Jpg

CSS

Answer

Correct Answer:

Note: This Question is unanswered, help us to find answer for this one

37. The term "____" is used to label any condition in which one or more optional relationships exist.

Cardinality

Connectivity

Optionality

Relationship

Answer

Correct Answer: Optionality

Note: This Question is unanswered, help us to find answer for this one

38. The existence of a(n) __________ entity indicates that its minimum cardinality is zero.

Rectangle

Required

Optional

Answer

Correct Answer: Optional

Note: This Question is unanswered, help us to find answer for this one

39. A(n) _____ is the equivalent of a field in a file system.

Relationship

Class

Segment

Attribute

Answer

Correct Answer: Attribute

Note: This Question is unanswered, help us to find answer for this one

40. Business rules are derived from ____.

Stakeholder profiles

Attribute

Constraint

Entity

Answer

Correct Answer: Entity

Note: This Question is unanswered, help us to find answer for this one

41. Some ____ database modeling concepts can be expressed only using the chen notation.

Developmental

Actual

Conceptual

Specific

Answer

Correct Answer: Conceptual

Note: This Question is unanswered, help us to find answer for this one

42. One of the limitations of the ____ model is that there is a lack of standards.

Hierarchical

Network

Relational

Entity relationship

Answer

Correct Answer: Hierarchical

Note: This Question is unanswered, help us to find answer for this one

43. A(n) ____ model represents a global view of the database as viewed by the entire organization.

External

Conceptual

Internal

Physical

Answer

Correct Answer: Conceptual

Note: This Question is unanswered, help us to find answer for this one

44. A derived attribute is indicated in the chen model by a ____.

Single line.

Circle.

Dashed line.

Double line.

Answer

Correct Answer: Dashed line.

Note: This Question is unanswered, help us to find answer for this one

45. A(n) ____ is an ordered arrangement of keys and pointers.

Dbms

System catalog

Constraints

Index

Answer

Correct Answer: Index

Note: This Question is unanswered, help us to find answer for this one

46. A union combines the rows from two or more _______________________.

Alias

The result set must be derived from different tables

Inner

Explicit

Answer

Correct Answer: Inner

Note: This Question is unanswered, help us to find answer for this one

47. A(n) ____'s main function is to help you understand the complexities of the real-world environment.

Node

Entity

Model

Database.

Answer

Correct Answer: Model

Note: This Question is unanswered, help us to find answer for this one

48. A(n) _____ develops when all required changes in the redundant data are not made successfully.

Relation

Anomaly

Attribute

Tuple

Answer

Correct Answer: Anomaly

Note: This Question is unanswered, help us to find answer for this one

49. A(n) ____ is a system-generated primary key that is usually hidden from users.

Weak entity

Surrogate key

Natural key

Artificial key.

Answer

Correct Answer: Surrogate key

Note: This Question is unanswered, help us to find answer for this one

50. A(n) ____ clause cannot include a group function.

Individual column

Column aliases cannot be used in a GROUP BY clause.

WHERE

WHERE, GROUP BY, HAVING

GROUP BY

Answer

Correct Answer: WHERE

Note: This Question is unanswered, help us to find answer for this one

51. When using the oracle to_date function, the code _____ represents a three-letter month name.

M B

MON

MONTH

Answer

Correct Answer: MON

Note: This Question is unanswered, help us to find answer for this one

52. In the figure above, if you only want to set one criterion for this filter, you will ____.

Leave the lower boxes empty

Enter "0" into the lower boxes

Enter "none" into the lower boxes

Access a pull-down menu of options

Answer

Correct Answer: Leave the lower boxes empty

Note: This Question is unanswered, help us to find answer for this one

53. In oracle, the _____ function converts a date to a character string.

CONVERT()

TO_DATE

TO_CHAR()

TO_STRING().

Answer

Correct Answer: TO_CHAR()

Note: This Question is unanswered, help us to find answer for this one

54. Date attributes contain calendar dates stored in a special format known as the _____ date format.

Julian

Arithmetic

Composite key

Intersection

Answer

Correct Answer: Julian

Note: This Question is unanswered, help us to find answer for this one

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

SELECT

WHERE

FROM

Both

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

56. A person?s social security number would be an example of a(n) ____________________ attribute.

Single-valued

Primary key

Warehousing

Equijoin

Answer

Correct Answer: Single-valued

Note: This Question is unanswered, help us to find answer for this one

57. A(n) ____ is the association between entities.

Rectangles

All of the above

Relationship

Entity

Answer

Correct Answer: Relationship

Note: This Question is unanswered, help us to find answer for this one

58. The proper use of ____________________ keys is crucial to controlling data redundancy.

Foreign

Keys

Flags

Attributes

Answer

Correct Answer: Foreign

Note: This Question is unanswered, help us to find answer for this one

59. A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.

Transaction

Sorting

Both a and b

None of the above

Answer

Correct Answer: Transaction

Note: This Question is unanswered, help us to find answer for this one

60. In relational database design, id-dependent entities are used to ________.

Represent N:M relationships

Handle associative relationships

Handle multivalued attributes

Handle archetype/instance relationships

Answer

Correct Answer: Represent N:M relationships

Note: This Question is unanswered, help us to find answer for this one

61. The ____ operator finds rows that do not contain a null value in the specified column.

IS NULLNOT

NULL!NULL.

IS NOT NULL

None of these

Answer

Correct Answer: IS NOT NULL

Note: This Question is unanswered, help us to find answer for this one

62. ____ means that an entity has a minimum cardinality of zero.

The entity has a mandatory role in the relationship

The entity is not required in the relationship

None of these

Both of these

Answer

Correct Answer: The entity is not required in the relationship

Note: This Question is unanswered, help us to find answer for this one

63. Sql was developed under the name ____ at the ibm san jose research facilities.

SQL View

Datasheet

SEQUEL

Query Design

Answer

Correct Answer: SEQUEL

Note: This Question is unanswered, help us to find answer for this one

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

Hierarchical model

Relational data model

File system data model

XML/Hybrid data model

Answer

Correct Answer: XML/Hybrid data model

Note: This Question is unanswered, help us to find answer for this one

65. At tal distributors, there is a ____ relationship between sales reps and customers.

One-to-one

One-to-two

One-to-many

Many-to-many

Answer

Correct Answer: One-to-many

Note: This Question is unanswered, help us to find answer for this one

66. A ____ column is a column that is not part of the primary key.

Determinant

Candidate

Functional

Nonkey

Answer

Correct Answer: Nonkey

Note: This Question is unanswered, help us to find answer for this one

67. The imagery of the triumph of death served as a warning against ____.

Hermits.

Lust and greed.

Marriage.

Diseases

Answer

Correct Answer: Lust and greed.

Note: This Question is unanswered, help us to find answer for this one

68. _____ are normally expressed in the form of rules.

Attributes

Entities

Relationships

Constraints

Answer

Correct Answer: Constraints

Note: This Question is unanswered, help us to find answer for this one

69. The maximum number of columns that can be specified for sorting data is ____.

225

Answer

Correct Answer: 225

Note: This Question is unanswered, help us to find answer for this one

70. attributes can have many values. attributes can have several values.

Composite.

Simple

Single-valued. .

Multivalued.

Answer

Correct Answer: Multivalued.

Note: This Question is unanswered, help us to find answer for this one

71. The ____ operator is inclusive, meaning that a value equal to either end would be selected.

AND

BETWEEN

NOT

Answer

Correct Answer: BETWEEN

Note: This Question is unanswered, help us to find answer for this one

72. The ____ macro action will move the focus to a specific control.

GoToControl

Entity

Attribute

Node

Answer

Correct Answer: GoToControl

Note: This Question is unanswered, help us to find answer for this one

73. The operators =, <, >, <=, >=, and <> are referred to as ____ operators.

Multiple-row

Single-row

Correlated

Multiple column

Answer

Correct Answer: Single-row

Note: This Question is unanswered, help us to find answer for this one

74. In the context of select subquery types, a _____ is returned when an update subquery is used.

NULL

Single value

List of values

Virtual table

Answer

Correct Answer: Virtual table

Note: This Question is unanswered, help us to find answer for this one

75. A ____ is a query (select statement) inside a query.

Set query.

Asequery

Join

Subquery

Answer

Correct Answer: Subquery

Note: This Question is unanswered, help us to find answer for this one

76. ____ might be represented with a multivalued attribute.

Household phone number(s)

An employee’s educational background

A car’s color(s)

A person’s social security number

Answer

Correct Answer: A person’s social security number

Note: This Question is unanswered, help us to find answer for this one

77. A ____ attribute can have only one value.

Composite

Simple

Single valued

Multivalued

Answer

Correct Answer: Single valued

Note: This Question is unanswered, help us to find answer for this one

78. The basic form of the sql select command is ____.

FROM-SELECT-WHERE

SELECT-FROM-WHERE

FROM-WHERE-SELECT

WHERE-SELECT-FROM

Answer

Correct Answer: SELECT-FROM-WHERE

Note: This Question is unanswered, help us to find answer for this one

79. The majority of primary memory resources will be allocated to the ____ cache.

Data

Sort

SQL

Optimizer

Answer

Correct Answer: Data

Note: This Question is unanswered, help us to find answer for this one

80. ____ is a generic entity type that is related to one or more entity subtypes.

Inheritance

A specialization hierarchy

Subgroup

An entity supertype

Answer

Correct Answer: An entity supertype

Note: This Question is unanswered, help us to find answer for this one

81. The aggregate function which returns the number of nonnull field values is the ____ function.

Count

Group

DISTINCT

ORDER BY

Answer

Correct Answer: Count

Note: This Question is unanswered, help us to find answer for this one

82. If a column alias contains a blank space, it must be enclosed in ____.

Single quotation marks

Asterisks

Double quotation marks

Answer

Correct Answer: Double quotation marks

Note: This Question is unanswered, help us to find answer for this one

83. A transaction is a ____ unit of work that must be either entirely completed or aborted.

Timed

Practical

Logical

Physical

Answer

Correct Answer: Logical

Note: This Question is unanswered, help us to find answer for this one

84. The command to delete a view is ____.

DROP VIEW

DELETE VIEW

REMOVE VIEW

REVOKE VIEW

Answer

Correct Answer: DROP VIEW

Note: This Question is unanswered, help us to find answer for this one

85. You can use the ____ command to create a new table using data in an existing table.

CREATE TABLE

NEW TABLE

UPDATE

ALTER TABLE

Answer

Correct Answer: CREATE TABLE

Note: This Question is unanswered, help us to find answer for this one

86. In sql, you use the ____ command to query a database.

WHERE

SELECT

FROM

SET

Answer

Correct Answer: SELECT

Note: This Question is unanswered, help us to find answer for this one

87. In oracle, use the ____ command to display the structure of a table.

SHOW TABLE

SHOW LAYOUT

DESCRIBE

DISPLAY LAYOUT

Answer

Correct Answer: DESCRIBE

Note: This Question is unanswered, help us to find answer for this one

88. A(n) ____ might be written by a programmer or it might be created through a dbms utility program.

Query.

Operating system

Database managemen

Application program

Answer

Correct Answer: Application program

Note: This Question is unanswered, help us to find answer for this one

89. A ____ read is an added statement that gets the first input value in a program.

Priming

Loop-controlling

Sequence

Nesting

Answer

Correct Answer: Priming

Note: This Question is unanswered, help us to find answer for this one

90. The implicit beginning of a transaction is ____.

When the database is started

When a table is accessed for the firsttime

When the first SQL statement is encountered

When the COMMIT command is issued

Answer

Correct Answer: When the first SQL statement is encountered

Note: This Question is unanswered, help us to find answer for this one

91. The extended entity relationship model (eerm) is sometimes referred to as the _____.

Enclosed entity relationship model

Enhanced entity relationship model

Entity clustering relationship

Extended entity relationship

Answer

Correct Answer: Enhanced entity relationship model

Note: This Question is unanswered, help us to find answer for this one

92. The special operator used to check whether an attribute value is within a range of values is _____.

BETWEEN

NULL

Answer

Correct Answer: BETWEEN

Note: This Question is unanswered, help us to find answer for this one

93. The special operator used to check whether a subquery returns any rows is ____.

BETWEEN

EXISTS

Answer

Correct Answer: EXISTS

Note: This Question is unanswered, help us to find answer for this one

94. To delete rows from the database, use the ____ command.

ROLLBACK

COMMIT

DELETE

None of these

Answer

Correct Answer: DELETE

Note: This Question is unanswered, help us to find answer for this one

95. The sdlc phase in which the detailed conceptual data model is created is the ________ phase.

Planning

Design

Analysis

Implementation

Answer

Correct Answer: Analysis

Note: This Question is unanswered, help us to find answer for this one

96. Surrogate primary keys are especially helpful when there is no _____ key.

Natural

Natural identifier

Redundant

Unique

Answer

Correct Answer: Natural

Note: This Question is unanswered, help us to find answer for this one

97. To change rows for which a specific condition is true, use the ____ command

WHERE

Query

LCASE

UCASE

Answer

Correct Answer: WHERE

Note: This Question is unanswered, help us to find answer for this one

98. The sql aggregate function that gives the arithmetic mean for a specific column is _____.

COUNT.

AVG.

MAX.

SUM. AVG

Answer

Correct Answer: AVG.

Note: This Question is unanswered, help us to find answer for this one

99. The syntax for the union query is ____.

Query + query

UNION (query, query)

UNION: query query

Query UNION query

Answer

Correct Answer: Query UNION query

Note: This Question is unanswered, help us to find answer for this one

100. To make changes to existing data in a table, you would use the ____ command.

DELETE

SELECT

UPDATE

CHANGE

Answer

Correct Answer: UPDATE

Note: This Question is unanswered, help us to find answer for this one

101. To concatenate character strings, you use the _____________ operator in a string expression.

FROM

Asterisk

DESC

Answer

Correct Answer: +

Note: This Question is unanswered, help us to find answer for this one

102. The ________ states that no primary key attribute may be null.

Referential integrity constraint

Entity integrity rule

Partial specialization rule

Range domain rule

Answer

Correct Answer: Entity integrity rule

Note: This Question is unanswered, help us to find answer for this one

103. In some database programs, a data file is referred to as a(n) ______.

Table

Unit

Record

Sheet

Answer

Correct Answer: Table

Note: This Question is unanswered, help us to find answer for this one

104. In databases information is organized in ________

System

System requirements

Vertical market

Tables, records, fields

Answer

Correct Answer: Tables, records, fields

Note: This Question is unanswered, help us to find answer for this one

105. In database systems, a table is also known as a _____.

Table

Column

Field

Record

Key

Answer

Correct Answer: Record

Note: This Question is unanswered, help us to find answer for this one

106. In database systems, a _____ defines the data that a table can hold.

File

Row

Key

Record

Field

Answer

Correct Answer: Field

Note: This Question is unanswered, help us to find answer for this one

107. In data modeling, a(n) ________ is something that the users want to store data about.

Entity

Store only the metadata about each video in the database

Columns

ACID

Answer

Correct Answer: Entity

Note: This Question is unanswered, help us to find answer for this one

108. In a relational database, a row can be referred to as a(n) ____.

Tables

Tuple

First

Answer

Correct Answer: Tuple

Note: This Question is unanswered, help us to find answer for this one

109. Changing the database design to improve the performance is called ____.

Tuning the design

Primary and foreign

Concurrent update

Data archive

Answer

Correct Answer: Tuning the design

Note: This Question is unanswered, help us to find answer for this one

110. Another name for a database server-side extension program is _____.

A database application server

A web server

Web-to-database middleware

A web application middleware

Answer

Correct Answer: Web-to-database middleware

Note: This Question is unanswered, help us to find answer for this one

111. A(n) ____ lock will prevent any ddl operations from being performed on the locked table.

UPDATE

Exclusive

ROLLBACK

False

Answer

Correct Answer: Exclusive

Note: This Question is unanswered, help us to find answer for this one

112. A natural key is also called a(n) ____ key.

Surrogate

Intelligent

Secondary

Defining

Answer

Correct Answer: Intelligent

Note: This Question is unanswered, help us to find answer for this one

113. A file (table) is a collection of related ________.

Fields

Records

Characters

Metadata

Answer

Correct Answer: Records

Note: This Question is unanswered, help us to find answer for this one

114. A database holds related file data in ____ .

True

Text File

Fields

Tables

Answer

Correct Answer: Tables

Note: This Question is unanswered, help us to find answer for this one

115. A database _____.

Is a collection of integrated and related files

Is a collection of integrated and related bit

Is a collection of integrated and related flat files

Is a collection of integrated and related choice

Answer

Correct Answer: Is a collection of integrated and related files

Note: This Question is unanswered, help us to find answer for this one

116. A database _____________is organized into rows and columns.

Grid

Matrix

Table

Spreadsheet

Answer

Correct Answer: Table

Note: This Question is unanswered, help us to find answer for this one

117. A data warehouse ____ data from several databases to provide useful information.

Merges

File

Field

Record

Answer

Correct Answer: Merges

Note: This Question is unanswered, help us to find answer for this one

118. A data administrator is also known as a(n) _____.

Data security officer

Systems administrator

Information resource manager

Information engineering officer

Answer

Correct Answer: Information resource manager

Note: This Question is unanswered, help us to find answer for this one

119. A _____ relationship exists when three entities are associated.

Unary

Weak

Binary

Ternary

Answer

Correct Answer: Ternary

Note: This Question is unanswered, help us to find answer for this one

120. A ____ key is defined as a key that is used strictly for data retrieval purposes.

Lookup

Foreign

Candidate

Secondary

Answer

Correct Answer: Secondary

Note: This Question is unanswered, help us to find answer for this one

121. A ____ is a storage structure designed to hold a collection of data.

Column

Row

Table

Database

Answer

Correct Answer: Database

Note: This Question is unanswered, help us to find answer for this one

122. 1nf, 2nf, and 3nf are ____.

Normalization stages

Relational databases

Relatoinal models

Answer

Correct Answer: Normalization stages

Note: This Question is unanswered, help us to find answer for this one

123. ________ is a tool even non-programmers can use to access information from a database.

Repository.

Structured query language

Unstructured and unpredictable use of data

Enterprise data modeling

Answer

Correct Answer: Structured query language

Note: This Question is unanswered, help us to find answer for this one

124. _____ provide a unified, single point of entry for information distribution.

Decision support systems

Portals

Data warehouses

Dashboards

Answer

Correct Answer: Portals

Note: This Question is unanswered, help us to find answer for this one

125. ____ view provides the most options for defining fields.

Field Create

Field Define

Table Create

Table Design

Answer

Correct Answer: Table Design

Note: This Question is unanswered, help us to find answer for this one

126. ____ reduces the size of a database and makes the data easier to work with.

Normalization

Centerlization

Both

None of these

Answer

Correct Answer: Normalization

Note: This Question is unanswered, help us to find answer for this one

127. ____ means that an entity has a minimum cardinality of one.

The entity is required in the relationship.

The entity is not required in the relationship.

The entity should not be in the relationship as an attribute.

The entity must be listed with all ones in the data fields

Answer

Correct Answer: The entity is required in the relationship.

Note: This Question is unanswered, help us to find answer for this one

128. ____ keys work with primary keys to properly implement relationships in the relational model.

Foreign

Composite

Natural

Surrogate

Answer

Correct Answer: Foreign

Note: This Question is unanswered, help us to find answer for this one

129. ____ is the formal term for combining two or more columns to form a primary key.

Inconsistent data

RELATIONSHIPS

Concatenation

Update anomalies

Answer

Correct Answer: Concatenation

Note: This Question is unanswered, help us to find answer for this one

130. ____ describes how instances of one entity relate to instances of another entity.

Scalability

Compatibility

Cardinality

Functionality

Answer

Correct Answer: Scalability

Note: This Question is unanswered, help us to find answer for this one

131. ____ data exist in the format in which they were collected.

Unstructured

Attribute

Enterprise

Object-oriented

Answer

Correct Answer: Unstructured

Note: This Question is unanswered, help us to find answer for this one

132. ____ data can have only a true or false (yes or no) values.

Logical

Character

Date

Numeric

Answer

Correct Answer: Logical

Note: This Question is unanswered, help us to find answer for this one

133. ____ case tools provide support for the coding and implementation phases.

Horizontal

Front-end

Back-end

Vertical.

Answer

Correct Answer: Back-end

Note: This Question is unanswered, help us to find answer for this one

134. Fields in the query design grid include all of the following except ________.

Enforce Referential Integrity is checked

Pound signs (#)

Fields that are listed as Primary Keys

Housing market

Answer

Correct Answer: Fields that are listed as Primary Keys

Note: This Question is unanswered, help us to find answer for this one

135. In _________________________ no row may contain two or more multivalued facts about an entity.

5NF

3NF

4NF

2NF

Answer

Correct Answer: 4NF

Note: This Question is unanswered, help us to find answer for this one

136. The crow's foot symbol with two vertical parallel lines indicates _____ cardinality.

(0,N)

(1,N)

(1,1)

(0,1)

Answer

Correct Answer: (1,1)

Note: This Question is unanswered, help us to find answer for this one

137. The estimated percentage of unsolicited email of all email is approximately ____ percent.

Answer

Correct Answer: 70

Note: This Question is unanswered, help us to find answer for this one

138. ____ are important because they help to ensure data integrity

Constraints

Attributes

Entities

Relationships

Answer

Correct Answer: Constraints

Note: This Question is unanswered, help us to find answer for this one

139. ____ attributes can have many values.

Simple

Single-valued

Multivalued

Composite

Answer

Correct Answer: Multivalued

Note: This Question is unanswered, help us to find answer for this one

Database MCQs | Topic-wise

MCQ on Advance Database	MCQ on Basic Database
MCQ on Database Administration	MCQ on Database Application
MCQ on Database Concepts	MCQ on Database Management System
MCQ on Database Management System (DBMS)	MCQ on Database Organization & Design
MCQ on Introduction to Database	MCQ on Modern Database Management
MCQ on SQL Server DBA	MCQ on SQL Server Database
MCQ on Window Server 2003	General Database MCQs

Database Subjects

Database Administration MCQs

Database Management System MCQs

Database Management System (DBMS) MCQs

SQL Server Database MCQs

SQL Server DBA MCQs

Window Server 2003 MCQs

Advance Database MCQs

Introduction to Database MCQs

Database Concepts MCQs

Database Application MCQs

Modern Database Management MCQs

Basic Database MCQs

More Resources

Database MCQ

Database Skill Assessment

Database PDF

Related MCQs

ADO.NET MCQs

CMDB MCQs

Data Virtualization MCQs

NoSQL MCQs

Transact-SQL (T-SQL) MCQs

Database Organization & Design MCQ

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

20. The ____ wildcard symbol represents any individual character.

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

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

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

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

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

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

27. Access does not support the ____ data type.

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

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

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

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

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

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

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

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

36. Use the ________ tag to configure a section of a web page that is physically separated from others.

37. The term "____" is used to label any condition in which one or more optional relationships exist.

38. The existence of a(n) __________ entity indicates that its minimum cardinality is zero.

39. A(n) _____ is the equivalent of a field in a file system.

40. Business rules are derived from ____.

41. Some ____ database modeling concepts can be expressed only using the chen notation.

42. One of the limitations of the ____ model is that there is a lack of standards.

43. A(n) ____ model represents a global view of the database as viewed by the entire organization.

44. A derived attribute is indicated in the chen model by a ____.

45. A(n) ____ is an ordered arrangement of keys and pointers.

46. A union combines the rows from two or more _______________________.

47. A(n) ____'s main function is to help you understand the complexities of the real-world environment.

48. A(n) _____ develops when all required changes in the redundant data are not made successfully.

49. A(n) ____ is a system-generated primary key that is usually hidden from users.

50. A(n) ____ clause cannot include a group function.

51. When using the oracle to_date function, the code _____ represents a three-letter month name.

52. In the figure above, if you only want to set one criterion for this filter, you will ____.

53. In oracle, the _____ function converts a date to a character string.

54. Date attributes contain calendar dates stored in a special format known as the _____ date format.

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

56. A person?s social security number would be an example of a(n) ____________________ attribute.

57. A(n) ____ is the association between entities.

58. The proper use of ____________________ keys is crucial to controlling data redundancy.

59. A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.

60. In relational database design, id-dependent entities are used to ________.

61. The ____ operator finds rows that do not contain a null value in the specified column.

62. ____ means that an entity has a minimum cardinality of zero.

63. Sql was developed under the name ____ at the ibm san jose research facilities.

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

65. At tal distributors, there is a ____ relationship between sales reps and customers.

66. A ____ column is a column that is not part of the primary key.

67. The imagery of the triumph of death served as a warning against ____.

68. _____ are normally expressed in the form of rules.

69. The maximum number of columns that can be specified for sorting data is ____.

70. ____ attributes can have many values. ____ attributes can have several values.

71. The ____ operator is inclusive, meaning that a value equal to either end would be selected.

72. The ____ macro action will move the focus to a specific control.

73. The operators =, <, >, <=, >=, and <> are referred to as ____ operators.

74. In the context of select subquery types, a _____ is returned when an update subquery is used.

75. A ____ is a query (select statement) inside a query.

76. ____ might be represented with a multivalued attribute.

77. A ____ attribute can have only one value.

78. The basic form of the sql select command is ____.

79. The majority of primary memory resources will be allocated to the ____ cache.

70. attributes can have many values. attributes can have several values.