Database Management

In the figure below, what is depicted? A) An associative entity B) A unary relationship C) A one-to-one relationship D) A one-to-many relationship

A) An associative entity

Which type of file is most efficient with storage space? A) Sequential B) Hashed C) Indexed D) Clustered

A) Sequential

A primary key that consists of more than one attribute is called a: A) composite key. B) multivalued key. C) cardinal key. D) foreign key.

A) composite key.

A data management platform service is called: A) Software-as-a-service. B) Database-as-a-service. C) Infrastructure-as-a-service. D) Platform-as-a-service.

B) Database-as-a-service.

________ problems are encountered when removing data with transitive dependencies. A) Merging B) Deletion C) Modification D) Insertion

B) Deletion

Which of the following is a principal type of authorization table? A) View B) Subject C) Index D) Transaction

B) Subject

The ________ operator is used to combine the output from multiple queries into a single result table. A) DIVIDE B) UNION C) COLLATE D) INTERSECT

B) UNION

partitioning distributes the columns of a table into several separate physical records. A) Final B) Vertical C) Crossways D) Horizontal

B) Vertical

An appropriate datatype for one wanting a fixed-length type for last name would include: A) BLOB. B) VARCHAR. C) DATE. D) CHAR.

D) CHAR.

The relational data model does, at this time, directly support subtype/supertype relationships. True False

False

When incorrect data have been introduced, the database is best recovered by: A) formatting server. B) restarting from the most recent checkpoint and processing subsequent transactions. C) reloading RDMS software. D) starting with a new ERD.

B) restarting from the most recent checkpoint and processing subsequent transactions.

is used to undo unwanted database changes. A) Encryption B) Rollforward C) Rollback D) Restart

C) Rollback

An appropriate datatype for adding a sound clip would be: A) VARCHAR. B) CHAR. C) DATE. D) BLOB.

D) BLOB.

In the figure below, Customer_ID in the CUSTOMER Table is which type of key? A) Grouped B) Composite C) Standard D) Candidate

D) Candidate

The entity integrity rule states that: A) no primary key attribute can be null. B) each entity must have a primary key. C) a primary key must have only one attribute. D) referential integrity must be maintained across all entities.

A) no primary key attribute can be null.

All of the following are advantages of SQL-invoked routines EXCEPT: A) security. B) sharability. C) efficiency. D) flexibility.

A) security.

A key decision in the physical design process is: A) selecting structures. B) ignoring the size of the database. C) deciding the e-r diagrams. D) deciding on the monitor.

A) selecting structures.

Horizontal partitioning makes sense: A) when different categories of a table's rows are processed separately. B) when only one category is allowed. C) when partitions must be organized the same. D) when less security is needed.

A) when different categories of a table's rows are processed separately.

Data is represented in the form of: A) data trees. B) tables. C) chairs. D) data notes.

B) tables.

A named set of SQL statements that are considered when a data modification occurs are called: A) trapdoors. B) triggers. C) treatments. D) stored procedures.

B) triggers.

The ________ DBA view shows information about all users of the database in Oracle. A) USERS B) DBA_INDEXES C) DBA_USERS D) DBA_VIEWS

C) DBA_USERS

An advantage of partitioning is: A) remote optimization. B) increase redundancy. C) efficiency. D) extra space and update time.

C) efficiency.

Referring to the figure below, which of the following is NOT true? A) A component can be part of an item. B) A component is part of an item. C) A component may be used in many items. D) A component is always used in only one item.

D) A component is always used in only one item.

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called: A) fifth normal form. B) fourth normal form. C) sixth normal form. D) Boyce-Codd normal form.

D) Boyce-Codd normal form.

In which type of file is multiple key retrieval not possible? A) Indexed B) Clustered C) Sequential D) Hashed

D) Hashed

In the SQL language, the ________ statement is used to make table definitions. A) create index B) select C) create session D) create table

D) create table

One major advantage of the outer join is that: A) the query is easier to write. B) information's data type changes. C) information is easily accessible. D) information is not lost.

D) information is not lost.

A database management system needs to provide only three basic facilities for backup and recovery of a database: backup facilities, journalizing facilities, and a recovery manager. True False

False

A default value is the value that a field will always assume, regardless of what the user enters for an instance of that field. True False

False

A file organization is a named portion of primary memory. True False

False

A foreign key is a primary key of a relation that also is a primary key in another relation. True False

False

A relation is in first normal form if it has no more than one multivalued attribute. True False

False

An identifier assigned to an associative entity is also called a cross-relation key. True False

False

Horizontal partitioning refers to the process of combining several smaller relations into a larger table. True False

False

In order to perform a restore/rerun, the database must be mirrored. True False

False

MULTISET is similar to the table datatype. True False

False

SOX stands for the Sorbet-Oxford Act. True False

False

The following code is an example of a correlated subquery. SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID =(SELECT Order_T.CustomerIDFROM Order_TWHERE OrderID = 1008); True False

False

The truncate table statement in SQL creates a new table. True False

False

A DBMS may perform checkpoints automatically or in response to commands in user application programs. True False

True

A DBMS must provide journalizing facilities to provide an audit trail of transactions and database changes. True False

True

A cascading delete removes all records in other tables associated with the record to be deleted. True False

True

A materialized view is not persistent. True False

True

A relation in fifth normal form may not contain any anomalies. True False

True

A tablespace is a named set of disk storage elements in which physical files for the database tables may be stored. True False

True

A trigger can be used for security purposes to prohibit inappropriate actions, such as changing a salary value outside of a business day. True False

True

A typical cause of database destruction is a disk crash. True False

True

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data. True False

True

Establishing IF-THEN-ELSE logical processing within an SQL statement can now be accomplished by using the CASE keyword in a statement. True False

True

One decision in the physical design process is selecting structures. True False

True

One objective of selecting a data type is to minimize storage space. True False

True

Platform-as-a-service is an approach for providing infrastructure resources and tools for developers to be productive. True False

True

Requirements for response time, data security, backup, and recovery are all requirements for physical design. True False

True

SQL allows one to calculate linear regressions, moving averages, and correlations without moving the data outside of the database. True False

True

The UNION clause is used to combine the output from multiple queries into a single result table. True False

True

The advantages of SQL-invoked routines are flexibility, efficiency, sharability, and applicability. True False

True

The allowable range of values for a given attribute is part of the domain constraint. True False

True

Triggers have three parts: the event, the condition, and the action. True False

True

VarChar2 would be appropriate for a user that wanted a text datatype for LastName that would only consume the required space. True False

True

View integration is the process of merging relations together. True False

True

With ________, the database itself is lost, destroyed, or cannot be read. A) database destruction B) system failure C) incorrect data D) aborted transaction

A) database destruction

A join operation: A) causes two disparate tables to be combined into a single table or view. B) causes two tables with a common domain to be combined into a single table or view. C) is used to combine indexing operations. D) brings together data from two different fields.

B) causes two tables with a common domain to be combined into a single table or view.

While Oracle has responsibility for managing data inside a tablespace, the tablespace, as a whole, is managed by the: A) user. B) operating system. C) CEO. D) XML.

B) operating system.

A cloud computing approach in which the service consists of infrastructure resources and additional tools that enable application and solution data management solution developers to reach a high level of productivity is called: A) Software-as-a-service. B) Infrastructure-as-a-service. C) Platform-as-a-service. D) Tools-as-a-service.

C) Platform-as-a-service.

In most cases, the goal of ________ dominates the design process. A) quick pointer updates B) security C) efficient data processing D) shorter design times

C) efficient data processing

A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices. A) retrieval program B) update program C) file organization D) physical pointer

C) file organization

Distributing the rows of data into separate files is called: A) file allocation. B) vertical partitioning. C) horizontal partitioning. D) normalization.

C) horizontal partitioning.

All of the following are the main goals of normalization EXCEPT: A) make it easier to maintain data. B) simplify the enforcement of referential integrity. C) maximize storage space. D) minimize data redundancy.

C) maximize storage space.

A requirement to begin designing physical files and databases is: A) physical tables created. B) all datatypes determined. C) normalized relations. D) implementation complete.

C) normalized relations.

Controls incorporated into a data management system that restrict access to data are called authentication rules. True False

False

EXISTS takes a value of false if the subquery returns an intermediate result set. True False

False

Free range partitioning is a type of horizontal partitioning in which each partition is defined by a range of values for one or more columns in the normalized table. True False

False

The following query will execute without errors. SELECT Customer.Customer_Name, Salesman.Sales_Quota FROM Customer WHERE Customer.Salesman_ID =(SELECT Salesman_IDWHERE Lname = 'SMITH'); True False

False

The logical database design always forms the best foundation for grouping attributes in the physical design. True False

False

There are two principal types of authorization tables: one for subjects and one for facts. True False

False

There can be multivalued attributes in a relation. True False

False

User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead. True False

False

Using an outer join produces this information: rows that do not have matching values in common columns are not included in the result table. True False

False

When a subquery is used in the FROM clause, it is called a denied table. True False

False

When EXISTS or NOT EXISTS is used in a subquery, the select list of the subquery will usually just select all columns as a placeholder because it doesn't matter which columns are returned. True False

True