Database Chapters 4,5,7 Midterm 2 quiz
120 Questions I 23 Attempts I Created By golf_pro90 417 days agoPractice for midterm 2
Question Excerpt From Database Chapters 4,5,7 Midterm 2 quiz
| Q.1) | CH -4 A nonkey attribute is also called a(n) |
| A. |
| B. |
| C. |
| D. |
| Q.2) | A primary key whose value is unique across all relations is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.3) | An attribute that may have more than one meaning is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.4) | Two or more attributes having different names but the same meaning are called: |
| A. |
| B. |
| C. |
| D. |
| Q.5) | An understanding of how to merge relation is important because: |
| A. |
| B. |
| C. |
| D. |
| Q.6) | Which of the following anomalies result from a transitive dependency? |
| A. |
| B. |
| C. |
| D. |
| Q.7) | When the value of one attribute (the determinant) determines the value of another attribute, it is called: |
| A. |
| B. |
| C. |
| D. |
| Q.8) | A candidate key must satisfy all of the following conditions EXCEPT: |
| A. |
| B. |
| C. |
| D. |
| Q.9) | A constraint between two attributes is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.10) | A relation that contains no multivalued attributes, and has nonkey attributes solely dependent on the primary key, but contains transitive dependencies is in which normal form? |
| A. |
| B. |
| C. |
| D. |
| Q.11) | When all multivalued attributes have been removed from a relation , it is said to be in: |
| A. |
| B. |
| C. |
| D. |
| Q.12) | All of the following are the main goals of normalization EXCEPT: |
| A. |
| B. |
| C. |
| D. |
| Q.13) | If foreign key is referenced to the primary key in the same relation, we call it: |
| A. |
| B. |
| C. |
| D. |
| Q.14) | When a regular entity type contains a multivalued attribute, one must: |
| A. |
| B. |
| C. |
| D. |
| Q.15) | A relation that contains minimal redundancy and allows easy use is considered to be: |
| A. |
| B. |
| C. |
| D. |
| Q.16) | Which of the following are anomalies that can be caused by redundancies in tables |
| A. |
| B. |
| C. |
| D. |
| Q.17) | The __________ states that no primary key attribute may be null |
| A. |
| B. |
| C. |
| D. |
| Q.18) | A rule that states that each foreign key value must match a primary key value in the other |
| A. |
| B. |
| C. |
| D. |
| Q.19) | A domain definition consists of the following components EXCEPT: |
| A. |
| B. |
| C. |
| D. |
| Q.20) | The entity integrity rule states that: |
| A. |
| B. |
| C. |
| D. |
| Q.21) | Which of the following are properties of relations |
| A. |
| B. |
| C. |
| D. |
| Q.22) | A primary key that consists of more than one attribute is called a: |
| A. |
| B. |
| C. |
| D. |
| Q.23) | An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: |
| A. |
| B. |
| C. |
| D. |
| Q.24) | An attribute (or attributes) that uniquely identifies each row in a relation is called a: |
| A. |
| B. |
| C. |
| D. |
| Q.25) | ________________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated. |
| A. |
| B. |
| C. |
| D. |
| Q.26) | A two-dimensional table of data is called a: |
| A. |
| B. |
| C. |
| D. |
| Q.27) | The relational data model consists of which components? |
| A. |
| B. |
| C. |
| D. |
| Q.28) | Physical database design decisions must be made carefully because of impacts on: |
| A. |
| B. |
| C. |
| D. |
| Q.29) | LAST CH 4 A form of database specification that indicates all the parameters for data storage that are then input to database implementation is: |
| A. |
| B. |
| C. |
| D. |
| Q.30) | START CH5 - A method to allow adjacent secondary memory space to contain rows from several tables is called: |
| A. |
| B. |
| C. |
| D. |
| Q.31) | A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a: |
| A. |
| B. |
| C. |
| D. |
| Q.32) | In which type of file is multiple key retrieval not possible |
| A. |
| B. |
| Q.33) | A(n) _______________ is a routine that converts a primary key value into a relative record number. |
| A. |
| B. |
| C. |
| D. |
| Q.34) | An index of columns from two or more tables that come from the same domain of values is called a: |
| A. |
| B. |
| C. |
| D. |
| Q.35) | One field or combination of fields for which more than one record may have the same combination of values is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.36) | A(n) _______________ is a technique for physically arranging the records of a file on secondary storage devices |
| A. |
| B. |
| C. |
| D. |
| Q.37) | A(n) __________ is a field of data used to locate a related field or record |
| A. |
| B. |
| C. |
| D. |
| Q.38) | A contiguous section of disk storage space is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.39) | While Oracle has responsibility for managing data inside a tablespace, the tablespace as a while is managed by the: |
| A. |
| B. |
| C. |
| D. |
| Q.40) | Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.41) | Another form of demornalization where the same data are stored in multiple places in the database is called: |
| A. |
| B. |
| C. |
| D. |
| Q.42) | All of the following are horizontal partitioning methods in Oracle EXCEPT: |
| A. |
| B. |
| C. |
| D. |
| Q.43) | One disadvantage of partitioning is: |
| A. |
| B. |
| C. |
| D. |
| Q.44) | One advantage of partitioning is: |
| A. |
| B. |
| C. |
| D. |
| Q.45) | Horizontal partitioning makes sense: |
| A. |
| B. |
| C. |
| D. |
| Q.46) | Distributing the rows of data into separate files is called: |
| A. |
| B. |
| C. |
| D. |
| Q.47) | All of the following are common denormalization opportunities EXCEPT: |
| A. |
| B. |
| C. |
| D. |
| Q.48) | Sensitivity testing involves: |
| A. |
| B. |
| C. |
| D. |
| Q.49) | A method for handling missing data is to: |
| A. |
| B. |
| C. |
| D. |
| Q.50) | In which data model would a code table appear |
| A. |
| B. |
| C. |
| D. |
| Q.51) | Which of the following is an objective of selecting a data type? |
| A. |
| B. |
| C. |
| D. |
| Q.52) | The smallest unit of application data recognized by system software is a: |
| A. |
| B. |
| C. |
| D. |
| Q.53) | All of the following are valid datatypes in Oracle 11g EXCEPT |
| A. |
| B. |
| C. |
| D. |
| Q.54) | A detailed coding scheme recognized by system software for representing organization data is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.55) | Database access frequencies are estimated from: |
| A. |
| B. |
| C. |
| D. |
| Q.56) | The storage format for each attribute from the logical data model is chosen to maximize _________________ and minimize storage space |
| A. |
| B. |
| C. |
| D. |
| Q.57) | Designing physical files requires __________ of where and when data are used in various ways |
| A. |
| B. |
| C. |
| Q.58) | A key decision in the physical design process is: |
| A. |
| B. |
| C. |
| D. |
| Q.59) | END CH5 - A requirement to begin designing physical files and databases is: |
| A. |
| B. |
| C. |
| D. |
| Q.60) | START CH 7 - Constraints are a special case of triggers |
| A. |
| B. |
| Q.61) | Persistent stored modules are extensions defined in SQL:1999 that include the capability to add and drop modules of code |
| A. |
| B. |
| Q.62) | SQL:200n allows one to calculate linear regressions, moving averages and correlations without moving the data outside of the database |
| A. |
| B. |
| Q.63) | DBA_USERS contains comments on all tables in an Oracle databse |
| A. |
| B. |
| Q.64) | RDBMS's store database definition information in system-created tables which can be considered a data dictionary |
| A. |
| B. |
| Q.65) | Transaction integrity commands are not used to identify whole units of database changes that must be completed in full for the database to retain integrity |
| A. |
| B. |
| Q.66) | A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid |
| A. |
| B. |
| Q.67) | Combining a table with iself results in a faster query |
| A. |
| B. |
| Q.68) | Correlated subqueries are less efficient than queries that do not use nesting |
| A. |
| B. |
| Q.69) | IF-THEN-ELSE logical processing cannot be accomplished within an SQL statement |
| A. |
| B. |
| Q.70) | The UNION clause is used to combine the output from multiple queries into a single result table |
| A. |
| B. |
| Q.71) | A correlated subquery is executed once for each iteration through the outer loop |
| A. |
| B. |
| Q.72) | 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 doesnt matter which columns are returned |
| A. |
| B. |
| Q.73) | EXISTS takes a value of false if the subquery returns an intermediate result set |
| A. |
| B. |
| Q.74) | In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier |
| A. |
| B. |
| Q.75) | The following query will execute without errors: SQL> select customer.customer_name, salesman.sales_quota from customer where customer.salesman_id = (select saleman_id where lname = 'SMITH'); |
| A. |
| B. |
| Q.76) | The following produce the same result: SQL> select customer_name, customer_city from customer, salesman where customer.salesman_id = salesman.salesman_id and salesman.lname = 'SMITH'; SQL> select customer_name, customer_city from customer where customer.salesman_id = (select salesman_id from salesman where lname = 'SMITH'); |
| A. |
| B. |
| Q.77) | Joining tables or using a subquery may produce the same result |
| A. |
| B. |
| Q.78) | There is a special operation in SQL to join a table to itself |
| A. |
| B. |
| Q.79) | One major disadvantage of the outer join is that information is easily lost |
| A. |
| B. |
| Q.80) | An SQL query that implements an outer join will return rows that do not have matching values in common columns |
| A. |
| B. |
| Q.81) | The natural join is very rarely used |
| A. |
| B. |
| Q.82) | The joining condition of an equi-join based upon an equality |
| A. |
| B. |
| Q.83) | An equi-join is a join in which one of the duplicate columns is eliminated in the result table |
| A. |
| B. |
| Q.84) | Dynamic SQL: |
| A. |
| B. |
| C. |
| Q.85) | In order to embed SQL inside of another language, the __________ statement must be placed before the SQL in the host language |
| A. |
| B. |
| C. |
| D. |
| Q.86) | Embedded SQL consists of: |
| A. |
| B. |
| C. |
| D. |
| Q.87) | A procedure is: |
| A. |
| B. |
| C. |
| D. |
| Q.88) | All of the following are advantages of SQL-invoked routiens EXCEPT: |
| A. |
| B. |
| C. |
| D. |
| Q.89) | SQL-invoked routines can be: |
| A. |
| B. |
| C. |
| D. |
| Q.90) | While triggers run automatically, ________________ do not and have to be called |
| A. |
| B. |
| C. |
| D. |
| Q.91) | All of the following are part of the coding structure for triggers EXCEPT: |
| A. |
| B. |
| C. |
| D. |
| Q.92) | A named set of SQL statements that are considered when a data modification occurs are called |
| A. |
| B. |
| C. |
| D. |
| Q.93) | Extensions defined in SQL-99 that include the capability to create and drop modules of code stored in the database schema across user sessions are called: |
| A. |
| B. |
| C. |
| D. |
| Q.94) | The MERGE command: |
| A. |
| B. |
| C. |
| D. |
| Q.95) | _________ differs from array because it can contain duplicates |
| A. |
| B. |
| C. |
| D. |
| Q.96) | Which of the following is not a new data type that were added in SQL:200n |
| A. |
| B. |
| C. |
| D. |
| Q.97) | RANK and DENSE-RANK are examples of: |
| A. |
| B. |
| C. |
| D. |
| Q.98) | A new set of analytical functions added in SQL:200n are referred to as: |
| A. |
| B. |
| C. |
| D. |
| Q.99) | User-defined data types: |
| A. |
| B. |
| C. |
| D. |
| Q.100) | What results would the following SQL statement produce? SQL> select owner, table_name from dba_tables where table_name = 'CUSTOMERS'; |
| A. |
| B. |
| C. |
| Q.101) | If the DBA wishes to describe all tables in the database, which data dictionary view should be accessed in Oracle? |
| A. |
| B. |
| C. |
| D. |
| Q.102) | User-defined transactions can improve system performance because: |
| A. |
| B. |
| C. |
| D. |
| Q.103) | Explicit commands to manage transactions are needed when: |
| A. |
| B. |
| C. |
| D. |
| Q.104) | All of the following are guidelines for better query design EXCEPT: |
| A. |
| B. |
| C. |
| D. |
| Q.105) | Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by: |
| A. |
| B. |
| C. |
| D. |
| Q.106) | In order for two quieries to be UNION-compatible, they must: |
| A. |
| B. |
| C. |
| D. |
| Q.107) | The UNION clause is used to: |
| A. |
| B. |
| C. |
| D. |
| Q.108) | A _________ is a temporary table used in the FROM clause of an SQL query |
| A. |
| B. |
| C. |
| D. |
| Q.109) | ___________ takes a value of true if a subquery returns an intermediate results table which contains one or more rows |
| A. |
| B. |
| C. |
| D. |
| Q.110) | In SQL, a(n) _________ subquery is a type of subquery in which processing the inner query depends on data from the outer query |
| A. |
| B. |
| C. |
| D. |
| Q.111) | A type of query that is palced within a WHERE or HAVING clause of another query is called a: |
| A. |
| B. |
| C. |
| D. |
| Q.112) | A type of join where a table is joined to itself is called a(n) |
| A. |
| B. |
| C. |
| D. |
| Q.113) | A type of join implemented in SQL-1999 and by extension SQL-2003 that returns all of the data from each table that is joined is called a(n) |
| A. |
| B. |
| C. |
| D. |
| Q.114) | One major advantage of the outer join is that: |
| A. |
| B. |
| C. |
| D. |
| Q.115) | In which of the following situations would one have to use an outer join in order to obtain the desired results? |
| A. |
| B. |
| C. |
| D. |
| Q.116) | A join in which rows that do not have matching values in common columns are still included in the result table is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.117) | The most commonly used form of join operation is the: |
| A. |
| B. |
| C. |
| D. |
| Q.118) | A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.119) | A join in which the joining condition is based on equality between values in the common columns is called a(n): |
| A. |
| B. |
| C. |
| D. |
| Q.120) | A join operation: |
| A. |
| B. |
| C. |
| D. |
Take this quiz by clicking Start button on top.
