COMP 72776

subject Type Homework Help
subject Pages 9
subject Words 1031
subject Authors Carlos Coronel Steven Morris

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Computed or derived facts, at run time, are sometimes called__________ to
differentiate them from stored facts.
a. schemas
b. attributes
c. metrics
d. dimensions
____________means that data used during the execution of a transaction cannot be
used by a second transaction until the first one is completed.
a. Serializability
b. Atomicity
c. Isolation
d. Time stamping
Atomic attributes are attributes that can be further subdivided.
a. True
b. False
page-pf2
Oracle recommends______________ for creating audit logs.
a. triggers
b. stored procedures
c. stored functions
d. tables
A(n)_____________ plan is a set of instructions generated at application compilation
time that predetermines how the application will connect to and communicate with the
database at run time.
a. access
b. completion
c. application
d. communications
page-pf3
Durability requires that all portions of the transaction must be treated as a single, logical
unit of work in which all operations are applied and completed to produce a consistent
database.
a. True
b. False
A(n)___________ enables a database administrator to describe schema components.
a. extensible markup language (XML)
b. data definition language (DDL)
c. unified modeling language (UML)
d. query language
_____________are important because they help to ensure data integrity.
a. Attributes
page-pf4
b. Entities
c. Relationships
d. Constraints
A DDBMS is subject to which of the following restrictions?
a. Multiple instances of the same database should be integrated over a network.
b. All database processing must be done at a single site.
c. Rapid ad hoc data access is not possible.
d. Remote data access is provided on a read-only basis.
In a typical star schema, each dimension record is related to thousands of________
records.
a. attribute
b. fact
c. key
d. primary
page-pf5
An explicit cursor must return two or more rows.
a. True
b. False
In the context of the Oracle Enterprise Manager, a(n)_____________ is a uniquely
identifiable object that allows a given person to log on to the database.
a. user
b. role
c. profile
d. client
page-pf6
A_____________ is a character or group of characters that has a specific meaning.
a. database
b. field
c. record
d. file
To generate database object statistics manually, following syntax should be used in
Oracle:____________ .
a. ANALYZE <TABLE/INDEX> object_name;
b. CREATE <TABLE/INDEX> object_name;
c. ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;
d. CREATE <TABLE/INDEX> object_name COMPUTE STATISTICS;
A ____________is a primary key created by a database designer to simplify the
identification of entity instances.
a. composite key
b. compound key
page-pf7
c. natural key
d. surrogate key
Data warehouse routinely uses _____________structures in its complex, multilevel,
multisource data environment.
a. 1NF
b. 2NF
c. 3NF
d. 4NF
A___________ derives its name from the fact that a collection of multiple entries of the
same type can exist for any single key attribute occurrence.
a. partial dependency
b. transitive dependency
c. repeating group
d. primary key
page-pf8
The DBA can use an audit log to automatically record a brief description of the
database operations performed by the users.
a. True
b. False
In a natural join, the column on which the join was made occurs twice in the new table.
a. True
b. False
An XML database supports the storage and management of_________ XML data.
a. structured
page-pf9
b. multistructured
c. fullystructured
d. semistructured
The CHECK constraint is used to define a condition for the values that the attribute
domain cannot have.
a. True
b. False
A noun in a business rule translates to a(n)________ in the data model.
a. entity
b. attribute
c. relationship
d. constraint
page-pfa
To be considered minimally relational, the DBMS must support the key relational
operators___________ , PROJECT, and JOIN.
a. INTERSECT
b. UNION
c. DIFFERENCE
d. SELECT
An alias cannot be used when a table is required to be joined to itself in a recursive
query.
a. True
b. False
Which of the following types of HDFS nodes stores all the metadata about a file
system?
page-pfb
a. Data node
b. Client node
c. Name node
d. Map node
When performing user access management, a DBA defines each user to the database at
the_____________ levels.
a. application and DBMS
b. operating system and DBMS
c. operating system and application
d. application and network
Which of the following is true of a web application server?
a. It is Microsoft's implementation of a superset of the SQL Access Group CLI standard
for database access.
b. It is automatically invoked by the browser when needed.
page-pfc
c. It runs on the client machine, freeing server resources.
d. It provides security and authentication of users through user IDs and passwords.
The implementation and loading phase of the Database Life Cycle (DBLC)
involves____________ .
a. defining objectives
b. introducing changes
c. testing the database
d. installing the DBMS
Accurate, relevant, and timely information is the key to__________________ .
a. data management
b. good decision making
c. knowledge
d. understanding
page-pfd
The most useful feature of PL/SQL blocks is that they let a designer create code that
can be named, stored, and executed by the DBMS.
a. True
b. False

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.