The DIVIDE operation uses one single-column table (e.g., column “a”) as the divisor
and one two-column table (e.g., columns “a” and “b”) as the dividend.
Oracle users can use the Access QBE (query by example) query generator.
During the implementation phase, the hardware, the DBMS software, and application
programs are installed and the database design is implemented.
The Crow’s Foot model is more ____________________-oriented than the Chen
model.
Disaster management includes all the end-user activities designed to secure data
availability following a physical disaster or a database integrity failure.
The ____________________ command, coupled with appropriate search conditions, is
an incredibly powerful tool that enables you to transform data into information.
____________________ are ordered sets of values that are crucial in speeding up data
access.
____________________ completeness means that not every supertype occurrence is a
member of a subtype.
The word “entity” in the ER model corresponds to a table.
Training people to use the DBMS and its tools is not included in the DBA’s technical
activities.
____________________ relationships can be implemented by creating a new entity in
1:M relationships with the original entities.
The ____________________ catalog can be described as a detailed system data
dictionary that describes all objects within the database, including data about table
names, the table’s creator and creation date, the number of columns in each table, the
data type corresponding to each column, index filenames, index creators, authorized
users, and access privileges.
A table is in 2NF if it is in 1NF and it includes no partial dependencies.
Explain the difference between homogeneous and heterogeneous distributed database
systems.
What are the components in the basic ODBC architecture?
Metadata present a more complete picture of the data in the database than the data
itself.
RDBMSs enforce integrity rules automatically.
In an Oracle sequence, the ____________________ pseudo-column retrieves the
current value of a sequence.
Good database performance starts with good database design.