> > Database MCQs > Introduction to Database MCQs

Introduction to Database MCQ

Introduction to Database

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

Logical

Physical

Conceptual

Network

Answer

Correct Answer: Physical

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

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

NEXTVAL

DUAL

CURRENTVAL

CURRVAL

Answer

Correct Answer: CURRVAL

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

3. In addition to standard colors, the font color gallery displays ____ colors.

Johns

Theme

False

Control

Answer

Correct Answer: Theme

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

4. In a microsoft access database, the gettysburg address would be stored in a(n) ________ field.

Text.

Long text.

Short text.

Object

Answer

Correct Answer: Long text.

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

5. If a security warning appears when you open a database, click the ____ button.

Customize

Enable Content

Security

Unlock

Answer

Correct Answer: Enable Content

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

6. Designing to omit ____________________ will help to produce good and valid database designs.

Redundancy

Primary keys

Errors

Size

Answer

Correct Answer: Redundancy

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

7. Database redesign is fairly easy when ________.

Information systems and organizations influence each other

The design was done correctly the first time

There is no data in the database

Good backups of the database are available

Answer

Correct Answer: There is no data in the database

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

8. Data stored on disks is easier and faster to locate than data on magnetic tapes because ________.

Disks have larger and more efficient storage capacities as there are more than three levels of cache

Disks have both mechanical and electronic parts

Magnetic tapes store data in tiny magnetic spots with smaller wavelengths

Computers do not have to scan an entire tape to find a specific data file when using disks

Answer

Correct Answer: Computers do not have to scan an entire tape to find a specific data file when using disks

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

9. Colonial adventure tours organizes day-long guided trips to ____.

Colorado

New England

Virginia

Pennsylvania

Answer

Correct Answer: New England

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

10. An integer format uses ____ bits to represent the number 12,345 in binary form.

Answer

Correct Answer: 16

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

11. Each record in a table is uniquely identified by a foreign key. _________________________

True

False

Answer

Correct Answer: False

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

12. The identifier of the entity becomes the ________ of the corresponding table

Primary key

Foreign key

Supertype

Subtype

Answer

Correct Answer: Primary key

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

13. The erm forms the basis of a(n) ___________________________________.

Fan trap

An entity supertype

ERD, Entity Relationship Diagram

A single abstract entity object

Answer

Correct Answer: ERD, Entity Relationship Diagram

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

14. The data model produced by reverse engineering is a(n) ________.

Conceptual schema

Internal schema

Dependency graph

Table-relationship diagram

Answer

Correct Answer: Table-relationship diagram

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

15. The contents of query datasheet are permanent. ____________________

True

False

Answer

Correct Answer: False

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

16. To ____________________ a document means to make changes to its existing content.

Format

Save

Edit

Answer

Correct Answer: Edit

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

17. In a database, first name would be an example of a ____.

File

Table

Relation

Field

Answer

Correct Answer: Field

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

18. In a database, bytes are grouped into __________.

Tables

Columns

Rows

Records

Answer

Correct Answer: Columns

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

19. ____ is a relational set operator.

MINUS

PLUS

EXISTS

ALL

Answer

Correct Answer: MINUS

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

20. The appearance of fields in a report that is created using the report wizard is determined by ____.

The order of the fields in the table being used for the report

The data type of each field in the table

The size of each field in the table

The order the fields are selected in the Report Wizard

Answer

Correct Answer: The order the fields are selected in the Report Wizard

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

21. The order line in a tal distributors order form contains a total that is called a(n) ____.

Footing

Extension

Trailer

Sum

Answer

Correct Answer: Extension

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

22. 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

23. A field whose data type is ____ can store text that can be used as a hyperlink address

URL

Web

Placeholder

Hyperlink

Answer

Correct Answer: Hyperlink

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

24. You would use a ________ to temporarily display records of residents of the city of boston.

Sieve

Filter

Validation rule

Field constraint

Answer

Correct Answer: Filter

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

25. The report wizard allows detail records to be sorted by up to four fields. ____________________

True

False

Answer

Correct Answer: True

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

26. The first field specified in the sorting process is called the ____________________ field.

Primary sort

Navigation

Recordset

None of these

Answer

Correct Answer: Primary sort

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

27. Primary keys ensure that ____.

Duplicate records are not stored in the database

Duplicate records are stored in the database

Duplicate records removed in the database

None of these

Answer

Correct Answer: Duplicate records are not stored in the database

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

28. The _____ section in the lower half of the work area displays the properties for the active field.

Field Properties

Field Size

Field selector bar

None of these

Answer

Correct Answer: Field Properties

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

29. Join types may be changed using the join types button available in the ____ dialog box.

Edit relationships

A single field

Append

Make-table

Answer

Correct Answer: Edit relationships

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

30. To begin importing data from an excel spreadsheet, click on the ____ tab on the ribbon.

External Data

Caption

Default value

Store data

Answer

Correct Answer: External Data

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

31. Fields that contain numbers that are not used in calculations should be set to ________.

Short text

Print Preview

Database

A single record form

Answer

Correct Answer: Short text

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

32. Fields included in a query may be modified after the query is saved. ____________________

True

False

Answer

Correct Answer: True

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

33. The form control that appears in the access window with tabs at the top is the ____ control.

Subform

Combo Box

Web Browser

Tab

Answer

Correct Answer: Tab

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

34. The default group in the navigation pane is ____.

Object Type

All Access Objects

Table

Design Grids

Answer

Correct Answer: All Access Objects

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

35. The ""one"" table in a one-to-many relationship is the ____________________ table.

Primary

Secandry

Single

Multi

Answer

Correct Answer: Primary

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

36. Formatting date/time fields changes only the way data is displayed, not the field ____.

Values

Letters

Numbers

Mask

Answer

Correct Answer: Values

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

37. Experian, equifax, and transunion are all types of ______ companies.

Credit reporting

Check digit

Benchmark

Dictionary

Answer

Correct Answer: Credit reporting

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

38. Every normalized table has ________.

Duplicated data

Repeating fields

Data integrity problems

Multiple topics

A single theme

Answer

Correct Answer: A single theme

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

39. The ________ view in access looks similar to an excel spreadsheet.

Datasheet

Filter by Form

Report

Report Wizard

Answer

Correct Answer: Datasheet

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

40. Having several instances of the same data is called data _______.

Repetition

Duplication

Doubling

Redundancy

Answer

Correct Answer: Redundancy

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

41. In access, table and field names can be up to ____ characters in length.

128

Answer

Correct Answer: 64

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

42. In a student database, a good key field for a record would be a ______

Name of the student's first pet

Student's name

Student ID#

Student's GPA

Answer

Correct Answer: Student ID#

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

43. In a database, a group of similar rows is called a ________.

File

Table

Relation

Fields

Answer

Correct Answer: Table

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

44. In a database table, each row is called a(n) and each column is called a .

Web layout view

Select the text.

Ones and zeros

Record, field

Answer

Correct Answer: Record, field

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

45. With a _____, users provide an example of the data requested.

Query by example language

data table

data frame

Query language

Answer

Correct Answer: Query by example language

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

46. The most popular search engines such as google use ____ to store information about webpages.

Database

Hard disck

Cloud

None of these

Answer

Correct Answer: Database

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

47. The size of a database is determined by the _____.

Amount of raw data in the tables

Amount of raw data in the tables and overhead requirements for the DBMS

Number of instances in the tables

Overhead requirements for the DBMS

Overhead requirements for the DBMS and number of instances in the tables

Answer

Correct Answer: Amount of raw data in the tables and overhead requirements for the DBMS

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

48. The _____ command defines a default value for a column when no value is given.

CHECK

UNIQUE

NOT NULL

DEFAULT

Answer

Correct Answer: DEFAULT

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

49. In asps, the code to tie the database to the web site is typically written in javascript or ____.

BasicScript

PHP

CGI

VBScript

Answer

Correct Answer: VBScript

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

50. In a doubly nested set of not exists select statements, ________.

If a row does not not match any row, then it matches every row

If a row matches any row, then it matches every row

If a row does not match any row, then it does not match every row

If a row matches any row, then it does not match every row

Answer

Correct Answer: If a row does not not match any row, then it matches every row

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

51. A(n) ______ is a number(s) or character(s) appended to or inserted in a primary key value.

Validator

Value-addc

Addressd

Check digit

Answer

Correct Answer: Check digit

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

52. A(n) _____ can use a shared connection to the database instead of creating a new one every time.

API

Web browser

HTTP GET request

DLL

Answer

Correct Answer: API

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

53. _____ use a keyword to encode a number.

Cipher

Identifier

Encryption

Associative

Answer

Correct Answer: Cipher

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

54. A join line is also called a(n) ____ line.

Query

Link

Connection

Objectivity

Answer

Correct Answer: Link

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

55. A multilevel sort calls for using the ____ feature.

Custom sort

Multi-sort

Alpha-sort

Data sort

Answer

Correct Answer: Custom sort

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

56. ____ codes combine data from different item attributes, or characteristics, to build the code.

Sequence

57. You can restrict the output from a join to include only certain columns by using the ____ command.

DELETE

PROJECT

UNION

INTERSECTANS

Answer

Correct Answer: DELETE

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

58. The field ______ defines the maximum number of characters a field can contain.

Length

Width

Capacity

Size

Answer

Correct Answer: Size

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

59. In a database, the collection of data for all columns is called a ________.

Record

Field

File

Table

Answer

Correct Answer: Record

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

60. Any attribute that is part of a key is known as a ____.

Important

Nonprime

Prime

Entity

Answer

Correct Answer: Prime

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

61. The ____ structure is quite different from that of an operational or transactional database.

Data warehouse

Data inpendence

Field content

Field value

Answer

Correct Answer: Data warehouse

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

62. The preferred placement for a foreign key when working with a 1:1 relationship is to ____.

Use the same primary key for both entities

Create a bridge entity

Place a foreign key in one of the entities

Place a foreign key in both entities

Answer

Correct Answer: Place a foreign key in one of the entities

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

63. In the accompanying figure, the small box or bar to the left of each field is called the ____.

Row selector

Data warehouse

Data inpendence

None of these

Answer

Correct Answer: Row selector

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

64. A field used to connect one table logically with another table is called a ____ field.

Common

Primary

Composite

Data

Answer

Correct Answer: Common

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

65. A(n) _____ represents a particular type of object in the real world.

Entity

Attribute

Node

Relationship

Answer

Correct Answer: Entity

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

66. Designing tables is easier if a _____ is used to show a table?s structure, fields, and primary key.

Standard notation format

Foreign key

Candidates key

Nonkey field

Answer

Correct Answer: Standard notation format

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

67. A(n) ____ is a property of an entity.

Field

Attribute

Column

All of the above

Answer

Correct Answer: All of the above

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

68. A collection of related records in a database is referred to as a _____.

Table

Forms

Data Type

Database

Answer

Correct Answer: Table

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

69. A _____ is a character or group of characters that has a specific meaning.

File

Database

Record

Field

Answer

Correct Answer: Field

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

70. Dial-up internet access is an example of a(n) ____ communications system.

Broadband

Narrowband

Slowband

Internet

Answer

Correct Answer: Narrowband

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

71. Databases are stored in ______ so that they are available when needed.

Data dashboards

Data mines

Data sources

Data warehouses

Data matrices

Answer

Correct Answer: Data warehouses

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

72. Database management systems _____.

Are used to create, organize, and manage databases

Improve routing and delivery schedules of databases

Are written for specific database applications

Include transaction-processing reports for database analysis

Answer

Correct Answer: Are used to create, organize, and manage databases

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

73. Ancient romans believed that their ancestry ____.

Was extremely important

Was not as important as their progeny

Was to be documented in writing

Was not important at all

Answer

Correct Answer: Was extremely important

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

74. An attribute that is part of a key is known as a(n) _____ attribute.

Important

Nonprime

Prime

Entity

Answer

Correct Answer: Prime

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

75. All of this information is part of a ____ in a database

Record

Row

Column

Field

Answer

Correct Answer: Record

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

76. Access saves ____ automatically as you move from record to record.

Data

Tables

Queries

All of the above

Answer

Correct Answer: Data

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

77. Access database objects are divided into categories on the navigation pane. ____________________

True

False

Answer

Correct Answer: True

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

78. A(n) _____ is a good comparison to a database.

Computerized calculator

Computerized typewriter

Office desktop

Computerized file cabinet

Answer

Correct Answer: Computerized file cabinet

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

79. A(n) ____ stores a query and is used to access data in the underlying tables.

View

Constraint

Function

Argument

Answer

Correct Answer: View

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

80. A(n) ____ query adds records form existing tables or queries to the end of another table.

Append

Update

Null

Append To

Answer

Correct Answer: Append

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

81. A(n) ____ join only returns matched records from the tables that are being joined.

Outer

Inner

Direct

Union

Answer

Correct Answer: Inner

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

82. A(n) ____ is the equivalent of a field in a file system.

Attribute

Entity

Relationship

Constraint

Answer

Correct Answer: Attribute

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

83. A(n) ____ field is a field that can be computed from other fields.

Aggregate

Combined

Total

Calculated

Answer

Correct Answer: Calculated

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

84. A weak entity must be ____________________-dependent.

Existence

Information

Atomicity

Foreign

Answer

Correct Answer: Existence

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

85. A summary query calculates statistics about ____.

One record

Groups of records

One field

Groups of fields

Answer

Correct Answer: Groups of records

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

86. A musical tells a story using ______.

Dream imagery

Intergrated dialogue

Puppets and stop-motion

A dialog, dance & songs

Answer

Correct Answer: A dialog, dance & songs

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

87. A form that is contained within another form is called a(n) ____.

Subform

Arrange

Title

Blank Form

Answer

Correct Answer: Subform

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

88. A form must be displayed in ____________________ view to navigate, view, and edit data.

Office

Join

Form

FORMAT

Answer

Correct Answer: Form

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

89. A field whose data type is ____ can contain any characters.

Alpha

Character

Normal Selected

Short Text

Answer

Correct Answer: Short Text

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

90. A field or a group of fields that make a record unique in a table is called a(n) ________.

Primary key

Autonumber

Central entity

Attribute record

Answer

Correct Answer: Primary key

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

91. A field in an access database table that has no value is determined by access to have a ____ value.

Custom

Zero

Null

Number

Answer

Correct Answer: Null

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

92. A domain name is a unique text-based internet address corresponding to a unique ________.

IP address

Domain name

URL

User name

Answer

Correct Answer: IP address

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

93. A database program helps to ____________.

Organize, send, and retrieve e-mails quickly

Deliver elegant presentations to a large audience easily

Create professional documents with an intuitive WYSIWYG interface

Organize, store, and retrieve large amounts of information easily

Answer

Correct Answer: Organize, store, and retrieve large amounts of information easily

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

94. A data ______ contains data about each file in the database and each field in those files.

Encyclopedia

Reference

Guide

Dictionary

Answer

Correct Answer: Dictionary

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

95. A ________ displays a subset of data from a table (or tables) based on the specified criteria.

Table query

Join query

Select query

Criteria query

Answer

Correct Answer: Select query

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

96. A _____ stores information on a customer's computer.

Server-side digital wallet

Mobile-based digital wallet

Hardware-based digital wallet

Client-side digital wallet

Answer

Correct Answer: Client-side digital wallet

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

97. A _____ is simply a copy of the information stored on a computer.

Duplicate

Backup

Photocopy

Replica

Answer

Correct Answer: Backup

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

98. A ____ router can build tables that identify addresses on each network.

Pervasive

Passived

Dynamic

Static

Answer

Correct Answer: Dynamic

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

99. A ____ operation searches data in a table and retrieves records based on certain criteria.

Join

Project

Find

Select

Answer

Correct Answer: Select

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

100. A ____ is a place where a record of certain corporate data is kept.

depository

data archive

storage

Data bank

Answer

Correct Answer: data archive

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

101. __________ is an extreme form of a targeting strategy.

Macromarketing

Micromarketing

Benefit marketing.

Differentiated targeting

Concentrated targeting

Answer

Correct Answer: Micromarketing

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

102. ________ specifies the characteristics of a field, such as the type of data it will hold.

Data definition

A record

Database architecture

An entity

Answer

Correct Answer: Data definition

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

103. _____ are numbers or letters assigned in a specific order.

Sequence codes

Category codes

Significant digit codes

Derivation codes

Answer

Correct Answer: Sequence codes

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

104. ____ generally uses internal data and responds in real time.

QBE

OLAP

SQL

OLTP

Answer

Correct Answer: OLAP

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

105. Attributes of an entity-relationship data model are best used to describe __________.

Characteristics of entities

Database

Can be used to read, insert, modify, and delete database data.

Store data in more than one location (thats traditional

Answer

Correct Answer: Characteristics of entities

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

106. A table can be deleted from the database by using the _____ command.

DROP

DELETE

MODIFY

ERASE

Answer

Correct Answer: DROP

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

107. An atomic attribute _____.

Cannot exist in a relational table

Cannot be further subdivided

Displays multiplicity

Is always chosen to be a foreign key

Answer

Correct Answer: Cannot be further subdivided

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

108. Normalization is normally done to ___ normal form.

First normal form 1NF

Second normal form 2NF

Third normal form 3Nf

Fourth normal form 4NF

Answer

Correct Answer: Second normal form 2NF

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

109. The most common use of nonrelational database management systems is for__________________.

Structured Query Language

Extremely large data sets

Entity-relationship diagram

In-memory computing

Answer

Correct Answer: Extremely large data sets

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

110. _____, a coding method that uses one byte per character, is used on most personal computers.

EBCDIC (Extended Binary Coded Decimal Interchange Code)

ASCII (American Standard Code for Information Interchange)

Unicode

ISO (International Organization for Standardization) 10646

Answer

Correct Answer: EBCDIC (Extended Binary Coded Decimal Interchange Code)

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

111. A relationship is an association between _____.

Fields

Objects

Databases

Entities

Answer

Correct Answer: Entities

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

112. Mauna ___ crossword

LOA

KEA

NUCLEOSIS

ARS

Answer

Correct Answer: LOA

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

113. General ___ chicken crossword

TSOS

HOTPOT

TENDERS

POX

Answer

Correct Answer: TSOS

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

114. England's isle of ___ crossword

ELY

CAY

SKYE

MAUI

Answer

Correct Answer: ELY

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

115. Dies ____ crossword

IRAE

ACTV

EBBS

DONNE

Answer

Correct Answer: IRAE

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

116. Christii___

ANNO

CORPUS

NEE

Answer

Correct Answer: ANNO

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

117. California's point ___ crossword

REYES

EYERS

EYRES

SUR

Answer

Correct Answer: REYES

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

118. ___ nous crossword

ENTRE

WIT

GUMPTION

ILS

Answer

Correct Answer: ENTRE

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

119. ___ la la crossword

TRA

OOH

REFRAIN

TIS

Answer

Correct Answer: TRA

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

120. ___ fly crossword

SAC

TSETSE

LET

FRUIT

Answer

Correct Answer: SAC

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

121. ___ bator crossword

ULAN

LAN

ASST

None of these

Answer

Correct Answer: ULAN

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

122. ___ avis

RARA

BIRD

ALAMO

HERTZ

Answer

Correct Answer: RARA

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

123. Microsoft access 2016 can best be described as ____ software.

Database

Presentation

Systems

Spreadsheet

Answer

Correct Answer: Database

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

124. Design view is used to ____ a table.

Create or modify the structure of

Select the appropriate table or query object

Extract data from one or more tables

Click the Build button in the Input Mask property box for the desired field

Answer

Correct Answer: Create or modify the structure of

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

125. A chart created with the access chart wizard is ____ in access.

Tab Stop

Page Header

,(comma)

Embedded

Answer

Correct Answer: Embedded

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

126. A ____ field is used when you want to restrict the data entered into the field to a list of values.

Lookup

Totals button

Number

Field Properties

Answer

Correct Answer: Lookup

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

127. Ebcdic and ascii both require _____ bits for storage of each character.

twelve

six

sixteen

Eight

Answer

Correct Answer: Eight

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

128. Batch processing is defined as ________.

The sequential execution of operations on each record in a large set

The arrangement of data in a table as records and fields

The removal of duplicates from a set of data

The strategy of defining and linking records

Answer

Correct Answer: The sequential execution of operations on each record in a large set

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

129. In comparison to a flat file system, in a database, _____.

Storage space is reduced

Programs and data are interdependent

Complex requests cannot be handled easily

Data redundancy is introduced

Answer

Correct Answer: Storage space is reduced

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

130. The wi-fi alliance calls 802.11i ________.

802.1x.

802.11s.

802.11X.

WPA.

WPA2

Answer

Correct Answer: WPA2

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

131. In a real-world environment, we must strike a balance between design integrity and ____.

Robustness

Flexibility

Uniqueness

Ease of use

Answer

Correct Answer: Flexibility

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

132. A table that is in 2nf and contains no transitive dependencies is said to be in _____.

1NF

2NF

3NF

4NF

Answer

Correct Answer: 3NF

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

133. A derived attribute ____.

Must be stored physically within the database

Need not be physically stored within the database

Has many values

Must be based on the value of three or more attributes

Answer

Correct Answer: Need not be physically stored within the database

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

134. The three essential elements of the definition of a database are ________.

Keep track of things that involve multiple themes

Store only the metadata about each video in the database

tables; relationship among rows in tables; metadata

Changing a relationship from 1:N to N:M is simply a matter of changing the notations

Answer

Correct Answer: tables; relationship among rows in tables; metadata

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

135. In the context of big data, _____ relates to differences in meaning.

Variety

Variability

Veracity

Viability

Answer

Correct Answer: Viability

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

136. A very large database that holds important data from a variety of sources is called a ____.

Data warehouse

Administrator

Data mining

Relational

Answer

Correct Answer: Data warehouse

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

137. Microsoft access is an example of _____ in an information system.

Internal data

External data

Database management system

Knowledge base management system

Answer

Correct Answer: Database management system

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

138. A _____represents a single, implicitly structured data item in a database.

Report

Numeric

Text

Record

Answer

Correct Answer: Record

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

139. The structure of the table can be displayed with the _________ command:

Describe

Desc

Dis

Desc and the Describe

Answer

Correct Answer: Describe

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

140. Metadata are ________.

Error logs of databases

Data that are encrypted.

Data that describe data

Codes used for server-side processing

Answer

Correct Answer: Data that describe data

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

141. A ________ view is materialized when referenced.

Virtual

Dynamic

Materialized

Base

Answer

Correct Answer: Dynamic

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

142. Major coding mistakes made by programmers when they write software are called ____.

Vaporware

Incompatibilities

Design flaws

Bugs

Answer

Correct Answer: Bugs

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

143. 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

144. A schema illustrates the and in a database and the relationships among them.

Records and fields

Bits and bytes

Tables and fields

Rows and columns

Answer

Correct Answer: Tables and fields

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

145. The _____ data type is compatible with number.

NOT IN

Subquery

CHAR(15)

SMALLINT

Answer

Correct Answer: SMALLINT

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

146. A struct variable can be passed as a parameter ____.

Only by const

Only by reference

Only by value

Either by value or by reference

Answer

Correct Answer: Either by value or by reference

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

147. A struct is typically a ____ data structure.

Simple

Linked

Heterogeneous

Dynamic

Answer

Correct Answer: Heterogeneous

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

148. The most common format used for data modeling is ________ diagramming.

Entity-class

Entity-object

Entity-subject

Entity-relationship

Answer

Correct Answer: Entity-relationship

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

149. Binary digits have only ____ possible value(s).

One

Two

Three

Five

Answer

Correct Answer: Two

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

150. ____ storage is not lost when a computer loses power.

Temporary

Intermediate

Permanent

Variable

Answer

Correct Answer: Permanent

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

151. A ____ is a group of interrelated files.

Record

Character

Field

Database

Answer

Correct Answer: Database

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

152. The ____ command removes the display of one or more fields in datasheet view.

Hide Fields

Unhide Fields

Remove Fields

Display Fields

Answer

Correct Answer: Remove Fields

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

153. A record is also called a ____.

Column

Field

Row

Record

Answer

Correct Answer: Row

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

154. Another term used for the column selector feature is ____.

Row selector.

Record selector.

Name selector.

Field selector

Answer

Correct Answer: Field selector

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

155. When a piece of data is written to a file, it is copied from a variable in ________ to the file.

Ram

Three

Length

None of these

Answer

Correct Answer: Ram

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

156. Sql is an example of a ________ style of programming language.

4gl

3gl

5gl

2gl

Answer

Correct Answer: 4gl

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

157. If an error occurs, each of the numeric functions returns a/an ____________ value.

Zero

Error

Null

None of these

Answer

Correct Answer: Null

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

158. For any column whose data type is char, values must be enclosed in ____.

Single quotation marks

Double quotation marks

Parentheses

Percent signs

Answer

Correct Answer: Single quotation marks

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

159. Voip uses ____ technology similar to email to transmit voice over the internet

Analog.

Binary.

Digital.

Answer

Correct Answer: Digital.

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

160. By default, parameters are defined as ______________ parameters.

Input/output

Input

Output

All of the above

Answer

Correct Answer: All of the above

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

161. A database is an organized collection of ________ related data.

Logically

Entity

User view

Partial specialization

Answer

Correct Answer: Logically

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

162. The first academy in europe started in the ____ century.

13th

14th

15th

16th

Answer

Correct Answer: 15th

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

163. A substantially rewritten software package that contains major new features is called a(n) ____.

New version

Configuration problem

Workaround

Update

Answer

Correct Answer: New version

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

164. The ____ operation is performed by the subtract command in relational algebra.

Union

Difference

Product

Intersection

Answer

Correct Answer: Difference

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

165. The ____ command within relational algebra takes a vertical subset of a table.

SELECT

DELETE

PROGRAM

PROJECT

Answer

Correct Answer: PROJECT

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

166. Microsoft azure sql is an example of a _________________ database.

Cloud

Network

Flat

Text

Local

Answer

Correct Answer: Cloud

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

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

GROUP BY

ORDER BY

HAVING

FROM

Answer

Correct Answer: HAVING

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

168. A primary key is a ____ within a database table that uniquely identifies each record.

Record

File

Field

None of these

Answer

Correct Answer: Field

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

169. The merge statement is sometimes referred to as the _________________ statement.

Subquery

Comma

Upsert

INTO

Answer

Correct Answer: Upsert

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

170. Lock ____ indicates the level of lock use.

Granularity

Shrinking

Growing

Serializability

Answer

Correct Answer: Granularity

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

171. A(n) ____ condition occurs when two or more transactions wait for each other to unlock data.

Deadlock

Exclusive lock

Binary lock

Two-phase lock

Answer

Correct Answer: Deadlock

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

172. A consistent database is ____.

One in which all tables have foreign keys

One in which all data integrity constraints are satisfied

One in which all tables are normalized

One in which all SQL statements only update one table at a time

Answer

Correct Answer: One in which all data integrity constraints are satisfied

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

173. A subform may be added to a main form by using the subform/subreport tool or by using the ____.

Subform property

Subform/Subreport dialog box

Subform control

Subform Wizard

Answer

Correct Answer: Subform Wizard

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

174. The ____ data type stores only the actual character string.

Redundancy

First normal form

VARCHAR

Relationship

Answer

Correct Answer: VARCHAR

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

175. A ____ should be a derived attribute

Person's social security number

Person's phone number

Person's name

Person's age

Answer

Correct Answer: Person's age

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

176. The data type that allows both sequential and random numbering is the ____ data type.

Number

Currency

AutoNumber

Long Date

Answer

Correct Answer: AutoNumber

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

177. "lastname" is an example of ________.

Camel Case

Pascal Case

Typing error

None of these

Answer

Correct Answer: Camel Case

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

178. ____ are made up of related records.

Tables

Bars

Charts

All of these

Answer

Correct Answer: Tables

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

179. _____ is a database management system (dbms) that is suitable for a large organization.

Oracle

SQL

DBase

MYSQL

Answer

Correct Answer: Oracle

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

180. When you open a data source, word initially looks in the ____ folder for the file.

My data sources

Mail merge resources

Available data

Databases

Answer

Correct Answer: My data sources

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

181. When you assign a ____ to a field access

Caption

Class

Value

None of these

Answer

Correct Answer: Caption

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

182. Using _____, you can extract data from an xml document and convert it into a text file.

XML

XLST

XSLT

XTSL

Answer

Correct Answer: XSLT

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

183. The step, ____, occurs first in the process of building an erd.

Develop the initial ERD.

Identify the business rules based on the description of operations.

Identify the attributes and primary keys that adequately describe the entities.

Create a detailed narrative of the organization’s description of operations.

Answer

Correct Answer: Develop the initial ERD.

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

184. The records in a database table are generally visualized as ________.

Rows

Columns

Captions

None of these

Answer

Correct Answer: Rows

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

185. The purpose of a database is to ________.

Setup for easy access

Setup for management

Setup for updating

All of these

Answer

Correct Answer: All of these

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

186. The primary objective of database design is ____

To create a complete,denormalized and redundant database model

To create a fully integrated conceptual,logical and physical database model

To create the most efficient database possible

Both a and b

Answer

Correct Answer: Both a and b

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

187. The most common type of database is a __________ database.

Sap

Heirarchial

Relational

None of these

Answer

Correct Answer: Relational

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

188. The ideal primary key is ________.

Short

Numeric

Fixed

All of these

Answer

Correct Answer: All of these

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

189. The column to be updated by the update command is specified in the ____ clause.

UPDATE

WHERE

SET

COL

Answer

Correct Answer: UPDATE

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

190. The above cardinality constraint on the order data entity indicates that there can be _____ .

One or many orders

Zero or many orders

Many orders

None pf these

Answer

Correct Answer: One or many orders

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

191. The _____ relationship is the ?relational model ideal.?

1:1

1:M

M:1

All of these

Answer

Correct Answer: All of these

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

192. The ____ type of attribute cannot be created in a dbms.

Derived

Simple

Multivalued

Composite

Answer

Correct Answer: Multivalued

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

193. The ____ is responsible for providing training in the use of the dbms.

File_put_contents

File_create_contents

File_write_contents

None of these

Answer

Correct Answer: File_put_contents

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

194. The ____ function writes a text string and creates the file if it does not exist.

File_put_contents

File_create_contents

File_delete_contents

None of these

Answer

Correct Answer: File_put_contents

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

195. Structured information can be defined as data ________.

That can be organized into hierarchies

That cannot be linked together

Both

None

Answer

Correct Answer: That can be organized into hierarchies

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

196. One of the important properties of a column is whether or not it is ________.

Found in more than one entity

Required

Character or numeric

None of these

Answer

Correct Answer: Required

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

197. In the select clause, you can use the ____ symbol to indicate that you want to include all columns.

Answer

Correct Answer: *

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

198. In the ________ step the data is either written to the file or read from the file.

Initiating

Processing

Evaluating

All of these

Answer

Correct Answer: Processing

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

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

Handle N:M relationships

Handle One to One relationship

Both

None

Answer

Correct Answer: Handle N:M relationships

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

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

File

Field

Record

None of these

Answer

Correct Answer: Field

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

201. In a student database, a column called lastname would be an example of a(n) _____________.

Attribute

Relationship

File

Record

Answer

Correct Answer: Attribute

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

202. In a ____ copy, two or more pointers of the same type point to the same memory.

Static

Shallow

Dynamic

Deep

Answer

Correct Answer: Shallow

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

203. In ____ systems, data and actions are encapsulated.

Relational

Object oriented

Network

Parallel

Answer

Correct Answer: Object oriented

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

204. Improving _____ leads to more flexible queries.

Atomicity

Normalization

Denormalization

Derived attribute

Answer

Correct Answer: Atomicity

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

205. If there is no index, the dbms will perform a _____ scan.

Loop

Range

Row ID Table

Full Table

Answer

Correct Answer: Full Table

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

206. If date of birth is an attribute, age would be a _______ attribute.

Multi valued

Composite

Derived

None of these

Answer

Correct Answer: Derived

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

207. Data integrity problems are likely to occur when __________.

Data is duplicated

Data has N:M relationship

Both

None

Answer

Correct Answer: Data is duplicated

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

208. Columns in a database table contain data with the same _________:

Row

Key

Type

Field

Answer

Correct Answer: Field

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

209. At the level of middle management, the database must be able to _____.

Deliver the data necessary for tactical decisions and planning

Represent and support the company operations as closely as possible

Produce query results within specified performance levels

None of these

Answer

Correct Answer: Deliver the data necessary for tactical decisions and planning

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

210. An example of a key-value database is ________.

DynamoDB

Memcachedb

Voldemort

All of these

Answer

Correct Answer: DynamoDB

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

211. All of these are dbms processes except ________.

Create data

Process the database

Assist in the administration of database

None of these

Answer

Correct Answer: Create data

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

212. A unique identifier is most likely used as a ____ key in a database.

Primary

Secondary

Both

None

Answer

Correct Answer: Primary

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

213. A multiple-field index must be created using ____.

Indexes dialog Box

Floating

Terminating

Recurring

Answer

Correct Answer: Indexes dialog Box

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

214. A method header is also called a(n) _____.

Statement

Declaration

Argument

Address

Answer

Correct Answer: Declaration

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

215. A ________ point does the same thing as a decimal point in the decimal system.

Floating

Terminating

Recurring

None of these

Answer

Correct Answer: Floating

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

216. A ______ is the highest level of data hierarchy.

Database

Record

Bits

Bytes

Answer

Correct Answer: Database

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

217. A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.

Candidate

Primary

Foreign

None of these

Answer

Correct Answer: Candidate

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

218. A ____ is an attribute or combination of attributes that uniquely identifies a tuple.

Candidate key

Primary key

Foreign key

Super key

Answer

Correct Answer: Candidate key

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

219. 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

220. A ____ is a column in a table that describes a characteristic about a record.

Record

Matrix

File

Field

Answer

Correct Answer: Field

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

221. 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

222. ____ queries are often used to append records to history tables.

Self

Append

Null

Index

Answer

Correct Answer: Append

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

223. When using a hdfs, the _ node creates new files by communicating with the node.

Client, name

Name, client

Client, data

Data, client

Answer

Correct Answer: Client, name

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

224. In the context of raid levels, _____ refers to writing the same data blocks to separate drives.

Partitioning

Aggregating

Mirroring

Striping

Answer

Correct Answer: Mirroring

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

225. In the context of big data, _____ refers to the trustworthiness of a set of data.

Variety

Variability

Veracity

Viability

Answer

Correct Answer: Variability

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

226. Programmers usually refer to the process of saving data to a file as ________ a file.

Saving data to.

Copying data to.

Writing data to.

Put data to

Answer

Correct Answer: Writing data to.

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

227. The ____ data type can store up to a gigabyte of text.

Variableb.

Attachment

VarChard.

Long Text

Answer

Correct Answer: Long Text

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

228. In charting, subjective data includes the ____.

Medications perscribed and tests to be done

Patient's chief complaint

Both of above

None of these

Answer

Correct Answer: Patient's chief complaint

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

229. In _______, transactions are collected over time and then processed all at once.

Batch processing

Group processing

Real-time processing

Consignment processing

Answer

Correct Answer: Batch processing

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

230. If data aggregation is the goal of collecting the data, ______ are the best choice.

Classifications

Code systems

Clinical terminologies

Nomenclatures

Answer

Correct Answer: Classifications

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

231. Both qualitative and quantitative data can be displayed using a _____ graph.

Circle

Line

Bar

Pie

Answer

Correct Answer: Bar

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

232. Big data analytics is usually associated with ________ services

Decision support

Data warehouse

Office support

Management information

Answer

Correct Answer: Data warehouse

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

233. Analyzing data in graphs or charts allows you to _____

Make observations

Make predictions

Run new experiments

Create new tools

Answer

Correct Answer: Make predictions

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

234. An xml database supports the storage and management of _____ xml data.

Structured

Multistructured

Semi structured

All of these

Answer

Correct Answer: Semi structured

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

235. An immutable class cannot have ________.

Public data fields

Private data fields

Public constructors

No-arg constructors

Answer

Correct Answer: Public data fields

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

236. An example of a floating point data type is ____.

Single

Double

Both of above

None of these

Answer

Correct Answer: Double

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

237. An emerging non-relational database management system is called ________.

NoSQL

MySQL

Both a and b

None of these

Answer

Correct Answer: NoSQL

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

238. A data processing group is an example of a(n) _____.

Routine team

Production team

Advice team

Action team

Answer

Correct Answer: Production team

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

239. A ________ is a group of related data that can be stored, sorted, organized, and queried.

Database

Spreadsheet

Memo

Macro

Answer

Correct Answer: Database

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

240. ____ is a coding method used on mainframe computers and high-capacity servers.

ASCII

Unicode

EBCDIC

ISO

Answer

Correct Answer: EBCDIC

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

241. ____ implies that no site should depend on another site to perform its database functions.

No reliance on a central site

Local autonomy

Continuous operation

Fragmentation transparency

Answer

Correct Answer: Local autonomy

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

242. Opening a(n) ________ file creates a file on disk and allows the program to write data to it.

Output

Input

Both ofabove

None of these

Answer

Correct Answer: Both ofabove

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

243. A(n) ____ file uses a uniform format to store data for each person or thing in the file.

Structured

Analytical

Big data

All of these

Answer

Correct Answer: Structured

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

244. The comparison operator, < >, is used to insert a condition that means ____.

Greater than

Less than

Equal to

Not equal to

Answer

Correct Answer: Not equal to

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

245. The common field between two tables in the relationship window is indicated by a(n) ____

Join line

Union

Cross-product

None of these

Answer

Correct Answer: Join line

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

246. The _____ operator could be used in place of minus if the dbms does not support it.

NOT IN

INTERSECT

UNION ALL

All of these

Answer

Correct Answer: NOT IN

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

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

Enhanced entity relationship model

Enough entity relationship model

Equality entity relationship model

Entities entity relationship model

Answer

Correct Answer: Enhanced entity relationship model

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

248. When the pk of one entity does not contain the pk of a related entity, the relationship is ____.

Weak

Strong

Dependant

Independant

Answer

Correct Answer: Weak

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

249. To delete a row from the product table, use the ____ command.

Drop

Delete

Rollback

Commit

Answer

Correct Answer: Delete

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

250. There are two views for tables in access: datasheet view and ________ view.

Design

Datatable

Row

Column

Answer

Correct Answer: Design

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

251. Sql requires the use of the _____ command to enter data into a table.

INSERT

SELECT

COMMIT

NOT NULL

Answer

Correct Answer: INSERT

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

252. Relational tables need to be ______________ to help avoid duplicate data.

Normalized

Ethically analyzed.

Entitled

Relationally modeled

Answer

Correct Answer: Normalized

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

253. Most users enter information into a database through the use of a ________.

Form

Query

Tables

Navigation pane

Answer

Correct Answer: Form

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

254. Most designers consider the bcnf as a special case of the ____.

1NF

2NF

3NF

4NF

Answer

Correct Answer: 3NF

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

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

DESCRIBE

MODIFY

SELECT

INSERT

Answer

Correct Answer: SELECT

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

256. In access sql, the ____ is used as a wildcard to represent any individual character.

Percentage sign (%)

Question Mark (?)

Semicolon(;)

Exclamation Mark

Answer

Correct Answer: Question Mark (?)

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

257. Before converting a table into 3nf, it is imperative the table already be in ____.

2nf

4nf

1nf

3nf

Answer

Correct Answer: 2nf

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

258. A primary key's main function is to uniquely identify a(n) _____ within a table.

Entity instance or row

Database

Entity instance or table

Entity instance or column

Answer

Correct Answer: Entity instance or row

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

259. A(n) ____ entity is composed of the primary keys of each of the entities to be connected.

Simple

Associative

Composite

Single-Valued

Answer

Correct Answer: Associative

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

260. To delete an entire table, use the ____ command and then re-create the table.

Drop Table

Delete Table

Rollbackk

None of the above

Answer

Correct Answer: Drop Table

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

261. Many computer users and some operating systems call subdirectories ____.

Folders

Volumes

Databases

Files

Answer

Correct Answer: Folders

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

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

DESCRIBE

MODIFY

SELECT

COMMIT

Answer

Correct Answer: DESCRIBE

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

263. In many-to-many relationships in a relational database design, ________.

The key of the child is placed as a foreign key into the parent

The key of the parent is placed as a foreign key into the child

The keys of both tables are placed in a third table

The keys of both tables are joined into a composite key

C and D

Answer

Correct Answer: C and D

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

264. A group of similar rows or records is known as ________.

Table

Form

Key

Record

Answer

Correct Answer: Table

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

265. The _____ special operator is used to check whether an attribute value is null.

IS NULL

EXISTS

DROP

Answer

Correct Answer: IS NULL

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

266. The _____ data type is considered compatible with varchar(35).

DATE

INT

TINYINT

CHAR(15

Answer

Correct Answer: CHAR(15

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

267. The _____ command would be used to delete the table row where the p_code is 'brt-345'.

DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';

REMOVE FROM PRODUCT WHERE P_CODE = 'BRT-345';

ERASE FROM PRODUCT WHERE P_CODE = 'BRT-345';

ROLLBACK FROM PRODUCT WHERE P_CODE = 'BRT-345

Answer

Correct Answer: DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';

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

268. Students and classes have a ____ relationship.

Many to many

One to many

Many to one

None of the above

Answer

Correct Answer: Many to many

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

269. Input ____ are templates that make it easier for users to enter data

Patterns

Masks

Legends

Keys

Answer

Correct Answer: Masks

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

270. _____ data exist in a format that does not lend itself to processing that yields information.

Enterprise

Semistructured

Unstructured

Formatted

Answer

Correct Answer: Unstructured

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

271. ____________________ is data about data.

Hybrid XML/relational database

Structured query language (SQL)

In-memory database (IMDB)

Metadata

Answer

Correct Answer: Metadata

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

272. The specific content of a field is referred to as the ____.

Field content

Field value

Table value

Column value

Answer

Correct Answer: Field value

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

273. The dbms _____ the sql query and chooses the most efficient access/execution plan.

Executes

Processes

Fetches

Parses

Answer

Correct Answer: Parses

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

274. When you modify or delete data present in a database, you are ________.

Creating a new database.

Forming a data model.

Simplifying the data

Processing the database

Answer

Correct Answer: Processing the database

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

275. The sql command that lets you permanently save data changes is ____.

INSERT

COMMIT

SELECT

UPDATE

Answer

Correct Answer: COMMIT

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

276. 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

277. When using the relational model to represent two tables, one must ________.

Add a foreign key to one of the tables

Have more than two identifiers in the model

Establish only N:M relationships between the tables

Use metadata instead of foreign keys

Answer

Correct Answer: Add a foreign key to one of the tables

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

278. Objects are created from abstract data types that encapsulate _ and _ together.

Data, functions

Functions, data

Data, data

Functions, functions

Answer

Correct Answer: Data, functions

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

279. ________ is used to ensure that data is organized most efficiently.

Exporting

Database

Relational

Range checking

Centralization

Answer

Correct Answer: Range checking

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

280. A(n) ________ is a request for data from a database

Query

Fields

Records

Files

Answer

Correct Answer: Query

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

281. A(n) ________ is a dedicated computer in a client/server environment that hosts a dbms.

Application server

Client server

Web server

Data base server

Answer

Correct Answer: Data base server

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

282. A(n) ____ enables a database administrator to define schema components.

Data definition language (DDL)

Enity

Entity

Answer

Correct Answer: Data definition language (DDL)

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

283. A(n) ____ database organizes data into multiple tables that are related by common fields.

Redundancy

Adminstrator

Relational

Lights out

Record

Answer

Correct Answer: Relational

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

284. A(n) ____ allows you to create, update, and administer a relational database.

SSL

AND

RDBMS

Memo

Answer

Correct Answer: RDBMS

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

285. A workgroup database is a(n)____ database.

Single user

Multi-user

Enterprise

Distributed

Answer

Correct Answer: Multi-user

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

286. A query datasheet is sometimes called a ____ of the data.

Warehouse

Table Simulator

Logical View

Duplicate Copy

Answer

Correct Answer: Logical View

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

287. _________ consist of many linked tables.

Relational Database

Second Normal Form

First Normal Form

External Level View

Flat File

Answer

Correct Answer: Relational Database

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

288. ________ is a popular enterprise database management system (dbms) product from ibm.

DB2

Access

SQL Server

MySQL

Answer

Correct Answer: DB2

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

289. _____ returns only the attributes requested, in the order in which they are requested.

PROJECT

SELECT

UNION

Answer

Correct Answer: PROJECT

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

290. ____ integrity constraints help to ensure the accuracy and consistency of individual field values.

Field

Value

Key

Data

Answer

Correct Answer: Data

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

291. ____ data are the result of formatting to facilitate storage, use and generation of information.

Structured

Historical

Unstructured

Semistructured

Answer

Correct Answer: Structured

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

292. Microsoft access can best be described as ____ software.

Database

Presentation

Systems

Spreadsheet

Answer

Correct Answer: Database

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

293. In a table, a characteristic of the data is called ________.

Record

Field

Table

Query

Answer

Correct Answer: Field

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

294. In the world of databases, a(n) ____ refers to a collection of data fields.

Record

File

Field

Matrix

Answer

Correct Answer: Record

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

295. In a/an ________________, a table can contain information about two or more entities.

Normalized data structure

None of the above

Foreign key constraint

Unnormalized data structure

Answer

Correct Answer: Unnormalized data structure

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

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

Fields that are listed as Primary Keys

Fields that are listed as secondryh Keys

Fields that are listed as thirdly Keys

Fields that are listed as midle Keys

Answer

Correct Answer: Fields that are listed as Primary Keys

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

297. End user data is ____

Raw facts about the end-user

Raw facts of interest to the end-user

Data about data

Accurate, relevant and timely information

Answer

Correct Answer: Raw facts of interest to the end-user

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

298. Ebcdic and ascii both require ____ bits.

Six

Seven

Eight

Nine

Answer

Correct Answer: Seven

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

299. Each table _____ represents an attribute

Column

Row

Dimension

Value

Answer

Correct Answer: Column

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

300. Each entity in a database has a unique attribute called a(n) ________.

Public key

Foreign key

Index field

Identifier

Answer

Correct Answer: Identifier

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

301. Each category of information in a database is called a(n) ____.

Attribute

Ecommerce

Banner ad

Data file

Answer

Correct Answer: Attribute

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

302. Each _____ in an access database represents a field

Row

Tab

Column

Pane

Answer

Correct Answer: Column

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

303. Each _____ contains data about people, places, things, or events.

File

Table

Nonkey field

Cardinality notation

Answer

Correct Answer: Table

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

304. A(n) ______ is an item that contains data, as well as the actions that read or process the data.

Interpreter

Check digit

Field

Object

Answer

Correct Answer: Object

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

305. A(n) ______ database stores data in tables that consist of rows and columns.

Benchmark

Dictionary

Check digit

Relational

Answer

Correct Answer: Relational

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

306. A(n) _____ is anything about which data are to be collected and stored.

Attribute

Entity

Relationship

Constraint

Answer

Correct Answer: Entity

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

307. A(n) _____ is a simple database program whose records have no relationship to one another.

Flat file

Schema

Relational system

User view

Answer

Correct Answer: Flat file

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

308. A(n) _____ enables a database administrator to describe schema components.

Data definition language(DDL)

Relationship

Entity relationship

Entity

Answer

Correct Answer: Data definition language(DDL)

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

309. A(n) ____ is a restriction placed on the data.

Attribute

Entity

Relationship

Constraint

Answer

Correct Answer: Constraint

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

310. A(n) ____ is a medium-sized computer used to host programs and data for a small network.

Mainframe computer.

Super server.

Midrange server

Answer

Correct Answer: Midrange server

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

311. A(n) ____ is a field or set of fields used to uniquely identify each row.

Foreign key

Attribute

Primary key

Object identifier

Answer

Correct Answer: Primary key

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

312. A table is in _____ if it does not contain a repeating group.

Fourth normal form

Second normal form

First normal form

Third normal form

Answer

Correct Answer: First normal form

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

313. A record that contains data is referred to as a record ________.

Operational

SELECT

Occurrence

Primary key

Answer

Correct Answer: Occurrence

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

314. Mysql is an example of a(n) ____

Hierarchical model

File system data model

Relational data model

XML data model

Answer

Correct Answer: Relational data model

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

315. Individual database tables are often referred to as ____.

Low files

Base files

Flat files

Clear files

Answer

Correct Answer: Flat files

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

316. 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

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

File

Record

Row

Field

Key

Answer

Correct Answer: File

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

318. In database systems, a row 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

319. In data warehouses, _____ gives users subtotals of various categories, which can be useful.

Summary Data

Raw Data

Open Data

Metadata

Answer

Correct Answer: Summary Data

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

320. In an access table, each row is one ____ in the table.

Record

File

Field

Matrix

Answer

Correct Answer: Record

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

321. In a file-oriented information system, a work file ____.

Stores relatively permanent data about an entity

Is created and saved for backup and recovery purposes

Stores records that contain day-to-day business and operational data

Is a temporary file created by an information system for a single task

Answer

Correct Answer: Is a temporary file created by an information system for a single task

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

322. In a file-oriented information system, a transaction file ____.

Stores relatively permanent data about an entity

Is created and saved for backup and recovery purposes

Stores records that contain day-to-day business and operational data

Is a temporary file created by an information system for a single task

Answer

Correct Answer: Stores records that contain day-to-day business and operational data

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

323. In a database, when data items disagree with one another, it leads to a(n) ________.

Data that describe data

Data integrity problem

It is license-free for most applications.

Lists involve data with multiple themes

Answer

Correct Answer: Data integrity problem

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

324. In a database, a(n) ____________ refers to a collection of data fields.

Matrix.

Field.

Record

Relation

Answer

Correct Answer: Record

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

325. In a database, a table is formally referred to as a ________.

Matrix.

Field.

Record.

Relation

Answer

Correct Answer: Relation

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

326. In a database, a collection of related records is referred to as a table or a ____.

File

Database

Record

Matix

Answer

Correct Answer: File

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

327. In a data model, a(n) ________ is something that a user wants to track.

Record.

Byte.

Entity

Primary key. entity

Answer

Correct Answer: Entity

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

328. In a client/server system, users access the database through ____.

Index

Documenter

Server

Client

Answer

Correct Answer: Client

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

329. In a client/server system, the database resides on a computer called the ____.

Index

Documenter

Server

Client

Answer

Correct Answer: Server

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

330. In _______, data is processed at the same time the transaction occurs.

Batch processing

Group processing

Real-time processing

Consignment processing

Answer

Correct Answer: Real-time processing

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

331. In _______, data from transactions are collected over time and then processed all at once.

Batch Processing

Group Processing

Real-Time Processing

Answer

Correct Answer: Batch Processing

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

332. In _____ processing, transactions are collected over time and processed together in groups.

Batch processing

Group processing

Real-time processing

Consignment processing

Answer

Correct Answer: Batch processing

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

333. If the navigation pane is not open, click the _____ to open it and view the database objects.

View Button

Open/Close Navigation Button

View Database Objects Button

Shutter Bar Open/Close Button

Answer

Correct Answer: Shutter Bar Open/Close Button

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

334. Granularity refers to _____.

The level of detail represented by the values in a tables row

Multivalued dependency

Partial

Answer

Correct Answer: The level of detail represented by the values in a tables row

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

335. For most business transactional databases, we should normalize relations into _____.

6NF

1NF

2NF

3NF

Answer

Correct Answer: 3NF

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

336. Databases that not related or linked to other data are called ________ databases.

Flat

File

Record

Matrix

Answer

Correct Answer: Flat

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

337. Data within the data cube has been ______ by specific dimensional values.

Summarized

English

Sales revenue

Deployment

Answer

Correct Answer: Summarized

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

338. Data that are never physically altered once they are added to the store are called ________ data.

Complete

Override

Transient

Periodic

Answer

Correct Answer: Periodic

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

339. Data staging consists of all of the following steps, except ________.

Transforming the data

Mining the data

Storing the data in a warehouse

Answer

Correct Answer: Mining the data

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

340. Data mining is part of the “____” section of the business intelligence framework.

People

Management

Processes

Governance

Answer

Correct Answer: Processes

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

341. Data mining is more ________ than olap.

Data focused

Multidimensional

Query oriented.

Discovery driven

Answer

Correct Answer: Discovery driven

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

342. Data may be sorted in a table datasheet, a form, and a ____.

Report

Query datasheet

Record

Related table

Answer

Correct Answer: Query datasheet

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

343. Data is captured from the oltp system and placed on the ____ on a near-real time basis.

Decision support system

Data warehouse

Portal

Dashboard

Answer

Correct Answer: Data warehouse

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

344. Data is broken into _____ to be transmitted over the internet

Circuits

Packets

Messages

Answer

Correct Answer: Packets

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

345. Data in a multidimensional database is organized in a ________ format

Linear

Cube

Modular

Cellular

Answer

Correct Answer: Cube

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

346. Data files are also often called ____.

Infrared

Read/write heads

Logical drives

Documents

Answer

Correct Answer: Documents

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

347. Data elements in a relational database are organized into ____.

Tuples.

Attributes.

Objects.

Tables

Answer

Correct Answer: Tables

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

348. Data can be organized and processed sequentially using an array, called a(n) ____ list.

Linked

Ordered

Sequential

Ascending

Answer

Correct Answer: Sequential

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

349. Data about the data in a database is known as ____.

Backup

Hyperdata

Metadata

Rollback

Answer

Correct Answer: Metadata

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

350. Data ________ helps to ensure data integrity by maintaining information in only one place

Flexibility.

Redundancy.

Mapping.

Centralization

Answer

Correct Answer: Centralization

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

351. Controlled ____ makes a relational database work

Relations

Logic

Chaos

Redundancy

Answer

Correct Answer: Redundancy

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

352. Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

Minimum

Maximum

Both of these

None of these

Answer

Correct Answer: Minimum

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

353. Changing the order of fields in a database table is an example of changing a table’s ____.

Purpose

Structure

Data

Value

Answer

Correct Answer: Structure

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

354. Browser-based applications ________.

Eliminate the need to check for data consistency

Need to be pre-installed on the users' computers

Run within a corporate network that is protected from the Internet

Are more vulnerable to security threats than are traditional applications

Answer

Correct Answer: Are more vulnerable to security threats than are traditional applications

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

355. As part of a dbms, a(n) _________ documents information about a database.

Integrated

A key field

Data dictionary

Big Data

Answer

Correct Answer: Data dictionary

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

356. Another term for a database row is a(n) ________.

Foreign key

Attribute

Primary key

Record

Answer

Correct Answer: Record

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

357. An organized collection of related data is called a ____________________.

Query

Primary

Database

Landscape

Answer

Correct Answer: Database

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

358. A relation is in ____ if it does not contain any repeating groups.

First normal form

Second normal form

Third normal form

Boyce-Codd normal form

Answer

Correct Answer: First normal form

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

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

Key Field

Qualities

Metadata

Fields

Records

Answer

Correct Answer: Records

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

360. A desktop database is a ____ database

Single-user

Workgroup

Multiuser

Distributed

Answer

Correct Answer: Single-user

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

361. A dbms lets you assign users to ____.

Groups

Classes

Attributes

Clusters

Answer

Correct Answer: Groups

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

362. A database is used instead of a spreadsheet when ________.

Lists of data involve a single theme

Structures of data lists are simple

Lists involve data with multiple themes

Users do not want to store all data in one place

Answer

Correct Answer: Lists involve data with multiple themes

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

363. A database is a collection of integrated and related _____.

Flat file

Choice

Files

Bit

Answer

Correct Answer: Files

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

364. A database holds related file data in ____ .

Fields

Files

Tables

Answer

Correct Answer: Tables

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

365. A data integrity problem will occur only if ________.

There are multiple administrators

Data are duplicated

The database is very large

There are complex relationship

Answer

Correct Answer: Data are duplicated

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

366. A data dictionary typically includes any of the following except ____.

Data redundancy

Data integrity

Flexible use of data

Information sharing

Answer

Correct Answer: Data redundancy

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

367. A characteristic of operational data is ____.

Summarized data

Hundreds of gigabytes

High normalization

Historic data

Answer

Correct Answer: High normalization

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

368. A characteristic of decision support data is ____.

High query activity

High update volumes

Highly normalized

Low aggregation level

Answer

Correct Answer: High query activity

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

369. A __________ is the column of data in a database that is used as the basis for arranging data.

Primary key

Sort key

Datatype

Keyvalue

Answer

Correct Answer: Sort key

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

370. A ________ of a base class expects to be overridden in a derived class.

Constructor function

Destructor function

Static function

Virtual function

Answer

Correct Answer: Virtual function

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

371. A ________ is a temporary table used in the from clause of an sql query.

Correlated subquery.

Derived table.

View table.

None of these

Answer

Correct Answer: Derived table.

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

372. A ________ describes the data and relationships that will be stored in a database.

Data aggregator.

Query model.

Data model

Answer

Correct Answer: Data model

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

373. A _____ specifies the fields and identifies the primary key in a particular file.

Output design

Market basket design

Table design

Diagram design

Answer

Correct Answer: Table design

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

374. A _____ is a simple database program whose records have no relationship to one another.

Select one:

Flat file

Schema

Relational system

User view

Answer

Correct Answer: Flat file

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

375. A _____ controls database operations, including storing, retrieving, updating, and deleting data.

Manipulation

Manufacturing

Schema

Dynamic

Answer

Correct Answer: Manipulation

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

376. 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

377. A ____ is a program that lets computer users create and access a collection of organized data.

Data warehouse

Database management system

Database

Management system

Answer

Correct Answer: Database management system

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

378. A ____ defines the name and data type of program variables.

Nonprocedural

Data operation

Data declaration

Static, dynamic

Unresolved references

Answer

Correct Answer: Data declaration

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

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

Period

Entity

Nonkey

Order

Answer

Correct Answer: Nonkey

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

380. _____ is the result of revealing the meaning of raw facts.

Data integrity

Unstructured

Application

Information

Answer

Correct Answer: Information

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

381. Use data when __________.

Using generally accepted information

Providing background information

Giving context for an argument

Needing hard facts Please select the best answer from the choices provided

Answer

Correct Answer: Needing hard facts Please select the best answer from the choices provided

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

382. The process of retrieving only certain rows based upon a specified condition is known as ____.

True

USING

DML operations cannot be performed on a non key-preserved table.

Selection

Answer

Correct Answer: Selection

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

383. The _____ data model is said to be a semantic data model.

Relational

Network

Object-oriented

Entity relationship

Answer

Correct Answer: Object-oriented

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

384. The ____ clause is used to specify the interval between two sequential values.

CREATE INDEX...ON

DROP SEQUENCE

INCREMENT BY

CREATE SEQUENCE

Answer

Correct Answer: INCREMENT BY

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

385. To change a table name, we ________.

Use the SQL-92 RENAME TABLE command

Use the SQL-92 ALTER TABLENAME command

Use the SQL-92 MODIFY TABLENAME command

Create a new table, move the data and drop the old table

Answer

Correct Answer: Create a new table, move the data and drop the old table

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

386. The term ____ database comes from the fact that two or more tables are linked by a common field.

Database

Entry bar

Relational

Purpose, meaningful title

Answer

Correct Answer: Relational

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

387. The system catalog is also called the ____.

Data dictionary.

Transaction database.

System database.

Master data table

Answer

Correct Answer: Data dictionary.

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

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

BETWEEN

NULL

IN.

Answer

Correct Answer: BETWEEN

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

389. With a(n) ____ language, the user provides an example of the data requested.

SQL

IDE

QBE

Interpolated

Answer

Correct Answer: QBE

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

390. When designing tables a ____ structure is preferred

Simple

Complex

Detailed

Complete

Answer

Correct Answer: Simple

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

391. When designing a new database, the first question users should ask themselves is ________.

Commone field

.accdb

True

What questions should this database be able to answer

Answer

Correct Answer: What questions should this database be able to answer

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

392. When designing a database, you should ____.

Consider more important issues such as performance before normalizing,

Create table structures then normalize the database,

Make sure entities are in normal form before table structures are created,

Only normalize the database when performance problems occur

Answer

Correct Answer: Make sure entities are in normal form before table structures are created,

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

393. When creating a query using the query design command, first you must ____________.

Select the table(s) you want to get criteria from

File compression

Connect the data in tables

Select the text

Answer

Correct Answer: Select the table(s) you want to get criteria from

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

394. When choosing field names, it is best to choose names that ____.

Include both numbers and letters in the name

Use only uppercase characters

Describe the content or purpose of the field

Use only lowercase letters and no spaces

Answer

Correct Answer: Describe the content or purpose of the field

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

395. When an entity has a relationship to itself, we have a(n) ________.

0 or 1

Create a new ID-dependent entity with a 1:N relationship

Recursive relationship

Association table will have additional columns

Answer

Correct Answer: Recursive relationship

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

396. When a script file contains more than one command, each command must end with a(n) ____.

Question mark.

Colon.

Period.

Semicolon

Answer

Correct Answer: Semicolon

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

397. When a project executes, its __________ is automatically displayed.

Main sub

Startup form

Event procedure

Form load event

Answer

Correct Answer: Startup form

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

398. When a primary key combines two or more fields, it is called a ____ key.

Constructed

Composite

Collective

Parallel

Answer

Correct Answer: Composite

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

399. Validation rules can indicate a ____.

Clicking the New record, CTRL + Plus Sign, Click new button

Filter records, Changing the appearance of data sheet, adding new records, Changing the data

Required

Required field, Default Value, Range of Values

Answer

Correct Answer: Required field, Default Value, Range of Values

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

400. To represent relationships, ________ are added to tables.

Locking keys.

Value keys.

Entity keys.

Normalized keys.

Foreign keys

Answer

Correct Answer: Foreign keys

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

401. To order the records in the answer to a query in a particular way, you ____ the records.

True

Join

Sort

Answer

Correct Answer: Sort

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

402. To make a specific database active, you must execute the ____ database statement.

CHANGE

USE

SWITCH

SELECT

Answer

Correct Answer: USE

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

403. To insert a new field in a table, the ____ keyword should be used with the alter table command.

ADD

Primary

True

False

Answer

Correct Answer: ADD

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

404. To guarantee that the member variables of a class are initialized, you use ____.

Accessors

Mutators

Constructors

Destructor

Answer

Correct Answer: Constructors

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

405. To generate unique numbers in sequence, you use the ________________ attribute.

AUTO_INCREMENT

Foreign keys

ALTER TABLE

Foreign key

Answer

Correct Answer: AUTO_INCREMENT

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

406. To avoid data ____, a database stores data in one place.

Integrity

Primary key

Redundancy

Data mining

Answer

Correct Answer: Redundancy

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

407. The principle of accuracy in logic is __________.

RETRIEVE

UPDATE

READ

SELECT

Answer

Correct Answer: SELECT

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

408. The database is loaded during the ____ phase of the sdlc.

Analysis

Detailed systems design

Implementation

Answer

Correct Answer: Implementation

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

409. The multi-step process used when creating a new system is referred to as ____.

The Systems Development Life Cycle

Data mining

E-R Modeling

SQL

Answer

Correct Answer: The Systems Development Life Cycle

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

410. The _____ model is the end users’ view of the data environment.

Object-oriented

External

Entity relationship

Segment

Answer

Correct Answer: External

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

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

ORDER BY

ORDER

SET ORDER

LIST BY

Answer

Correct Answer: ORDER BY

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

412. You can think of a database as a _____________________.

Folder of different objects

List of data

Spreadsheet file

Set of document tabs

Long word-processing document

Answer

Correct Answer: Folder of different objects

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

413. While triggers run automatically, ________ do not and have to be called.

Trapdoors

Routines

Selects

Updates

Answer

Correct Answer: Selects

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

414. When you specify a foreign key, the table referenced by the foreign key is the ____.

parent

Super

Sibling

Child

Answer

Correct Answer: parent

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

415. When we consider entities as tables, each column is a(n) ________.

Attribute.

Record.

Form.

Bot.

Query

Answer

Correct Answer: Attribute.

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

416. When renaming columns, you include the new column names in ____ following the name of the view.

Parent

Parentheses

DROP INDEX

False

Answer

Correct Answer: Parentheses

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

417. When linking two tables in a relational database, a user will use a ________ to create the link.

Common field

Tag

Hyperlink

Bookmark

Answer

Correct Answer: Common field

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

418. Use the ____ command to save the current object with a new name.

Datasheet

View

Save Object As

Save as

Answer

Correct Answer: Save as

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

419. To upload a file, display the ____ bar, and then click the upload button or the add files button.

Apps

2 GB.

Right-click

A browser

Answer

Correct Answer: Apps

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

420. To restrict the rows returned from an sql query, you should use the _____ clause:

SELECT

WHERE

GROUP BY

CONDITION

All of the above

Answer

Correct Answer: WHERE

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

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

Implementation

Constraint

Analysis

User view

Answer

Correct Answer: Analysis

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

422. The person responsible for the control of the centralized and shared database is the database ____.

Analyst

Administrator

Programmer

User

Answer

Correct Answer: Administrator

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

423. The object-oriented data model was developed in the _____.

File system data model

1980s

1970s

Entity relationship

Answer

Correct Answer: 1980s

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

424. The connection between two tables in a database is called a _________.

Spreadsheet

Attribute

A data model

Relationship

Answer

Correct Answer: Relationship

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

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

(1,1)

M:N

False

Rectangle

Answer

Correct Answer: M:N

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

426. The following are all processing operations of a dbms except _________.

Data is duplicated

Metadata

A single theme

Autocorrect data

Answer

Correct Answer: Autocorrect data

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

427. The field that uniquely identifies a row in a relational database table is called a ________.

Foreign key

Primary key

Column

Data definition language

Null value

Answer

Correct Answer: Primary key

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

428. The equijoin takes its name from the comparison operator ____ used in the condition.

1:1

1:M

Logically, physically

Answer

Correct Answer: =

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

429. The database structure in a dbms is stored as a ____.

Collection of files

Many to many

Object-oriented

Anomalies

Answer

Correct Answer: Collection of files

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

430. The data accessed by data mining and other analysis techniques is often stored in a data ____.

Example *

JavaScript *

Related *

Warehouse

Answer

Correct Answer: Warehouse

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

431. The command to delete a view is ____.

DROP INDEX

DROP VIEW

SYSTABLES

SYSCOLUMNS

Answer

Correct Answer: DROP VIEW

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

432. The ____ is the most widely used database model today.

Relational database management system (RDBMS)

Data dictionary

Report

Record

Answer

Correct Answer: Relational database management system (RDBMS)

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

433. The primary purpose of a database is ______.

To make it easy to create graphs

To keep track of lists of data with multiple themes

To store a list of data involving a single topic or theme

To apply formulas to data representing mathematical relationships

Avoid having to learn about spreadsheets

Answer

Correct Answer: To keep track of lists of data with multiple themes

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

434. The primary disadvantage of contiguous storage is that ____.

It is hard to implement and manage

It is difficult to find information in files

File can't be expanded unless there is empty space available immediately following it

It is an inefficient use of space

Answer

Correct Answer: File can't be expanded unless there is empty space available immediately following it

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

435. The output of data mining in a business setting is sometimes called ____.

QBE, query by example

Business intelligence

The names of the data items

Tables and fields

Answer

Correct Answer: Business intelligence

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

436. The process of extracting information from a data warehouse or data mart is called ____.

Data mining

Business intelligence

Data warehouse

Database

Answer

Correct Answer: Data mining

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

437. The erd represents the ____ database as viewed by the end user.

Condensed

Physical

Logical

Conceptual

Answer

Correct Answer: Conceptual

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

438. The data mining technique that relies on association rule learning is often called _____.

Strategy-orientated analysis

Market basket analysis

Simulated analysis

Virtual storage analysis

Answer

Correct Answer: Market basket analysis

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

439. The data _______ or schema contains a description of the structure of data in the database.

Distributed

Dictionary

Attribute

Relational

Answer

Correct Answer: Dictionary

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

440. The ____ constraint prevents the user from adding a null value in the specified column.

INCREMENT BY

NOT NULL

NEXTVAL

COUNT

Answer

Correct Answer: NOT NULL

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

441. The relational database model enables you to view data rather than .

Relationally, hierarchically

Hierarchically, relationally

Physically, logically

Logically, physically

Answer

Correct Answer: Logically, physically

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

442. The rate of data that is transmitted from your computer to the internet is ____.

Downstream speed

Uploaded

Upstream speed

Network class

Answer

Correct Answer: Upstream speed

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

443. The pl/sql block starts with the _____ section.

Section

OPEN

DECLARE

BEGIN

Answer

Correct Answer: Section

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

444. The organization of data within folders in a manual file system is determined by _______.

Its date of creation

Its expected use

The title

The data processing specialist

Answer

Correct Answer: Its expected use

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

445. The privilege ____ can be granted to change data.

Select

Delete

Parent

UPDATE

Answer

Correct Answer: UPDATE

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

446. The response of the dbms to a query is the ____.

Ad hoc query

Ad hoc response

Query result set

Integrated view of the data

Answer

Correct Answer: Query result set

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

447. The product of two tables is also called the ____ product.

Cartesian

Aggregate

Cathode

Exponential

Answer

Correct Answer: Cartesian

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

448. The privilege ____ can be granted to change the table structure.

ALTER

UPDATE

False

Select

Answer

Correct Answer: ALTER

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

Buy us a coffee

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

Database Organization & Design MCQs

Advance 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

Introduction to Database MCQ

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

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

3. In addition to standard colors, the font color gallery displays ____ colors.

4. In a microsoft access database, the gettysburg address would be stored in a(n) ________ field.

5. If a security warning appears when you open a database, click the ____ button.

6. Designing to omit ____________________ will help to produce good and valid database designs.

7. Database redesign is fairly easy when ________.

8. Data stored on disks is easier and faster to locate than data on magnetic tapes because ________.

9. Colonial adventure tours organizes day-long guided trips to ____.

10. An integer format uses ____ bits to represent the number 12,345 in binary form.

11. Each record in a table is uniquely identified by a foreign key. _________________________

12. The identifier of the entity becomes the ________ of the corresponding table

13. The erm forms the basis of a(n) ___________________________________.

14. The data model produced by reverse engineering is a(n) ________.

15. The contents of query datasheet are permanent. ____________________

16. To ____________________ a document means to make changes to its existing content.

17. In a database, first name would be an example of a ____.

18. In a database, bytes are grouped into __________.

19. ____ is a relational set operator.

20. The appearance of fields in a report that is created using the report wizard is determined by ____.

21. The order line in a tal distributors order form contains a total that is called a(n) ____.

22. A database _____________is organized into rows and columns.

23. A field whose data type is ____ can store text that can be used as a hyperlink address

24. You would use a ________ to temporarily display records of residents of the city of boston.

25. The report wizard allows detail records to be sorted by up to four fields. ____________________

26. The first field specified in the sorting process is called the ____________________ field.

27. Primary keys ensure that ____.

28. The _____ section in the lower half of the work area displays the properties for the active field.

29. Join types may be changed using the join types button available in the ____ dialog box.

30. To begin importing data from an excel spreadsheet, click on the ____ tab on the ribbon.

31. Fields that contain numbers that are not used in calculations should be set to ________.

32. Fields included in a query may be modified after the query is saved. ____________________

33. The form control that appears in the access window with tabs at the top is the ____ control.

34. The default group in the navigation pane is ____.

35. The ""one"" table in a one-to-many relationship is the ____________________ table.

36. Formatting date/time fields changes only the way data is displayed, not the field ____.

37. Experian, equifax, and transunion are all types of ______ companies.

38. Every normalized table has ________.

39. The ________ view in access looks similar to an excel spreadsheet.

40. Having several instances of the same data is called data _______.

41. In access, table and field names can be up to ____ characters in length.

42. In a student database, a good key field for a record would be a ______

43. In a database, a group of similar rows is called a ________.

44. In a database table, each row is called a(n) __________ and each column is called a __________.

45. With a _____, users provide an example of the data requested.

46. The most popular search engines such as google use ____ to store information about webpages.

47. The size of a database is determined by the _____.

48. The _____ command defines a default value for a column when no value is given.

49. In asps, the code to tie the database to the web site is typically written in javascript or ____.

50. In a doubly nested set of not exists select statements, ________.

51. A(n) ______ is a number(s) or character(s) appended to or inserted in a primary key value.

52. A(n) _____ can use a shared connection to the database instead of creating a new one every time.

53. _____ use a keyword to encode a number.

54. A join line is also called a(n) ____ line.

55. A multilevel sort calls for using the ____ feature.

56. ____ codes combine data from different item attributes, or characteristics, to build the code.

57. You can restrict the output from a join to include only certain columns by using the ____ command.

58. The field ______ defines the maximum number of characters a field can contain.

59. In a database, the collection of data for all columns is called a ________.

60. Any attribute that is part of a key is known as a ____.

61. The ____ structure is quite different from that of an operational or transactional database.

62. The preferred placement for a foreign key when working with a 1:1 relationship is to ____.

63. In the accompanying figure, the small box or bar to the left of each field is called the ____.

64. A field used to connect one table logically with another table is called a ____ field.

65. A(n) _____ represents a particular type of object in the real world.

66. Designing tables is easier if a _____ is used to show a table?s structure, fields, and primary key.

67. A(n) ____ is a property of an entity.

68. A collection of related records in a database is referred to as a _____.

69. A _____ is a character or group of characters that has a specific meaning.

70. Dial-up internet access is an example of a(n) ____ communications system.

71. Databases are stored in ______ so that they are available when needed.

72. Database management systems _____.

73. Ancient romans believed that their ancestry ____.

74. An attribute that is part of a key is known as a(n) _____ attribute.

75. All of this information is part of a ____ in a database

76. Access saves ____ automatically as you move from record to record.

77. Access database objects are divided into categories on the navigation pane. ____________________

78. A(n) _____ is a good comparison to a database.

79. A(n) ____ stores a query and is used to access data in the underlying tables.

44. In a database table, each row is called a(n) and each column is called a .

144. A schema illustrates the and in a database and the relationships among them.