In the ODBC architecture, a(n)__________ is in charge of managing all database
connections.
a. ODBC API
b. DLL
c. ODBC driver
d. driver manager
A(n)_______________ is a logical storage area in Oracle.
a. audit log
b. datafile
c. schema
d. tablespace
Cloud services allow any organization to quickly and economically add information
technology services to its IT portfolio.
a. True
b. False
Training people to use the DBMS and its tools is not included in the responsibilities of a
DBA.
a. True
b. False
The SQL query to output the contents of the EMPLOYEE table sorted by last name,
first name, and initial is_____.
a. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE
LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
b. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE
ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
c. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE
DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
d. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE
SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
In most modern relational DBMSs, a new database implementation requires the
creation of special storage-related constructs to house the end-user tables.
a. True
b. False
A data dictionary is sometimes described as “the database designer’s database” because
it records the design decisions about tables and their structures.
a. True
b. False
When designing a database, you should_____________ .
a. make sure that entities are in normal form before table structures are created
b. create table structures then normalize the database
c. only normalize the database when performance problems occur
d. consider more important issues such as performance before normalizing
The conflicts between design efficiency, information requirements, and performance are
often resolved through_____.
a. compromises that include normalization
b. conversion from 2NF to 3NF
c. compromises that include denormalization
d. conversion from 3NF to 4NF
SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
a. True
b. False
To remove a row from the PRODUCT table, one must use the________ command.
a. COMMIT
b. DELETE
c. ERASE
d. KILL
Having a web-based database interface eliminates the design and implementation issues
of a database system.
a. True
b. False
Data warehouse data are organized and summarized by table, such as CUSTOMER and
ADDRESS.
a. True
b. False
An operational database is sometimes referred to as an enterprise database.
a. True
b. False
A statement-level trigger is assumed if a designer omits the FOR EACH ROW
keywords.
a. True
b. False
In the Systems Development Life Cycle(SDLC), the design of the system’s processes
begins in the detailed systems design phase.
a. True
b. False
__________________are general statements of direction or action that communicate
and support DBA goals.
a. Standards
b. Policies
c. Guidelines
d. Procedures
The first step in building an entity-relationship diagram (ERD)
is_________________________________ .
a. developing the initial ERD
b. creating a detailed narrative of the organization’s description of operations
c. identifying the attributes and primary keys that adequately describe the entities
d. identifying the business rules based on the description of operations
The special operator used to check whether an attribute value matches a given string
pattern is ____________.
a. BETWEEN
b. IS NULL
c. LIKE
d. IN
The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and
the V_NAME, V_AREACODE, V_PHONE and V_CONTACT fields from the
VENDOR table, where the values of V_CODE match and the output is ordered by the
price is ___________________.
a. SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME,
VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY
PRODUCT.P_PRICE;
b. SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME,
VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY
PRODUCT.P_PRICE;
c. SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME,
VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY
PRODUCT.P_PRICE;
d. SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME,
VENDOR.V_CONTACT,
VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY
PRODUCT.P_PRICE;
A dependency of one nonprime attribute on another nonprime attribute is a partial
dependency.
a. True
b. False
____________relationships occur when there are multiple relationship paths between
related entities.
a. Redundant
b. Duplicated
c. Time-variant
d. Supertype
Which of the following is the first step of query processing at the DBMS server end?
a. Executing
b. Parsing
c. Fetching
d. Delivering
If you have three different transitive dependencies,___________ different
determinant(s) exist.
a. one
b. two
c. three
d. four
Today, most relational database products can be classified as object/relational.
a. True
b. False
The _____ is an advanced data definition language that is used to describe the structure
of XML data documents.
a. XHTML
b. HTML schema
c. DTD
d. XML schema
To provide better performance, some OLAP systems merge data warehouse and data
mart approaches by storing small extracts of the data warehouse at end-user
workstations.
a. True
b. False
In the context of data models, an entity is a person, place, thing, or event about which
data will be collected and stored.
a. True
b. False
Improving__________ leads to more flexible queries.
a. atomicity
b. normalization
c. denormalization
d. derived attribute
Current distributed database management system (DDBMS) are subject to some
problems, such as the complexity of management and control.
a. True
b. False
Assume you are using the UNION ALL operator to combine the results from two tables
with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table
contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne
and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2
table. How many records are returned when using the UNION ALL operator?
a. 7
b. 10
c. 15
d. 17
The main concern with redundant relationships is that they remain across________ the
model.
The _____________table space is the most frequently accessed table space and should
be stored in its own volume.
In the context of the advancements in DBMS technology, the use of _________data
services can free the DBA from many lower-level technology-oriented tasks.
Describe the important features and applications of SQL functions
An alternate syntax for a join is: SELECT column-list FROM table1 JOIN
table2____________ (common-column).
A row-level trigger requires use of the keywords___________ and is executed once for
each row affected by the triggering statement.
Unique values can be better managed when they are________ , because the database
can use internal routines to implement a counter-style attribute that automatically
increments values with the addition of each new row.
What are the advantages of having the DBMS between the end user’s applications and
the database?
A(n)______________ provides limited additional semantic value to XML, such as data
type support or data validation rules.
Identifying the attributes of entities helps in the better understanding of__________
among entities.
The term__________ is used to refer to the task of creating a conceptual data model
that could be implemented in any DBMS.
What is the difference between decision support data and operational data from the
point of view of data analyst?
The Crow’s Foot notation depicts the strong relationship with a(n)_________– line
between the entities.
Summarize the hierarchy of steps involved in creating and running an executable
program with embedded SQL statements.
Explain the transaction log. What is its function?
_______________is a read-only database optimized for data analysis and query
processing.
________________relates to activities that make a database operate more efficiently in
terms of storage and access speed.
How should storage volumes be allocated for indexes, system, and high-usage tables?