NAME

Question types


Start with


Question limit

of 68 available terms

Print test

68 True/False questions

  1. A non-normalized database is often more complex and therefore more ___ → uniquely identifies each row of data.

          

  2. The first normalized form (1NF) means the data is in an entity format, which basically means that the following three conditions must be met: → each attribute does in fact describe the entity.

          

  3. SQL Server will require all associated values with the constraint in the foreign key table to have ___ → with a non-clustered index

          

  4. The third normal form is resolved by ___ → moving the nondependent attribute to a new entity.

          

  5. A composite primary key occurs when ___ → you define more than one column as your primary key.

          

  6. Every table must have a ___ → mechanisms that are used to prevent simultaneous changes to the database

          

  7. We have a table of widget orders that contains the following attributes:
    • Order Number (primary key)
    • Customer Number
    • Unit Price
    • Quantity
    • Total

    What about the total? The total can be derived by multiplying the unit price by the quantity, and therefore it's ___     → not fully dependent on the primary key.

          

  8. A foreign key then creates a relationship between two tables by linking the ___ → attribute1 is dependent on attribute2, which is then dependent on the primary key.

          

  9. A table with a clustered index is considered a ___ → to a primary key (...)

          

  10. Although it may take longer to design a normalized database, such databases are easier to work with and reduce ___ → development costs.

          

  11. Candidate keys: → an attribute or set of attributes that can be used to uniquely identify each row.

          

  12. Candidate keys that are not selected as the primary key are then known as ___ → alternate keys.

          

  13. If an attribute depends on one of the primary key attributes but not the others, then it becomes a partial dependency, which violates the ___ → second normal form.

          

  14. There are two ways to create a non-clustered index on a table. One uses ___ , and the other uses the visual interface of SQL Server Management Studio. → SQL Server Management Studio.

          

  15. A unique key constraint will allow you to ___ → enforce the uniqueness property of columns, in addition to a primary key within a table.

          

  16. primary key: → mechanisms that are used to prevent simultaneous changes to the database

          

  17. When a table has no clustered index, the data rows are then stored in an unordered structure called a ___ → SSMS »» Databases folder »» Tables folder »» Indexes subfolder »» New index »» New Index properties box »» This is where you would select whether the index you are creating is to be clustered or non-clustered.

          

  18. The third normal form (3NF) checks for ___ → transitive dependencies.

          

  19. Third normalization form (3NF): → Eliminate repeating groups

          

  20. A primary key is a set of columns in a table that ___ → the composite primary key plays an important role.

          

  21. Three different types of constraints available within SQL Server ensure that you are able to maintain database integrity: → SSMS »» . Right-click the table and select Design view »» Table Designer »» Select Relationships »» Select the table to which you wish to add the foreign key constraint »» Tables and Columns Specification »» Click the ellipsis (. . .) »» Select the table that your foreign key refers to in the primary key table »» OK »» Close »» Save All

          

  22. Create a non-clustered index using Sql Server Management Studio → SSMS »» Databases folder »» Tables folder »» Indexes subfolder »» New index »» New Index properties box »» This is where you would select whether the index you are creating is to be clustered or non-clustered.

          

  23. An index is an on-disk (or stored) structure associated entirely with a table or a view that ___ → attribute1 is dependent on attribute2, which is then dependent on the primary key.

          

  24. Normalization, by definition, is ___ → Eliminate columns not dependent on key

          

  25. In order to connect two tables, the primary key is replicated from the primary to the secondary table, and all the key attributes duplicated from the primary table become known as the ___ → second normal form.

          

  26. First normalization form (1NF): → Isolate semantically related multiple relationships

          

  27. A unique constraint acts similarly to a primary key but with two important differences: → • Columns containing a unique key constraint may contain only one row with a NULL value.
    • A table may have multiple unique constraints.

          

  28. When two tables relate to each other, one of them will act as the primary table and the other will act as the ___ → clustered table

          

  29. A unique constraint acts similarly ___ → enforce the uniqueness property of columns, in addition to a primary key within a table.

          

  30. Imagine that you take the tables in a database and categorize them based on two data types: → the composite primary key plays an important role.

          

  31. One important feature of SQL Server is its automatic creation of a clustered index when the ___ → two

          

  32. The fourth normal form (4NF) involves two independent attributes brought together to form a primary key along with a third attribute. But, if the two attributes don't really uniquely identify the entity without the third attribute, then the design violates ___ . → the fourth normal form

          

  33. A dependency is considered transient when ___ → an attribute depends on only part of the key.

          

  34. Once you have defined a primary key for the table, ___ → you have met the first normalized form criterion.

          

  35. Fourth normalization form (4NF): → Isolate independent multiple relationships

          

  36. By definition, a primary key must be ___ → unique and must have a value that is not null.

          

  37. Multiple values in the foreign key table can reference the ___ → same record in the primary key table.

          

  38. These keys are then stored in a structure called a ___ that enables SQL Server to find the row(s) associated with those defined values much more quickly and efficiently. → B-tree

          

  39. Fifth normalization form (5NF): → Isolate independent multiple relationships

          

  40. Normalization reduces ___ → the elimination of redundant data to save space.

          

  41. We must remove the TOTAL from the table to comply with the third normal form.
    We could replace our original attributes with the following attributes:
    • Order Number
    • Customer Number
    • Unit Price
    • Quantity

    Now our table is in 3NF. But, you might ask, what about the TOTAL?     → • The database must already meet the requirements of both 1NF and 2NF.
    • The database must not contain any columns that aren't fully dependent upon the primary key.

          

  42. Each table can have only ___ clustered index that defines how SQL Server will sort the data stored inside the table. → one

          

  43. Create a foreign key constraint using the SSMS interface: → SSMS »» . Right-click the table and select Design view »» Table Designer »» Select Relationships »» Select the table to which you wish to add the foreign key constraint »» Tables and Columns Specification »» Click the ellipsis (. . .) »» Select the table that your foreign key refers to in the primary key table »» OK »» Close »» Save All

          

  44. System allows you to assign multiple products to multiple customers. This is a ___ → the composite primary key plays an important role.

          

  45. The second normal form (2NF) ensures that ___ → an attribute depends on only part of the key.

          

  46. A clustered index is a ___ construct, unlike most indexes, which are logical or software-based. → physical

          

  47. The base camp data (...) violates the first normal form: the repeating tour attribute (Tour 1, Tour 2, and Tour 3) is not unique ( there are three values assigned for Tours). To redesign the data model so that it complies with the first normal form, you must ___ → "provide a fact about the key, the whole key, and nothing but the key."

          

  48. On a table ___ , you can add multiple table columns to the index key. → you have met the first normalized form criterion.

          

  49. Normalization, in a nutshell, is ___ → the process of organizing data in order to reduce redundancy by dividing a database into two or more tables and then defining table relationships.

          

  50. A clustered index is a physical construct, unlike most indexes, which are ___ → logical or software-based.

          

  51. The second normal form is violated when ___ → attribute depends on the key but also on another nonkey attribute.

          

  52. You cannot have two rows containing a ___ → the process of organizing data in order to reduce redundancy by dividing a database into two or more tables and then defining table relationships.

          

  53. If the two attributes don't really uniquely identify the entity without the third attribute, then ___ → the composite primary key plays an important role.

          

  54. You can only have one clustered index per table. Why? → NULL value in the same option, as that would violate the unique constraint's duplicate value error.

          

  55. 2NF is entirely based on dependency: specifically, the attributes of the entity in question, which is not part of a candidate key, must be ___ → functionally dependent upon the entire primary key.

          

  56. Normalization has these three advantages: → • Development costs
    • Usability
    • Extensibility

          

  57. It is in the tables that relate entities that ___ → NULL value in the same option, as that would violate the unique constraint's duplicate value error.

          

  58. The third normal form is violated when the ___ → moving the nondependent attribute to a new entity.

          

  59. Central phrase to remember in describing the third normal form is that every attribute must ___ → resolve the repeating group of tour attributes into a single unique attribute and then move any multiple values to a unique table.

          

  60. Without locks, a change made by one transaction could be ___ → overwritten by another transaction that executes at the same time.

          

  61. There are two ways to create a non-clustered index on a table. One uses Transact-SQL script statements, and the other uses the visual interface of ___ → SQL Server Management Studio.

          

  62. There are two basic requirements for a database to be in third normal form: → • The database must already meet the requirements of both 1NF and 2NF.
    • The database must not contain any columns that aren't fully dependent upon the primary key.

          

  63. Create a unique constraint: → All the potential primary keys.

          

  64. Data can only be sorted in one way, it simply is not possible to have ___ clustered indexes on the same table. → uniquely identifies each row of data.

          

  65. A ___ is similar to a partial dependency in that both refer to attributes that are not fully dependent on a primary key. → the composite primary key plays an important role.

          

  66. Second normalization form (2NF): → Eliminate redundant data

          

  67. Placing columns in the correct table makes it easier to ___ → understand a database and write correct queries.

          

  68. Locks are ___ → mechanisms that are used to prevent simultaneous changes to the database