> > Database MCQs > Introduction to Database MCQs

Introduction to Database MCQ

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

A form's object name appears on the tab for the form in the access window. ____________________

True

False

Answer

Correct Answer:

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

____ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

_____ 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

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

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

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

Sequence

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

__________ 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

________ 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

_____ 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

____ 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

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

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

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

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

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

_____, 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

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

Mauna ___ crossword

LOA

KEA

NUCLEOSIS

ARS

Answer

Correct Answer: LOA

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

General ___ chicken crossword

TSOS

HOTPOT

TENDERS

POX

Answer

Correct Answer: TSOS

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

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

Dies ____ crossword

IRAE

ACTV

EBBS

DONNE

Answer

Correct Answer: IRAE

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

Christii___

ANNO

CORPUS

NEE

Answer

Correct Answer: ANNO

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

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

___ nous crossword

ENTRE

WIT

GUMPTION

ILS

Answer

Correct Answer: ENTRE

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

___ la la crossword

TRA

OOH

REFRAIN

TIS

Answer

Correct Answer: TRA

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

___ fly crossword

SAC

TSETSE

LET

FRUIT

Answer

Correct Answer: SAC

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

___ 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

___ avis

RARA

BIRD

ALAMO

HERTZ

Answer

Correct Answer: RARA

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

____ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

"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

____ 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

_____ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

____ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

____ 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

____ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

_____ 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

____________________ 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

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

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

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

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

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

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

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

________ 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

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

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

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

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

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

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

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

_________ 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

________ 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

_____ 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

____ 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

____ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

_____ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

More Database Subjects

Database Administration

Database Management System

Database Management System (DBMS)

SQL Server Database

SQL Server DBA

Window Server 2003

Database Organization & Design

Advance Database

Database Concepts

Database Application

Modern Database Management

More Resources

Database Skill Assessment

Database PDF

Related MCQs

Log Shipping

NoSQL

Oracle 10g Database Administration

Oracle 8 DBA

Oracle Forms 9i

Introduction to Database MCQ

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

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

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

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

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

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

Database redesign is fairly easy when ________.

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

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

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

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

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

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

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

The contents of query datasheet are permanent. ____________________

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

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

In a database, bytes are grouped into __________.

A form's object name appears on the tab for the form in the access window. ____________________

____ is a relational set operator.

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

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

A database _____________is organized into rows and columns.

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

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

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

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

Primary keys ensure that ____.

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

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

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

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

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

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

The default group in the navigation pane is ____.

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

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

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

Every normalized table has ________.

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

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

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

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

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

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

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

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

The size of a database is determined by the _____.

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

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

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

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

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

_____ use a keyword to encode a number.

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

A multilevel sort calls for using the ____ feature.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Database management systems _____.

Ancient romans believed that their ancestry ____.

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

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

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

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

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

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

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