> > Database MCQs > Database Management System MCQs

Database Management System MCQ

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

VPN

Database

Net

Hop

Answer

Correct Answer: Hop

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

Recovering a database via rollforward involves ________.

Restoring the database from the save and reprocessing all the transactions since the save

Restoring the database from the save and reapplying all the changes made by transactions since the save

Undoing the changes made by erroneous or partially processed transactions and restarting the valid transactions that were in process at the time of the failure

Re-creating the database by re-entering all of the data from the beginning, and then reprocessing all of the transactions

Answer

Correct Answer: Restoring the database from the save and reprocessing all the transactions since the save

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

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

Numeric filingsystem

Sequentialorder

Records managementsystem

None of these

Answer

Correct Answer: Records managementsystem

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

Decision makers can access analytical databases using an executive __________.

RECORD

CONVERSION

DATABASE

DASHBOARD

Answer

Correct Answer: DASHBOARD

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

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

IBM DB2

Microsoft Access

Adobe Acrobat

Adobe Fireworks.

Answer

Correct Answer: Microsoft Access

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

Data warehouses are sometimes called hypercubes because they _____.

Are function oriented.

Store multidimensional data.

Capture raw transaction data

None of these

Answer

Correct Answer: Capture raw transaction data

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

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

Atomicity, communication, integrity, and data

Atomicity, consistency, isolation, and durability

Authenticity, currency, information, and design

Accuracy, clarity, information, and data

Answer

Correct Answer: Atomicity, consistency, isolation, and durability

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

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

Authorized

Limited

Any

Unauthorized.

Answer

Correct Answer: Authorized

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

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

Audit log

Datafile

Schema

Tablespace.

Answer

Correct Answer: Tablespace.

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

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

Network

Tacit

Character

Flows

Answer

Correct Answer: Character

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

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

One

Two

Three

Six

Answer

Correct Answer: One

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

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

Access control

Independence

Decision Model

Organizational chart

Answer

Correct Answer: Access control

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

SET ORDER

ORDER BY

LIST BY

Answer

Correct Answer: ORDER BY

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

____ is an example of assistive output devices.

Web-based training (WBT)

Videoconferencing

Electronic profiling

Screen reader software

Answer

Correct Answer: Screen reader software

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

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

Select

Distinct

Sort

Unique

Answer

Correct Answer: Distinct

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

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

Object_oriented

XML/Hybrid data model

Constraints

Entity

Answer

Correct Answer: XML/Hybrid data model

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

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

Unnormalized relation

primary key

Partial Dependencies

None of this

Answer

Correct Answer: Unnormalized relation

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

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

Entity

Attribute

Relationship

Constraint

Answer

Correct Answer: Relationship

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

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

Insert

Update

Import

Select

Answer

Correct Answer: Insert

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

A total completeness constraint is represented by _____.

Enhanced entity relationship model

A single abstract entity object

A double horizontal line under a circle

Entity instance or row

A single horizontal line under a circle

Answer

Correct Answer: A double horizontal line under a circle

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

Enclosed entity relationship model

Enhanced entity relationship model

Entity clustering relationship model

Extended entity relationship diagram

Answer

Correct Answer: Enhanced entity relationship model

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

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

Data anomaly

Query

Information

Metadata

Answer

Correct Answer: Query

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

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

Many

An entity supertype

Inheritance

Equality

Answer

Correct Answer: Many

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

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

Triangle

Circle

Rounded box

Square box

Open rectangle

Answer

Correct Answer: Rounded box

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

________ integrates data from various operational systems.

Data warehouse.

Metadata repository.

Data modeling.

Master data.

Data mining.

Answer

Correct Answer: Data warehouse.

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

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

Create-table

Make-table

New-table

Merge-table

Answer

Correct Answer: Make-table

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

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

WSU

Domain

DNS

Answer

Correct Answer: Domain

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

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

Form Layout

Pagination

Report Wizard

Print Preview

Answer

Correct Answer: Print Preview

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

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

Maximum and minimum

CRS_CODE and CLASS_SECTION

Single-valued

Associative

Answer

Correct Answer: Maximum and minimum

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

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

data cube

data mart

data feed

data repository

Answer

Correct Answer: data repository

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

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

Multivalued

Composite

Simple

Single-valued.

Answer

Correct Answer: Composite

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

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

Data isolation

Data integrity

Data consistency

Data redundancy

Application/Data dependence

Answer

Correct Answer: Data isolation

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

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

Introducing changes

Testing the database

Installing evolution

None of these

Answer

Correct Answer: Introducing changes

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

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

Joined

Shared

Redundant

Nonkey

Answer

Correct Answer: Redundant

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

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

Database administrator.

Preliminary investigation

Artificial intelligence (AI)

Accounting systems

Answer

Correct Answer: Database administrator.

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

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

Completeness

Range

Article

Answer

Correct Answer: Range

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

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

Database

@string

#string

All of these

Answer

Correct Answer: Database

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

____ can describe any type of data.

DOCX

HTML

XLTX

XML

Answer

Correct Answer: XML

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

The initial assessment and the feasibility study are part of the sdlc's ____ phase.

Maintenance

Systems

Planning

Database

Answer

Correct Answer: Planning

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

A _____ relationship exists when an association is maintained within a single entity.

Binary

Ternary

Weak

Unary.

Answer

Correct Answer: Binary

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

A(n) _____ is bidirectional.

Attribute

Entity

Relationship

Constraint

Answer

Correct Answer: Relationship

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

The oracle equivalent to an ms access autonumber is a(n) _____.

Auto-number.

Sequence.

TO_NUMBER function

Trigger. sequence.

Answer

Correct Answer: Auto-number.

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

"union-compatible" means that the ____.

Inner

Outer

MINUS

UNION

Answer

Correct Answer: UNION

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

Secondary

Neither primary nor secondary

None of the above

Answer

Correct Answer: Primary

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

The characteristics of an entity are called ____.

Entities.

Attributes.

Identifiers.

Relationships.

Answer

Correct Answer: Attributes.

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

The acronym ____________ refers to software that manages data stored in a database.

ERP

SQL

OLAP

DBMS

Answer

Correct Answer: DBMS

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

The _____ relationship should be rare in any relational database design.

1:1

1:M

M:1

M:N

Answer

Correct Answer: 1:1

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

Microsoft's most powerful dbms is ________.

SQL Server

MySQL

DB2

Oracle

Excel.

Answer

Correct Answer: SQL Server

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

______ are abstractions of reality that explain how things work.

Mental Models

Blue Prints

Both a and b

None of the above

Answer

Correct Answer: Mental Models

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

The ____ command will create an application program's or individual user's picture of the database.

CREATE INDEX

SELECT INDEX

SELECT VIEW

CREATE VIEW

Answer

Correct Answer: CREATE VIEW

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

Primary keys ensure that ____.

Duplicate records are stored in the database

Duplicate records are not stored in the database

Management system

Data redundancy

Answer

Correct Answer: Duplicate records are not stored in the database

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

Data warehouse contains historical data obtained from the _____.

Operational databases

Enterprise databases

Desktop database

Workgroup databases

Answer

Correct Answer: Operational databases

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

One way to locate records on a form is to use the find button on the ____ tab in the find group.

HOME

Name

Button

Font Weight

Answer

Correct Answer: HOME

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

To change the caption for a form, use the ____ property in the property sheet.

Font Weight

Caption

Build

Text Box

Answer

Correct Answer: Caption

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

The database structure in a dbms is stored as a _____.

Single file

Collection of files

Set of key/value pairs

Collection of queries

Answer

Correct Answer: Collection of files

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

A is a member function that is automatically called when a class object is .

Destructor, created

Constructor, created

Static function, deallocated

Utility function, declared

None of these

Answer

Correct Answer: Constructor, created

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

Sql is an example of a ________ category programming language.

2GL

3GL

4GL

5GL

Answer

Correct Answer: 4GL

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

In a star schema, dimensions are normally stored in ____.

Attributes

Indexes

Fact tables

Dimension tables

Answer

Correct Answer: Dimension tables

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

________ represent the movement of data from one activity to another.

Data charts

Data buses

Data modules

Data flows

Answer

Correct Answer: Data flows

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

The ____ data type is used to store integers

INTEGER

NUMERAL

NUMBER

INT

Answer

Correct Answer: INT

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

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

Variable

Attachment

VarChar

Long Text

Answer

Correct Answer: Long Text

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

One of the challenges with unsupervised data mining is ________.

The analyst must develop explanations for patterns after observing the pattern

It can be made coarser by summing and combining

The machines that are running the analysis will possess and create information for themselves

Big Data can be processed with traditional techniques

Answer

Correct Answer: The analyst must develop explanations for patterns after observing the pattern

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

Most data you encounter is best classified as ____.

Structured

Semistructured

Unstructured

Historical

Answer

Correct Answer: Semistructured

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(n) ____ is a data element containing the address of another data element.

Pointer

Data structure

Object

List

Answer

Correct Answer: Pointer

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

Changing cardinalities ________.

Create a new table, move the data and drop the old tablea famous pattern in SQL

Regularly used

There is no data in the database

Commonly occurs in database redesign

Answer

Correct Answer: Commonly occurs in database redesign

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

A table that displays data redundancies yields _____.

Insertion

Deletion

Update

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

Physically

Both of the above

None of the above

Answer

Correct Answer: Both of the above

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

Maximum cardinality refers to ________.

The most instances of one entity class that can be involved in a relationship instance with another entity class

The minimum number of entity classes involved in a relationship

Whether or not a

Answer

Correct Answer: The most instances of one entity class that can be involved in a relationship instance with another entity class

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

________ duplicates data across databases.

Data propagation.

Data duplication.

Redundant replication.

A replication server

Answer

Correct Answer: Data propagation.

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

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

Asterisk (*)

Colon (:)

Statistical

Structure

Answer

Correct Answer: Asterisk (*)

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

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

COMMIT.

DELETE.

ERASE.

KILL

Answer

Correct Answer: DELETE.

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

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

INTO

CTE

Outer

JOIN

Answer

Correct Answer: INTO

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

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

Source

Structure

Design

Back Office

Answer

Correct Answer: Design

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

The syntax for a left outer join is ____.

"SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition"

"SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition"

"SELECT column-list WHERE LEFT table1 = table 2"

"SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition"

Answer

Correct Answer: "SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition"

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

The sql command ________ defines a logical table from one or more tables or views.

Create table

Alter table

Create view

Create relationship

Answer

Correct Answer: Create view

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

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

COUNT

AVG

MAX

SUM

Answer

Correct Answer: AVG

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

The sql ________ statement allows you to combine two different tables.

SELECT

GROUP BY

JOIN

COMBINE

ORDER BY

Answer

Correct Answer: JOIN

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

The pl/sql block starts with the _____ section.

OPEN

DECLARE

BEGIN

Answer

Correct Answer: DECLARE

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

The pl/sql block starts with the ____ clause.

IS.

OPEN.

DECLARE.

BEGIN

Answer

Correct Answer: BEGIN

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

And

Less than

Not equal to

Answer

Correct Answer: Not equal to

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

The _____ statement combines rows from two queries and excludes duplicates.

UNION ALL

MINUS

UNION

INTERSECT

Answer

Correct Answer: UNION

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

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

AND

UNION

Answer

Correct Answer: IN

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

The _____ data type is compatible with number.

VARCHAR(15)

SMALLINT

DATE

CHAR(10)

Answer

Correct Answer: SMALLINT

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

The _____ command replaces the ***** in the syntax of the update command, shown above.

SET columnname = expression

Columnname = expression

Expression = columnname

LET columnname = expression

Answer

Correct Answer: SET columnname = expression

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

The ____ function calculates the number of entries in a table.

COUNT

UPDATE

INSERT

Answer

Correct Answer: COUNT

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

The ____ function calculates a total of the values in a column.

BETWEEN

VARCHAR

SUM

Answer

Correct Answer: SUM

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

Sql queries that use exists and not exists are ________.

Normal subqueries

Correlated subqueries

Uncorrelated subqueries

Constraint dependent subqueries

Answer

Correct Answer: Constraint dependent subqueries

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

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

2GL

3GL

4GL

5GL

Answer

Correct Answer: 4GL

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

Oracle 11g is an example of the _____.

Constraints

Relationship

XML/Hybrid data model

Crow's Foot notation

Answer

Correct Answer: XML/Hybrid data model

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.

SHOW TABLE

SHOW LAYOUT

DESC

DISPLAY LAYOUT

Answer

Correct Answer: DESC

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

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

CONVERT()

TO_DATE

TO_CHAR()

TO_STRING()

Answer

Correct Answer: TO_CHAR()

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

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

WHERE

Table

Type

False

Answer

Correct Answer: Type

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

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

Table.

Record.

Row.

Column

Answer

Correct Answer: Table.

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

"lastname" is an example of ________.

Camel case

Pascal case

A typing error

A naming convention that is not recommended because of possible compatibility issues

Answer

Correct Answer: Camel case

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

A _____ index is based on 0 and 1 bits to represent a given condition.

Logical

Multidimensional

Normal

Bitmapped

Answer

Correct Answer: Bitmapped

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

When designing a database, you should _____.

The level of detail represented by the values stored in a table's row

Crow's Foot notation ERDs

Make sure that the table entities are normalized before table structures are created

None of these

Answer

Correct Answer: Make sure that the table entities are normalized before table structures are created

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

A(n) ____ join will select only the rows with common values in the common attribute(s).

Natural

Cross

Full

Outer

Answer

Correct Answer: Natural

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

A(n) _____ is the set of possible values for a given attribute.

Group

Domain

Set

Range

Answer

Correct Answer: Domain

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.

Processing

Extension

End-of-file

Opening

Answer

Correct Answer: Processing

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

A stored program that is attached to a table or view is called ________.

Pseudofile.

Embedded SELECT statement.

Trigger.

None of the above

Answer

Correct Answer: Trigger.

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

Answer

Correct Answer: Entity.

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

To assign a conditional value, use the ____ function.

Undo

Zoom

IIF

Format

Answer

Correct Answer: IIF

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

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

To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.

ALL

ANY

EXISTS

Answer

Correct Answer: IN

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 close the resultset, use ____.

Mysqli_close()

Mysqli_kill()

Mysqli_exit()

Mysqli_free_result

Answer

Correct Answer: Mysqli_free_result

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

The types of constraints supported in sql are ____.

Primary keys

Legal values

Foreign keys

All of the above

Answer

Correct Answer: All of the above

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

The syntax for the union query is ____.

Query + query

UNION (query, query)

UNION: query query

Query UNION query

Answer

Correct Answer: Query UNION query

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

The statement, ____, removes the table smaller from a dbms.

DELETE TABLE Smaller ;

DROP TABLE Smaller ;

REMOVE TABLE Smaller ;

RID TABLE Smaller

Answer

Correct Answer: DROP TABLE Smaller ;

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

The primary disadvantage of centralized database systems is ________.

Data security

Data quality

Availability of statistical analysis tools

Transmission delay when users are geo-dispersed

Answer

Correct Answer: Transmission delay when users are geo-dispersed

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

The basic form of an sql retrieval command is ____.

SELECT-WHERE-FROM

CREATE-SELECT-FROM

SELECT-WHERE

SELECT-FROM-WHERE

Answer

Correct Answer: SELECT-FROM-WHERE

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

The _______________ constraint assigns a value to an attribute when a new row is added to a table.

CHECK

UNIQUE

NOT NULL

DEFAULT

Answer

Correct Answer: DEFAULT

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

The ____ operator uses one or more wildcard characters to test for a pattern match.

HAVING

SUM

BETWEEN

Answer

Correct Answer: LIKE

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

The ____ operator could be used in place of intersect if the rdbms does not support it.

AND

UNION

Answer

Correct Answer: IN

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

Sql uses search operators such as ____ to form complex queries.

AND

NOT

All of the above

Answer

Correct Answer: All of the above

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

Referential integrity prevents the creation of ____ records.

Indexed

Split

Unlicensed

Orphan

Answer

Correct Answer: Orphan

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

Popular ____ include access, oracle, db2, mysql, and sql server.

E-R diagrams

DBAs

Data files

DBMSs

Answer

Correct Answer: DBMSs

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

Oracle and sql server support the ____ operator but microsoft access does not.

UNION

INTERSECT

MINUS

ALL

Answer

Correct Answer: INTERSECT

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

One of the important functions of a dbms is to provide the necessary tools for ________.

Application programs

Storing data types such as images, audio, and videos in organizations

Administration

Administering the database

Answer

Correct Answer: Administering the database

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

Normalization is normally done to ___ normal form.

2nd

4th

1st

3rd

Answer

Correct Answer: 2nd

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

In sql, you use the check clause to enforce ____ integrity.

Legal-values

REVOKE

Server

Client

Answer

Correct Answer: Legal-values

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

In dbms, data are kept separate from the application's programming code. this means that ________.

An application cannot be changed without making changes to the database

An application's programming code needs to be updated continuously to keep up with the database

An application needs to be changed when database is changed

Database does not need to be changed if a change is made to an application

Database needs to be changed when a change is made to an application

Answer

Correct Answer: Database does not need to be changed if a change is made to an application

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

In an sql query, a ____ clause is used to specify the table you want to access.

SELECT

FROM

Two

SQL

Answer

Correct Answer: FROM

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

Data type helps a database management system (dbms) to ________.

Present the data in a useful format

Format data

Allocate storage space

Eliminate data duplication

Answer

Correct Answer: Allocate storage space

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

From the performance point of view, _____ databases eliminate disk access bottlenecks.

RAID

Distributed

Index-organized

In-memory

Answer

Correct Answer: In-memory

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.

INSERT

ADD

INCLUDE

ALTER

Answer

Correct Answer: ADD

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

The most basic file ____ are characteristics such as filename, creation date, and modified date.

Metadata

Biodata

Phrasedata

None of these

Answer

Correct Answer: Metadata

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

The last part of an sql query to be read is the ________ statement.

Select

Read

Quary

None of these

Answer

Correct Answer: Select

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

Dirty data is ________.

Virus-infected data

Worm-infected data

Inaccurate, incomplete data

Stolen data

Answer

Correct Answer: Inaccurate, incomplete data

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

You would use query by example, if _____.

You wish to use a visual approach to query building

You build a query from an example

You use a template for reports

Wish teach SQL with examples

Answer

Correct Answer: You wish to use a visual approach to query building

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

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

Composite

Conceptual

Create a detailed narrative of the organization's description of operations

None of these

Answer

Correct Answer: Create a detailed narrative of the organization's description of operations

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 ________________ keeps track of all of the processes that update the database.

DBMS

SMS

CSIT

None of these

Answer

Correct Answer: DBMS

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

PROGRAM

DELETE

PROJECT

Answer

Correct Answer: PROJECT

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

A supply chain driven by actual customer orders or purchases follows a ________ model.

Pull-based model

Build-to-stock

Push-based

Replenishment-driven

Answer

Correct Answer: Pull-based model

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

In order to summarize qualitative data, a useful tool is a __________.

Histogram

Stem-and-leaf diagram

Scattergram

Frequency distribiution

Answer

Correct Answer: Frequency distribiution

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

Most family therapists who work with couples concentrate on ______.

Exploring the marital partners' childhoods to understand the source of the current conflicts

Desensitizing techniques to help the marital partners become more tolerant of each other

Changing the behavior of the person in the marriage who is the source of the couple's problems

Improving the couple's patterns of communication so they can find better ways of solving their problems

Answer

Correct Answer: Improving the couple's patterns of communication so they can find better ways of solving their problems

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

School-age children would most admire _____.

Timmy, whose mother kisses him good-bye at school

Marla, who was punished for not telling the teacher who threw a paper airplane

Cheyenne, who is the third-grade teacher's favourite

Gavin, who spends most of his free time with adults

Answer

Correct Answer: Marla, who was punished for not telling the teacher who threw a paper airplane

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

A star schema contains both fact and ________ tables.

Narrative

Cross functional

Dimension

Starter

Answer

Correct Answer: Dimension

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

A spelling mistake in a message is an example of ________

A decoding error

A receiver error

A transmission error

An encoding error

Answer

Correct Answer: An encoding error

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

The total quiz points for a student for an entire semester is a(n) ________ attribute.

Derived

Mixed

Stored

Addressed

Answer

Correct Answer: Derived

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.

Programmerb

Analyst

DBA

CEO

Answer

Correct Answer: DBA

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

The definition for ____ also defines a candidate key.

primary key

candidate key

Repeating groups

Alternate keys

Answer

Correct Answer: primary key

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

The dbms provides applications for processing operations such as ________.

Inserting or deleting information

Administering the database

Table

Processing a database by inserting or modifying data

Answer

Correct Answer: Inserting or deleting information

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.

Parses

Parsing

Optimizer

Data

Answer

Correct Answer: Parses

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

The dbms _____ the data and sends the result set back to the client.

Buffer Cache

Parses

Optimizer

Fetches

Answer

Correct Answer: Fetches

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

The data ____ component is used to create and maintain the data dictionary.

Data dictionary

Data hierarchy

Data model

Data definition

Answer

Correct Answer: Data definition

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

The data ____ component is used to add, delete, modify, and retrieve records from a database.

Manipulation

Creating

Designing

None of the above

Answer

Correct Answer: Manipulation

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

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

PROJECT

Aggregate

False

Product

Answer

Correct Answer: PROJECT

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.

Subquery

IS NULL

BETWEEN

Optional

Answer

Correct Answer: IS NULL

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

The _____ process analyzes sql queries and finds the most efficient way to access data.

Optimizer

Scheduler

Listener

User

Answer

Correct Answer: Optimizer

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

Special data that describe the data contained in a database are called ________.

Relation

Database

Record

Metadata

Answer

Correct Answer: Metadata

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

Some databases use ______, which is a visual approach to developing queries and requests.

Query by Example (QBE)

Database as a Service

Create the entity-relationship model

Drill down

Answer

Correct Answer: Query by Example (QBE)

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

Some attributes are classified as ____.

Simple

Defined

Complex

Grouped

Answer

Correct Answer: Simple

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

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

Attribute

Referential

Data mining

Normalized

Answer

Correct Answer: Normalized

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

Relational databases represent relationships using ________.

Foreign keys

File systems

Metadata

Primary keys

Answer

Correct Answer: Foreign keys

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

Referential integrity is normally enforced by the ____.

Pplication programmer

Database management system

Operating system

User

Answer

Correct Answer: Database management system

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

Reducing redundant data helps improve the _____ of the database.

Accuracy

Look and feel

Formatting

Speed

Answer

Correct Answer: Accuracy

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

Rather than deleting old data, it can be moved to a data __________.

False

True

Dashboard

Potential problems in the design of a relational database are known as ____.

primary key

Update anomalies

Repeating groups

Nonkey attribute

Answer

Correct Answer: Update anomalies

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.

Out

Output

Input

None of the above

Answer

Correct Answer: Output

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

Creating a foreign key

Required

Primary key

Improve performance

Answer

Correct Answer: Required

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

One column of a table in a relational database is called a(n) ____.

Tuple

Table

Primary key

Attribute

Answer

Correct Answer: Attribute

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

Odbc works on the _____ operating system.

DataAdapter

ActiveX

Command

Windows

Answer

Correct Answer: Windows

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

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

3NF

Candidate

3NF

1NF

Answer

Correct Answer: 3NF

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

Most decision-support data are based on historical data obtained from ____.

Operational databases

Data warehouses

Enterprise databases

Answer

Correct Answer: Operational databases

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

Microsoft access can best be described as ____ software.

Objects

[Shift][Tab]

Autonumber

Database

Answer

Correct Answer: Database

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 are encrypted

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

Many programs today use ______ on a webpage as their front end.

True

False

Forms

Field

Answer

Correct Answer: Forms

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

Lock ____ indicates the level of lock use.

Granularity

Atomicity

Page-level

Deadlock

Answer

Correct Answer: Granularity

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

Insert into is an example of ________ code.

DDL

DML

DCL

DNL

Answer

Correct Answer: DML

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

Individual database tables are often referred to as ____.

Attributes

Front end

Maintenance

Flat Files

Answer

Correct Answer: Flat Files

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

In this text, boyce-codd normal form is the same as ____.

First normal form

Inconsistent data

Concatenation

Third normal form

Answer

Correct Answer: Third normal form

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.

CREATE *

Record *

Related *

Database

Answer

Correct Answer: Record *

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

In the sql language, the ________ statement is used to make table definitions.

Create index

Create table

Create session

Select

Answer

Correct Answer: Create table

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

In the accompanying figure, any field that serves as a primary key is called a _____.

Candidate key

Foreign key

Combination key

Answer

Correct Answer: Candidate key

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

In indexed storage, when a file is created, the pointers in the index block are all set to ____.

Working

Relative

Null

Is truncated

Answer

Correct Answer: Null

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

In database systems, a _____ refers to a list of data.

File

Column

Field

Row

Record

Answer

Correct Answer: File

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

In comparison with 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

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

Importing

Student ID#.

Columns

Voice/video

Answer

Correct Answer: Student ID#.

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 general sense, ____________ refers to all the non-hardware components of a digital device.

Software

Technology

Computer

None of these

Answer

Correct Answer: Software

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

Logical Design

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

Is created and saved for backup and recovery purposes

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 security file ____

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

Is created and saved for backup and recovery purposes

Is performed on two or more fields to ensure that they are consistent or reasonable when considered together

Identifies values that are questionable, but not necessarily wrong

Answer

Correct Answer: Is created and saved for backup and recovery purposes

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) ________.

Processing the database

Data that describe data

Data integrity problem

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, the term ________ is synonymous with a category of information.

Matrix

Field

Record

Relation

Answer

Correct Answer: Field

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

False

Field

True

File

Answer

Correct Answer: File

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

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

Servers

Clients

None of these

Answer

Correct Answer: Clients

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

If a primary key combines two or more fields, then it is called a _____.

Candidate key

Foreign key

Composite key

Dedicated key

Answer

Correct Answer: Composite key

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

Granularity refers to ____.

The size of a table

The level of detail represented by the values stored in a table's row

The number of attributes in a table

The number of rows in a table

Answer

Correct Answer: The level of detail represented by the values stored in a table's row

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

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

1NF

3NF

4NF

BCNF

3NF and BCNF

Answer

Correct Answer: 3NF and BCNF

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

File ______ refers to the procedures that keep data current.

Maintenance

Attribute

Multimedia database

Default

Answer

Correct Answer: Maintenance

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

Long text

Text

Answer

Correct Answer: Short text

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

Field values related to records that contain those field values may be listed in a(n) ____.

Inner

True

Index

Null

Answer

Correct Answer: Index

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 category of information in a database is called a(n) ____.

Data file

Attribute

Convenience

Ecommerce

Answer

Correct Answer: Attribute

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

Each attribute of an entity becomes a(n) ________ of a table.

The key contains a lengthy text field

Primary key

Required

Column

Answer

Correct Answer: Column

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

Design view is used to ____ a table.

Cannot be undeleted with the Undo command.

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

Limit To List property box to Yes.

Create or modify the structure of

Answer

Correct Answer: Create or modify the structure of

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.

Entity

Minimum

True

Attributes

Answer

Correct Answer: Minimum

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

Complete categories are represented by ____ line(s) below the category symbol.

Two

Maximum

False

True

Answer

Correct Answer: Two

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

Compared with character-based formats, a _____ offers a more efficient storage method.

Decimal

Unary

Tertiary

Binary

Answer

Correct Answer: Binary

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

Columns that are keys to different tables than the ones in which they reside are called ________.

Database design

Foreign keys

Attributes

Relationship

Answer

Correct Answer: Foreign keys

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

Browser-based applications ________.

Support querying using graphics

Process queries using C++

Are thick-client applications

Can only display static content

Answer

Correct Answer: Support querying using graphics

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

A ____ is a group of interrelated files.

False

The System Development Life Cycle

True

Database

Answer

Correct Answer: Database

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

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

Data cleansing

Data mining

Data warehouse

Data dictionary

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) ________.

Attribute

Primary key

Hadoop

Record

Answer

Correct Answer: Record

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

Another name for a composite entity is a(n) _____ entity.

Bridge

False

Attribute

Unique

Answer

Correct Answer: Bridge

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

An entity that exists to implement a many-to-many relationship is called a(n) ____.

Weak entity

Minimum

Composite entity

Independent entity

Answer

Correct Answer: Composite entity

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

An electronic storage file where firms keep customer information is known as a(n) ________.

Database

Worksheet

Program

Answer

Correct Answer: Database

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

An attribute is also referred to as a ________.

Field

Data mart

False

True

Answer

Correct Answer: Field

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

After a dbms detects a deadlock, the ____ should break the deadlock.

First user

Second user

Database administrator

DBMS

Answer

Correct Answer: DBMS

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.

Attribute

Table

Object

Field

Answer

Correct Answer: Object

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

A(n) ____ synonym is used by others to access an individual's database objects.

PUBLIC

CURRVAL

PUBLCI

PRIVATE

Answer

Correct Answer: PUBLIC

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

A distributed _____ can reference several different local or remote data processing sites.

Request

Site

Data location

Transaction

Answer

Correct Answer: Transaction

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

A database administrator (dba) is responsible for _____.

True

Used for analytical purposes.

Hierarchy

Developing recovery procedures in case data is lost or corrupted

Answer

Correct Answer: Developing recovery procedures in case data is lost or corrupted

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

A data ____ table describes the fields you plan to maintain in a table.

Dialog box

Two or four

Definition

Contains

Answer

Correct Answer: Definition

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 data integrity constraints are not satisfied

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 collection of related records in a database is referred to as a _____.

Field

Table

Primary Key

Report

Answer

Correct Answer: Table

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

A ________ is a highly structured collection of data values organized into separate tables.

False

Database

Data cube

Timeline

Answer

Correct Answer: Database

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

A ________ is a collection 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

A ______ is the highest level of data hierarchy.

Bits

Character

Database

Answer

Correct Answer: Database

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.

Database management system

Data warehouse

Database

Management system

Answer

Correct Answer: Database management system

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

A ____ database supports data distributed across several different sites.

Desktop

Workgroup

Distributed

Enterprise

Answer

Correct Answer: Distributed

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

__________ are the most commonly used database clients.

Operational

Incorrect

Browsers

Primary key

Answer

Correct Answer: Browsers

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

_________ maintains information about various types of objects, events, people, and places.

Web analytics

Infographics

Database

Classification

Answer

Correct Answer: Database

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

________ is used to ensure that data is organized most efficiently in a database.

Artificial intelligence

Centralization

Relational

Normalization

Answer

Correct Answer: Normalization

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

________ involves searching for patterns and relationships among data.

Data mining

Data marting

Data processing

Knowledge management

Data warehousing

Answer

Correct Answer: Data mining

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

________ databases are the most commonly used electronic databases.

Flat-file

Object-oriented

Multidimensional

Relational

Answer

Correct Answer: Relational

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

______ databases are the most frequently used electronic databases.

Flat-file

Object-oriented

Multidimensional

Relational

Answer

Correct Answer: Relational

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

____ is used to reveal the meaning of data.

Relationship

Information

Composite

Unstructured

Answer

Correct Answer: Information

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

Which of the following in true regarding Referential Integrity?

Every primary-key value must match a primary-key value in an associated table

Every foreign-key value must match a foreign-key value in an associated table

Every primary-key value must match a foreign-key value in an associated table

Every foreign-key value must match a primary-key value in an associated table

Answer

Correct Answer: Every foreign-key value must match a primary-key value in an associated table

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

Which of the following is not a level of data abstraction?

View Level

Logical Level

Physical Level

Critical Level

Answer

Correct Answer: Critical Level

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

If every non-key attribute is functionally dependent on the primary key, the relation will be in

Third Normal Form

Fourth Formal Form

Second Normal Form

First Normal Form

Answer

Correct Answer: Third Normal Form

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

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?

None of these

CREATE SCHEMA

All of these

CREATE CLUSTER

CREATE PACKAGE

Answer

Correct Answer: CREATE SCHEMA

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

A _____ DBMS distributes data processing tasks between the workstation and a network server.

Hierarchical

Relational

Network

Client server

None of these

Answer

Correct Answer: Client server

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

Which of the following in true regarding Null Value?

Null < 0

Null > 0

Null = 0

Null < > 0

Answer

Correct Answer: Null < > 0

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

How many types of keys in Database Design?

Foreign key

All of these

Candidate key

Primary key

Answer

Correct Answer: All of these

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

The attribute that can be divided into other attributes is called

Simple Attribute

Derived Attribute

Multi-valued Attribute

Composite Attribute

Answer

Correct Answer: Composite Attribute

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

In DBMS FD stands for _______

Functional dependency

Functional data

Facilitate dependency

Facilitate data

Answer

Correct Answer: Functional dependency

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

A command to remove a relation from an SQL database

Drop table < table name >

Erase table < table name >

Alter table < table name >

Delete table < table name >

Answer

Correct Answer: Drop table < table name >

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

Data integrity control

All of these

Requires the use of passwords to prohibit unauthorized access to the file

Is used to set upper and lower limits on numeric data

None of these

Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files

Answer

Correct Answer: Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files

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

What is ACID properties of Transactions?

Atomicity, Consistency, Isolation, Durability

Atomicity, Consistency, Inconsistent, Durability

Atomicity, Consistency, Isolation, Database

Automatically, Concurrency, Isolation, Durability

Answer

Correct Answer: Atomicity, Consistency, Isolation, Durability

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

A command that lets you change one or more fields in a record is

INSERT

Modify

Look-up

All of these

None of these

Answer

Correct Answer: Modify

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

Snapshot of the dta in the database at a given instant of time is called

Database Instance

Database Schema

Database Snapshot

All of these

Answer

Correct Answer: Database Instance

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

In SQL, which of the following is not a data definition language commands?

GRANT

Revoke

RENAME

UPDATE

None of these

Answer

Correct Answer: UPDATE

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

Administrate supervision of database activities is the responsibility of the

DP Manager

DB Manager

Database Administrator

None of these

DP administration

Answer

Correct Answer: Database Administrator

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

The Primary key must be

Option Non Null or Unique

UNIQUE

Non Null

Option Non Null and Unique

Answer

Correct Answer: Option Non Null and Unique

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

Database locking concept is used to solve the problem of?

Lost Update

Inconsistent Data

All of these

Uncommitted Dependency

Answer

Correct Answer: All of these

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

Report generators are used to

Retrieve information from files

None of these

Both retrieve information from files and answer queries

Store data input by a user

Answer queries

Answer

Correct Answer: Both retrieve information from files and answer queries

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

Data Manipulation Language (DML) is not to

Create information table in the Database

Deletion of information in the Database

Insertion of new information into the Database

Modification of information in the Database

Answer

Correct Answer: Create information table in the Database

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

More Database Subjects

Database Administration

Database Management System (DBMS)

SQL Server Database

SQL Server DBA

Window Server 2003

Database Organization & Design

Advance Database

Introduction to 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

Database Management System MCQ

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

Recovering a database via rollforward involves ________.

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

Decision makers can access analytical databases using an executive __________.

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

Data warehouses are sometimes called hypercubes because they _____.

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

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

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

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

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

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

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

____ is an example of assistive output devices.

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

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

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

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

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

A total completeness constraint is represented by _____.

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

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

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

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

________ integrates data from various operational systems.

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

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

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

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

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

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

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

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

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

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

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

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

____ can describe any type of data.

The initial assessment and the feasibility study are part of the sdlc's ____ phase.

A _____ relationship exists when an association is maintained within a single entity.

A(n) _____ is bidirectional.

The oracle equivalent to an ms access autonumber is a(n) _____.

"union-compatible" means that the ____.

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

The characteristics of an entity are called ____.

The acronym ____________ refers to software that manages data stored in a database.

The _____ relationship should be rare in any relational database design.

Microsoft's most powerful dbms is ________.

______ are abstractions of reality that explain how things work.

The ____ command will create an application program's or individual user's picture of the database.

Primary keys ensure that ____.

Data warehouse contains historical data obtained from the _____.

One way to locate records on a form is to use the find button on the ____ tab in the find group.

To change the caption for a form, use the ____ property in the property sheet.

The database structure in a dbms is stored as a _____.

A ________ is a member function that is automatically called when a class object is ________.

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

Sql is an example of a ________ category programming language.

Microsoft azure sql is an example of a _________________ database.

In a star schema, dimensions are normally stored in ____.

________ represent the movement of data from one activity to another.

The ____ data type is used to store integers

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

One of the challenges with unsupervised data mining is ________.

Most data you encounter is best classified as ____.

A characteristic of operational data is ____.

A characteristic of decision support data is ____.

A(n) ____ is a data element containing the address of another data element.

Changing cardinalities ________.

A table that displays data redundancies yields _____.

A database is an organized collection of ________ related data.

Maximum cardinality refers to ________.

________ duplicates data across databases.

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

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

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

To change a table name, we ________.

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

The syntax for a left outer join is ____.

A is a member function that is automatically called when a class object is .

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