Database Chapters 4,5,7 Midterm 2 Quiz

120 Questions  I  By Golf_pro90
Please take the quiz to rate it.

Database Quizzes & Trivia
Practice for midterm 2

  
Changes are done, please start the quiz.


Questions and Answers

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. 

      Column

    • B. 

      Unimportant datum

    • C. 

      Descriptor

    • D. 

      Address


  • 2. 
    A primary key whose value is unique across all relations is called a(n):
    • A. 

      Global primary key

    • B. 

      Inter-table primary key

    • C. 

      Enterprise key

    • D. 

      Foreign global key


  • 3. 
    An attribute that may have more than one meaning is called a(n):
    • A. 

      Homonym

    • B. 

      Alias

    • C. 

      Double defined attribute

    • D. 

      synonym


  • 4. 
    Two or more attributes having different names but the same meaning are called:
    • A. 

      Homonyms

    • B. 

      Aliases

    • C. 

      Synonyms

    • D. 

      Alternate attributes


  • 5. 
    An understanding of how to merge relation is important because:
    • A. 

      A) there may be a need to merge relations on projects with subteams

    • B. 

      Different views may be integrated

    • C. 

      New data requirements may produce new relations to be merged

    • D. 

      All of the above


  • 6. 
    Which of the following anomalies result from a transitive dependency?
    • A. 

      Insertion

    • B. 

      Modification

    • C. 

      Deletion

    • D. 

      All of the above


  • 7. 
    When the value of one attribute (the determinant) determines the value of another attribute, it is called:
    • A. 

      Functional dependency

    • B. 

      Merged relation

    • C. 

      Transitive dependency

    • D. 

      Full dependency


  • 8. 
    A candidate key must satisfy all of the following conditions EXCEPT:
    • A. 

      The key must uniquely identify the row

    • B. 

      The key must indicate the rows position in the table

    • C. 

      The key must be nonredundant

    • D. 

      Each nonkey attribute is functionally dependent upon it


  • 9. 
    A constraint between two attributes is called a(n):
    • A. 

      Functional relation

    • B. 

      Attribute dependency

    • C. 

      Functional dependency

    • D. 

      Functional relation constraint


  • 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. 

      First

    • B. 

      Second

    • C. 

      Third

    • D. 

      Fourth


  • 11. 
    When all multivalued attributes have been removed from a relation , it is said to be in:
    • A. 

      First normal form

    • B. 

      Second normal form

    • C. 

      Boyce-Codd normal form

    • D. 

      Third normal form


  • 12. 
    All of the following are the main goals of normalization EXCEPT:
    • A. 

      Minimize data redundancy

    • B. 

      Simplify the enforcement of referential integrity

    • C. 

      Maximize storage space

    • D. 

      Make it easier to maintain data


  • 13. 
    If foreign key is referenced to the primary key in the same relation, we call it:
    • A. 

      Primary

    • B. 

      Recursive primary

    • C. 

      Composite

    • D. 

      Recursive foreign


  • 14. 
    When a regular entity type contains a multivalued attribute, one must:
    • A. 

      Create a single relation with multiple lines for each instance of the multivalued attribute

    • B. 

      Create two new relations, one containing the multivalued attribute

    • C. 

      Create two new relations, both containing the multivalued attribute

    • D. 

      None of the above


  • 15. 
    A relation that contains minimal redundancy and allows easy use is considered to be:
    • A. 

      Clean

    • B. 

      simple

    • C. 

      Complex

    • D. 

      Well structured


  • 16. 
    Which of the following are anomalies that can be caused by redundancies in tables
    • A. 

      Insertion

    • B. 

      Deletion

    • C. 

      Modification

    • D. 

      All of the above


  • 17. 
    The __________ states that no primary key attribute may be null
    • A. 

      Referential integrity constraint

    • B. 

      Entity integrity rule

    • C. 

      Partial specialization rule

    • D. 

      Range domain rule


  • 18. 
    A rule that states that each foreign key value must match a primary key value in the other
    • A. 

      Referential integrity constraint

    • B. 

      Key match rule

    • C. 

      Entity key group rule

    • D. 

      Foreign/primary match rule


  • 19. 
    A domain definition consists of the following components EXCEPT:
    • A. 

      Domain name

    • B. 

      Data type

    • C. 

      Integrity constraint

    • D. 

      size


  • 20. 
    The entity integrity rule states that:
    • A. 

      No primary key attribute can be null

    • B. 

      Referential integrity must be maintained across all entities

    • C. 

      Each entity must have a primary key

    • D. 

      A primary key must have only one attribute


  • 21. 
    Which of the following are properties of relations
    • A. 

      Each attribute has a unique name

    • B. 

      No two rows in a relation are identical

    • C. 

      There are no multivalued attributes are in a relation

    • D. 

      All of the above


  • 22. 
    A primary key that consists of more than one attribute is called a:
    • A. 

      Foreign key

    • B. 

      Composite key

    • C. 

      Multivalued key

    • D. 

      Cardinal key


  • 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. 

      Link attribute

    • B. 

      Link key

    • C. 

      Foreign key

    • D. 

      Foreign attribute


  • 24. 
    An attribute (or attributes) that uniquely identifies each row in a relation is called a:
    • A. 

      Column

    • B. 

      Foreign field

    • C. 

      Primary key

    • D. 

      Duplicate key


  • 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. 

      Business rule constraint

    • B. 

      Data integrity

    • C. 

      Business integrity

    • D. 

      Data structure


  • 26. 
    A two-dimensional table of data is called a:
    • A. 

      group

    • B. 

      set

    • C. 

      declaration

    • D. 

      Relation


  • 27. 
    The relational data model consists of which components?
    • A. 

      Data structure

    • B. 

      Data manipulation

    • C. 

      Data integrity

    • D. 

      All of the above


  • 28. 
    Physical database design decisions must be made carefully because of impacts on:
    • A. 

      Data accessibility

    • B. 

      Response times

    • C. 

      Security

    • D. 

      All of the above


  • 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. 

      Logical

    • B. 

      Physical

    • C. 

      Schematic

    • D. 

      conceptual


  • 30. 
    START CH5 - A method to allow adjacent secondary memory space to contain rows from several tables is called:
    • A. 

      Cluttering

    • B. 

      Clustering

    • C. 

      Concatenating

    • D. 

      Compiling


  • 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. 

      Hashed file organization

    • B. 

      Hash key

    • C. 

      Multi-indexed file organization

    • D. 

      Hash index table


  • 32. 
    In which type of file is multiple key retrieval not possible
    • A. 

      Hashed

    • B. 

      Other options werent in PDF


  • 33. 
    A(n) _______________ is a routine that converts a primary key value into a relative record number.
    • A. 

      Record index calculator

    • B. 

      Index pointer program

    • C. 

      Hashing algorithm

    • D. 

      Pointing algorithm


  • 34. 
    An index of columns from two or more tables that come from the same domain of values is called a:
    • A. 

      Bitmap index

    • B. 

      Multivalued index

    • C. 

      Join index

    • D. 

      Transaction index


  • 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. 

      Secondary key

    • B. 

      Index

    • C. 

      Composite key

    • D. 

      Linked key


  • 36. 
    A(n) _______________ is a technique for physically arranging the records of a file on secondary storage devices
    • A. 

      Physical pointer

    • B. 

      Retrieval program

    • C. 

      File organization

    • D. 

      Update program


  • 37. 
    A(n) __________ is a field of data used to locate a related field or record
    • A. 

      Key

    • B. 

      Index

    • C. 

      Lock

    • D. 

      Pointer


  • 38. 
    A contiguous section of disk storage space is called a(n):
    • A. 

      Track

    • B. 

      Sector

    • C. 

      Extent

    • D. 

      Tablespace


  • 39. 
    While Oracle has responsibility for managing data inside a tablespace, the tablespace as a while is managed by the:
    • A. 

      User

    • B. 

      Database administrator

    • C. 

      Application developer

    • D. 

      Operating system


  • 40. 
    Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):
    • A. 

      Extent

    • B. 

      Table

    • C. 

      Tablespace

    • D. 

      Partition


  • 41. 
    Another form of demornalization where the same data are stored in multiple places in the database is called:
    • A. 

      Data duplication

    • B. 

      Data replication

    • C. 

      Advanced placement

    • D. 

      Horizaontal partitioning


  • 42. 
    All of the following are horizontal partitioning methods in Oracle EXCEPT:
    • A. 

      Key range partitioning

    • B. 

      Hash partitioning

    • C. 

      Multivalued partitioning

    • D. 

      Composite partitioning


  • 43. 
    One disadvantage of partitioning is:
    • A. 

      Simplicity

    • B. 

      Remote optimization

    • C. 

      Extra space and update time

    • D. 

      Shorter technology spans


  • 44. 
    One advantage of partitioning is:
    • A. 

      Efficiency

    • B. 

      Remote optimization

    • C. 

      Extra space and update time

    • D. 

      Both A and B


  • 45. 
    Horizontal partitioning makes sense:
    • A. 

      When different categories of a table's rows are processed seperately

    • B. 

      When less security is needed

    • C. 

      When partitions must be orgranized the same

    • D. 

      When all of the above are true


  • 46. 
    Distributing the rows of data into separate files is called:
    • A. 

      Normalization

    • B. 

      Horizontal partitioning

    • C. 

      Vertical partitioning

    • D. 

      File allocation


  • 47. 
    All of the following are common denormalization opportunities EXCEPT:
    • A. 

      Two entities with a one-to-one relationship

    • B. 

      A one-to-many relationship

    • C. 

      A many-to-many relationship with nonkey attributes

    • D. 

      Reference data


  • 48. 
    Sensitivity testing involves:
    • A. 

      Checking if data is allergic

    • B. 

      Seeing how accurate data are

    • C. 

      Checking to see if missing data will greatly impact results

    • D. 

      None of the above


  • 49. 
    A method for handling missing data is to:
    • A. 

      Substitute and estimate for the missing data

    • B. 

      Track missing data with special reports

    • C. 

      Perform sensitivity testing

    • D. 

      All of the above


  • 50. 
    In which data model would a code table appear
    • A. 

      Conceptual

    • B. 

      Logical

    • C. 

      Physical

    • D. 

      Data layout


  • 51. 
    Which of the following is an objective of selecting a data type?
    • A. 

      Represent a small number of possible values

    • B. 

      Maximize storage space

    • C. 

      Limit security

    • D. 

      Improve data integrity


  • 52. 
    The smallest unit of application data recognized by system software is a:
    • A. 

      Field

    • B. 

      Row

    • C. 

      Data type

    • D. 

      Column


  • 53. 
    All of the following are valid datatypes in Oracle 11g EXCEPT
    • A. 

      Varchar2

    • B. 

      Datetime

    • C. 

      Blob

    • D. 

      Number


  • 54. 
    A detailed coding scheme recognized by system software for representing organization data is called a(n):
    • A. 

      DBMS code

    • B. 

      Data type

    • C. 

      SQL

    • D. 

      DB layouts


  • 55. 
    Database access frequencies are estimated from:
    • A. 

      Transaction volumes

    • B. 

      User logins

    • C. 

      Security violations

    • D. 

      None of the above


  • 56. 
    The storage format for each attribute from the logical data model is chosen to maximize _________________ and minimize storage space
    • A. 

      Query design

    • B. 

      Programmer productivity

    • C. 

      Data integrity

    • D. 

      Data integration


  • 57. 
    Designing physical files requires __________ of where and when data are used in various ways
    • A. 

      Maps

    • B. 

      Descriptions

    • C. 

      Keys


  • 58. 
    A key decision in the physical design process is:
    • A. 

      Knowing the user base

    • B. 

      Selecting structures

    • C. 

      Deciding on the monitor

    • D. 

      All of the above


  • 59. 
    END CH5 - A requirement to begin designing physical files and databases is:
    • A. 

      Normalized relaions

    • B. 

      Definitions of each attribute

    • C. 

      Technology descriptions

    • D. 

      All of the above


  • 60. 
    START CH 7 - Constraints are a special case of triggers
    • A. 

      True

    • B. 

      False


  • 61. 
    Persistent stored modules are extensions defined in SQL:1999 that include the capability to add and drop modules of code
    • A. 

      True

    • B. 

      False


  • 62. 
    SQL:200n allows one to calculate linear regressions, moving averages and correlations without moving the data outside of the database
    • A. 

      True

    • B. 

      False


  • 63. 
    DBA_USERS contains comments on all tables in an Oracle databse
    • A. 

      True

    • B. 

      False


  • 64. 
    RDBMS's store database definition information in system-created tables which can be considered a data dictionary
    • A. 

      True

    • B. 

      False


  • 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. 

      True

    • B. 

      False


  • 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. 

      True

    • B. 

      False


  • 67. 
    Combining a table with iself results in a faster query
    • A. 

      True

    • B. 

      False


  • 68. 
    Correlated subqueries are less efficient than queries that do not use nesting
    • A. 

      True

    • B. 

      False


  • 69. 
    IF-THEN-ELSE logical processing cannot be accomplished within an SQL statement
    • A. 

      True

    • B. 

      False


  • 70. 
    The UNION clause is used to combine the output from multiple queries into a single result table
    • A. 

      True

    • B. 

      False


  • 71. 
    A correlated subquery is executed once for each iteration through the outer loop
    • A. 

      True

    • B. 

      False


  • 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. 

      True

    • B. 

      False


  • 73. 
    EXISTS takes a value of false if the subquery returns an intermediate result set
    • A. 

      True

    • B. 

      False


  • 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. 

      True

    • B. 

      False


  • 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. 

      True

    • B. 

      False


  • 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. 

      True

    • B. 

      False


  • 77. 
    Joining tables or using a subquery may produce the same result
    • A. 

      True

    • B. 

      False


  • 78. 
    There is a special operation in SQL to join a table to itself
    • A. 

      True

    • B. 

      False


  • 79. 
    One major disadvantage of the outer join is that information is easily lost
    • A. 

      True

    • B. 

      False


  • 80. 
    An SQL query that implements an outer join will return rows that do not have matching values in common columns
    • A. 

      True

    • B. 

      False


  • 81. 
    The natural join is very rarely used
    • A. 

      True

    • B. 

      False


  • 82. 
    The joining condition of an equi-join based upon an equality
    • A. 

      True

    • B. 

      False


  • 83. 
    An equi-join is a join in which one of the duplicate columns is eliminated in the result table
    • A. 

      True

    • B. 

      False


  • 84. 
    Dynamic SQL:
    • A. 

      Is used to generate appropriate SQL code on the fly, as an application is processing

    • B. 

      Is quite volatile

    • C. 

      Creates a less flexible application


  • 85. 
    In order to embed SQL inside of another language, the __________ statement must be placed before the SQL in the host language
    • A. 

      GET SQL

    • B. 

      EXEC SQL

    • C. 

      RUN SQL

    • D. 

      SQL SQL


  • 86. 
    Embedded SQL consists of:
    • A. 

      Hard coded SQL statements included in a program written in another language

    • B. 

      SQL encapsulated inside of other SQL statments

    • C. 

      SQL written into a front-end application

    • D. 

      SQL translated to a lower-level language


  • 87. 
    A procedure is:
    • A. 

      Stored within the databse

    • B. 

      Given a unique name

    • C. 

      Called by name

    • D. 

      All of the above


  • 88. 
    All of the following are advantages of SQL-invoked routiens EXCEPT:
    • A. 

      Flexibility

    • B. 

      Efficiency

    • C. 

      Sharability

    • D. 

      Security


  • 89. 
    SQL-invoked routines can be:
    • A. 

      Procedures

    • B. 

      Functions

    • C. 

      All of the above

    • D. 

      None of the above


  • 90. 
    While triggers run automatically, ________________ do not and have to be called
    • A. 

      Trapdoors

    • B. 

      Routines

    • C. 

      Selects

    • D. 

      Updates


  • 91. 
    All of the following are part of the coding structure for triggers EXCEPT:
    • A. 

      Event

    • B. 

      Condition

    • C. 

      Selection

    • D. 

      Action


  • 92. 
    A named set of SQL statements that are considered when a data modification occurs are called
    • A. 

      Stored procedures

    • B. 

      Treatments

    • C. 

      Triggers

    • D. 

      Trapdoors


  • 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. 

      Stored procedures

    • B. 

      Persistent stored modules

    • C. 

      Flow control modules

    • D. 

      None of the above


  • 94. 
    The MERGE command:
    • A. 

      Allows one to combine the INSERT and UPDATE operations

    • B. 

      Allows one to combine the INSERT and DELETE operations

    • C. 

      Joins 2 tables together

    • D. 

      None of the above


  • 95. 
    _________ differs from array because it can contain duplicates
    • A. 

      BIGINT

    • B. 

      XML

    • C. 

      MULTISET

    • D. 

      TABLE


  • 96. 
    Which of the following is not a new data type that were added in SQL:200n
    • A. 

      BIGINT

    • B. 

      BIT

    • C. 

      MULTISET

    • D. 

      XML


  • 97. 
    RANK  and DENSE-RANK are examples of:
    • A. 

      Ceilings

    • B. 

      Door functions

    • C. 

      Window functions

    • D. 

      Moving functions


  • 98. 
    A new set of analytical functions added in SQL:200n are referred to as:
    • A. 

      OLAF functions

    • B. 

      MOLAP functions

    • C. 

      Average functions

    • D. 

      OLAP Functions


  • 99. 
    User-defined data types:
    • A. 

      Can be a subclass of a standard type

    • B. 

      Can behave as an object

    • C. 

      Can have defined functions and methods

    • D. 

      All of the above


  • 100. 
    What results would the following SQL statement produce? SQL> select owner, table_name from dba_tables where table_name = 'CUSTOMERS';
    • A. 

      A listing of all customers in the customer table

    • B. 

      A listing of the owener of the customer table

    • C. 

      A listing of the owner of the customer table as well as customers


  • 101. 
    If the DBA wishes to describe all tables in the database, which data dictionary view should be accessed in Oracle?
    • A. 

      DBA_tab_privs

    • B. 

      DBA_tab_comments

    • C. 

      DBA_table_label

    • D. 

      DBA_tables


  • 102. 
    User-defined transactions can improve system performance because:
    • A. 

      Transactions are processed as sets, reducing system overhead

    • B. 

      Transactions are mapped to SQL statements

    • C. 

      Speed is improved due to query optimization

    • D. 

      All of the above


  • 103. 
    Explicit commands to manage transactions are needed when:
    • A. 

      A transaction consists of just one SQL command

    • B. 

      Multiple SQL commands must be run as part of a transaction

    • C. 

      Autocommit is set to off

    • D. 

      None of the above


  • 104. 
    All of the following are guidelines for better query design EXCEPT:
    • A. 

      Understand how indexes are used in query processing

    • B. 

      Use a lot of self-joins

    • C. 

      Write simple queries

    • D. 

      Retrieve on the data that you need


  • 105. 
    Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:
    • A. 

      Using the if-then-else construct

    • B. 

      Using the immediate if statement

    • C. 

      Using the CASE keyword in a statement

    • D. 

      Using a subquery


  • 106. 
    In order for two quieries to be UNION-compatible, they must:
    • A. 

      Both have the same number of lines in their SQL statements

    • B. 

      Both output compatible data types for each column and return the same number of rows

    • C. 

      Both return at least one row

    • D. 

      All of the above


  • 107. 
    The UNION clause is used to:
    • A. 

      Combine the output from multiple queries into a single result table

    • B. 

      Join two tables together to form one table

    • C. 

      Find all rows that do not match in two tables

    • D. 

      None of the above


  • 108. 
    A _________ is a temporary table used in the FROM clause of an SQL query
    • A. 

      Correlated subquery

    • B. 

      Derived table

    • C. 

      View table

    • D. 

      None of the above


  • 109. 
    ___________ takes a value of true if a subquery returns an intermediate results table which contains one or more rows
    • A. 

      IN

    • B. 

      HAVING

    • C. 

      EXISTS

    • D. 

      EXTENTS


  • 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. 

      Correlated

    • B. 

      Paired

    • C. 

      Natural

    • D. 

      Inner


  • 111. 
    A type of query that is palced within a WHERE or HAVING clause of another query is called a:
    • A. 

      Master query

    • B. 

      Subquery

    • C. 

      Superquery

    • D. 

      Multi-query


  • 112. 
    A type of join where a table is joined to itself is called a(n)
    • A. 

      Unary join

    • B. 

      Self join

    • C. 

      Unnatural join

    • D. 

      Pinned join


  • 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. 

      Outer join

    • B. 

      Inner join

    • C. 

      Union join

    • D. 

      Intersect join


  • 114. 
    One major advantage of the outer join is that:
    • A. 

      Information is easily accessible

    • B. 

      Information is not lost

    • C. 

      The query is easier to write

    • D. 

      All of the above


  • 115. 
    In which of the following situations would one have to use an outer join in order to obtain the desired results?
    • A. 

      A report is desired that lists all customers who placed an order

    • B. 

      A report is desired that lists all customers and the total of their orders

    • C. 

      A report is desired that lists all customers, the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero)

    • D. 

      There is never a situation that requires only an outer join


  • 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. 

      Natural join

    • B. 

      Equi-join

    • C. 

      Outer join

    • D. 

      Union join


  • 117. 
    The most commonly used form of join operation is the:
    • A. 

      Outer join

    • B. 

      Union join

    • C. 

      Equi-join

    • D. 

      Natural join


  • 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. 

      Equi-join

    • B. 

      Natural join

    • C. 

      Multivariate join

    • D. 

      Inner join


  • 119. 
    A join in which the joining condition is based on equality between values in the common columns is called a(n):
    • A. 

      Equi-join

    • B. 

      Uni-lateral join

    • C. 

      Natural join

    • D. 

      A and C


  • 120. 
    A join operation:
    • A. 

      Brings together data from two different fields

    • B. 

      Causes two tables with a common domain to be combined into a single table or view

    • C. 

      Causes two disparate tables to be combined into a single table or view

    • D. 

      Is used to combine indexing operations


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.