Database Chapters 4,5,7 Midterm 2 Quiz

120 Questions  I  By Golf_pro90
Practice for midterm 2

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  CH -4 A nonkey attribute is also called a(n)
A.
B.
C.
D.
2.  A primary key whose value is unique across all relations is called a(n):
A.
B.
C.
D.
3.  An attribute that may have more than one meaning is called a(n):
A.
B.
C.
D.
4.  Two or more attributes having different names but the same meaning are called:
A.
B.
C.
D.
5.  An understanding of how to merge relation is important because:
A.
B.
C.
D.
6.  Which of the following anomalies result from a transitive dependency?
A.
B.
C.
D.
7.  When the value of one attribute (the determinant) determines the value of another attribute, it is called:
A.
B.
C.
D.
8.  A candidate key must satisfy all of the following conditions EXCEPT:
A.
B.
C.
D.
9.  A constraint between two attributes is called a(n):
A.
B.
C.
D.
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.
11.  When all multivalued attributes have been removed from a relation , it is said to be in:
A.
B.
C.
D.
12.  All of the following are the main goals of normalization EXCEPT:
A.
B.
C.
D.
13.  If foreign key is referenced to the primary key in the same relation, we call it:
A.
B.
C.
D.
14.  When a regular entity type contains a multivalued attribute, one must:
A.
B.
C.
D.
15.  A relation that contains minimal redundancy and allows easy use is considered to be:
A.
B.
C.
D.
16.  Which of the following are anomalies that can be caused by redundancies in tables
A.
B.
C.
D.
17.  The __________ states that no primary key attribute may be null
A.
B.
C.
D.
18.  A rule that states that each foreign key value must match a primary key value in the other
A.
B.
C.
D.
19.  A domain definition consists of the following components EXCEPT:
A.
B.
C.
D.
20.  The entity integrity rule states that:
A.
B.
C.
D.
21.  Which of the following are properties of relations
A.
B.
C.
D.
22.  A primary key that consists of more than one attribute is called a:
A.
B.
C.
D.
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.
24.  An attribute (or attributes) that uniquely identifies each row in a relation is called a:
A.
B.
C.
D.
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.
26.  A two-dimensional table of data is called a:
A.
B.
C.
D.
27.  The relational data model consists of which components?
A.
B.
C.
D.
28.  Physical database design decisions must be made carefully because of impacts on:
A.
B.
C.
D.
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.
30.  START CH5 - A method to allow adjacent secondary memory space to contain rows from several tables is called:
A.
B.
C.
D.
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.
32.  In which type of file is multiple key retrieval not possible
A.
B.
33.  A(n) _______________ is a routine that converts a primary key value into a relative record number.
A.
B.
C.
D.
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.
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.
36.  A(n) _______________ is a technique for physically arranging the records of a file on secondary storage devices
A.
B.
C.
D.
37.  A(n) __________ is a field of data used to locate a related field or record
A.
B.
C.
D.
38.  A contiguous section of disk storage space is called a(n):
A.
B.
C.
D.
39.  While Oracle has responsibility for managing data inside a tablespace, the tablespace as a while is managed by the:
A.
B.
C.
D.
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.
41.  Another form of demornalization where the same data are stored in multiple places in the database is called:
A.
B.
C.
D.
42.  All of the following are horizontal partitioning methods in Oracle EXCEPT:
A.
B.
C.
D.
43.  One disadvantage of partitioning is:
A.
B.
C.
D.
44.  One advantage of partitioning is:
A.
B.
C.
D.
45.  Horizontal partitioning makes sense:
A.
B.
C.
D.
46.  Distributing the rows of data into separate files is called:
A.
B.
C.
D.
47.  All of the following are common denormalization opportunities EXCEPT:
A.
B.
C.
D.
48.  Sensitivity testing involves:
A.
B.
C.
D.
49.  A method for handling missing data is to:
A.
B.
C.
D.
50.  In which data model would a code table appear
A.
B.
C.
D.
51.  Which of the following is an objective of selecting a data type?
A.
B.
C.
D.
52.  The smallest unit of application data recognized by system software is a:
A.
B.
C.
D.
53.  All of the following are valid datatypes in Oracle 11g EXCEPT
A.
B.
C.
D.
54.  A detailed coding scheme recognized by system software for representing organization data is called a(n):
A.
B.
C.
D.
55.  Database access frequencies are estimated from:
A.
B.
C.
D.
56.  The storage format for each attribute from the logical data model is chosen to maximize _________________ and minimize storage space
A.
B.
C.
D.
57.  Designing physical files requires __________ of where and when data are used in various ways
A.
B.
C.
58.  A key decision in the physical design process is:
A.
B.
C.
D.
59.  END CH5 - A requirement to begin designing physical files and databases is:
A.
B.
C.
D.
60.  START CH 7 - Constraints are a special case of triggers
A.
B.
61.  Persistent stored modules are extensions defined in SQL:1999 that include the capability to add and drop modules of code
A.
B.
62.  SQL:200n allows one to calculate linear regressions, moving averages and correlations without moving the data outside of the database
A.
B.
63.  DBA_USERS contains comments on all tables in an Oracle databse
A.
B.
64.  RDBMS's store database definition information in system-created tables which can be considered a data dictionary
A.
B.
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.
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.
67.  Combining a table with iself results in a faster query
A.
B.
68.  Correlated subqueries are less efficient than queries that do not use nesting
A.
B.
69.  IF-THEN-ELSE logical processing cannot be accomplished within an SQL statement
A.
B.
70.  The UNION clause is used to combine the output from multiple queries into a single result table
A.
B.
71.  A correlated subquery is executed once for each iteration through the outer loop
A.
B.
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.
73.  EXISTS takes a value of false if the subquery returns an intermediate result set
A.
B.
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.
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.
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.
77.  Joining tables or using a subquery may produce the same result
A.
B.
78.  There is a special operation in SQL to join a table to itself
A.
B.
79.  One major disadvantage of the outer join is that information is easily lost
A.
B.
80.  An SQL query that implements an outer join will return rows that do not have matching values in common columns
A.
B.
81.  The natural join is very rarely used
A.
B.
82.  The joining condition of an equi-join based upon an equality
A.
B.
83.  An equi-join is a join in which one of the duplicate columns is eliminated in the result table
A.
B.
84.  Dynamic SQL:
A.
B.
C.
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.
86.  Embedded SQL consists of:
A.
B.
C.
D.
87.  A procedure is:
A.
B.
C.
D.
88.  All of the following are advantages of SQL-invoked routiens EXCEPT:
A.
B.
C.
D.
89.  SQL-invoked routines can be:
A.
B.
C.
D.
90.  While triggers run automatically, ________________ do not and have to be called
A.
B.
C.
D.
91.  All of the following are part of the coding structure for triggers EXCEPT:
A.
B.
C.
D.
92.  A named set of SQL statements that are considered when a data modification occurs are called
A.
B.
C.
D.
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.
94.  The MERGE command:
A.
B.
C.
D.
95.  _________ differs from array because it can contain duplicates
A.
B.
C.
D.
96.  Which of the following is not a new data type that were added in SQL:200n
A.
B.
C.
D.
97.  RANK  and DENSE-RANK are examples of:
A.
B.
C.
D.
98.  A new set of analytical functions added in SQL:200n are referred to as:
A.
B.
C.
D.
99.  User-defined data types:
A.
B.
C.
D.
100.  What results would the following SQL statement produce? SQL> select owner, table_name from dba_tables where table_name = 'CUSTOMERS';
A.
B.
C.
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.
102.  User-defined transactions can improve system performance because:
A.
B.
C.
D.
103.  Explicit commands to manage transactions are needed when:
A.
B.
C.
D.