Database Question 5

Database question 3 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. ________ problems are encountered when removing data with transitive dependencies. A) Merging B) Deletion C) Modification D) Insertion B) Deletion 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. A relation is in first normal form if it has no more than one multivalued attribute. True False False The relational data model does, at this time, directly support subtype/supertype relationships. True False False A cascading delete removes all records in other tables associated with the record to be deleted. True False True The allowable range of values for a given attribute is part of the domain constraint. True False True A relation in fifth normal form may not contain any anomalies. True False True View integration is the process of merging relations together. True False True A foreign key is a primary key of a relation that also is a primary key in another relation. True False False 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. Data is represented in the form of: A) data trees. B) tables. C) chairs. D) data notes. B) tables. 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. 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. The truncate table statement in SQL creates a new table. True False False An identifier assigned to an associative entity is also called a cross-relation key. True False False 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 There can be multivalued attributes in a relation. True False False 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 Horizontal partitioning refers to the process of combining several smaller relations into a larger table. True False False 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. 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 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 DBMS may perform checkpoints automatically or in response to commands in user application programs. True False True An advantage of partitioning is: A) remote optimization. B) increase redundancy. C) efficiency. D) extra space and update time. C) efficiency. 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 SOX stands for the Sorbet-Oxford Act. True False False The logical database design always forms the best foundation for grouping attributes in the physical design. True False False partitioning distributes the columns of a table into several separate physical records. A) Final B) Vertical C) Crossways D) Horizontal B) Vertical Distributing the rows of data into separate files is called: A) file allocation. B) vertical partitioning. C) horizontal partitioning. D) normalization. C) horizontal partitioning. 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 Requirements for response time, data security, backup, and recovery are all requirements for physical design. 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 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. A typical cause of database destruction is a disk crash. True False True 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. 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. One objective of selecting a data type is to minimize storage space. True False True In which type of file is multiple key retrieval not possible? A) Indexed B) Clustered C) Sequential D) Hashed D) Hashed 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. In order to perform a restore/rerun, the database must be mirrored. True False False 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 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. Which type of file is most efficient with storage space? A) Sequential B) Hashed C) Indexed D) Clustered A) Sequential 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 VarChar2 would be appropriate for a user that wanted a text datatype for LastName that would only consume the required space. True False True 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. 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 There are two principal types of authorization tables: one for subjects and one for facts. True False False Which of the following is a principal type of authorization table? A) View B) Subject C) Index D) Transaction B) Subject Controls incorporated into a data management system that restrict access to data are called authentication rules. True False False One decision in the physical design process is selecting structures. True False True An appropriate datatype for adding a sound clip would be: A) VARCHAR. B) CHAR. C) DATE. D) BLOB. D) BLOB. A file organization is a named portion of primary memory. True False False A DBMS must provide journalizing facilities to provide an audit trail of transactions and database changes. True False True is used to undo unwanted database changes. A) Encryption B) Rollforward C) Rollback D) Restart C) Rollback 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 Platform-as-a-service is an approach for providing infrastructure resources and tools for developers to be productive. 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 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 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 advantages of SQL-invoked routines are flexibility, efficiency, sharability, and applicability. True False True MULTISET is similar to the table datatype. 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 User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead. True False False Triggers have three parts: the event, the condition, and the action. True False True EXISTS takes a value of false if the subquery returns an intermediate result set. True False False SQL allows one to calculate linear regressions, moving averages, and correlations without moving the data outside of the database. True False True 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 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 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 materialized view is not persistent. True False True 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. The UNION clause is used to combine the output from multiple queries into a single result table. True False True When a subquery is used in the FROM clause, it is called a denied table. 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 ________ 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 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 All of the following are advantages of SQL-invoked routines EXCEPT: A) security. B) sharability. C) efficiency. D) flexibility. A) security.