DBMS Final Exam Questions With Correct
Answers
A |is |a |column |or |set |of |columns |that |uniquely |identifies |each |row |in |a |table. |- |CORRECT |
ANSWER✔✔-primary |key
A |is |additional |documentation |that |is |often |used |to |further |explain |keys |and |columns |in |the |
physical |database. |- |CORRECT |ANSWER✔✔-table |diagram
represents |an |association |between |two |or |more |entities. |- |CORRECT |ANSWER✔✔-
relationships
Advantages |of |Relational(Multiple-Table) |Databases |are |all |the |following |except:
Less |redundancy
Data |integrity
Normally |a |single |file
Avoidance |of |inconsistency |- |CORRECT |ANSWER✔✔-Normally |a |single |file
The |of |the |table |diagram |contains |the |tables |name |and |the |short |name. |- |CORRECT |
ANSWER✔✔-first |row
Words |that |have |a |special |meaning |in |the |Oracle |database |and |in |the |SQL |programming |
language |are |called |. |- |CORRECT |ANSWER✔✔-reserved |words
,What |is |the |one |value |found |at |the |intersection |of |a |row |and |a |column? |- |CORRECT |
ANSWER✔✔-field
The |is |derived |from |business |specifications, |and |its |intended |goal |is |to |create |a |clear |picture |of
|the |information |that |will |be |stored |in |a |future |database. |- |CORRECT |ANSWER✔✔-entity |
relationship |model
A |is |a |simple |structure |where |data |is |organized |and |stored. |- |CORRECT |ANSWER✔✔-table
The |is |the |unique |identifier |for |each |row. |- |CORRECT |ANSWER✔✔-primary |key
A |conceptual |model |is |important |to |a |business |because |of |all |the |following |except:
Forms |a |sound |basis |for |physical |database |design.
Describes |the |exact |information |needs |of |the |business.
Ignores |regulations |and |laws |of |governing |industry.
Facilitates |discussion. |- |CORRECT |ANSWER✔✔-Ignores |regulations |and |laws |of |governing |
industry
A |is |an |attribute |that |describes |the |information |in |the |table. |- |CORRECT |ANSWER✔✔-column
A |UID |is |a |combination |of |attributes. |- |CORRECT |ANSWER✔✔-composite
A |is |additional |documentation |that |is |often |used |to |further |explain |keys |and |columns |in |the |
physical |database. |- |CORRECT |ANSWER✔✔-table |diagram
What |is |the |one |value |found |at |the |intersection |of |a |row |and |a |column? |- |CORRECT |
ANSWER✔✔-field
, A |is |a |column |or |combination |of |columns |in |one |table |that |refers |to |a |primary |key |in |the |same
|table |or |another |table. |- |CORRECT |ANSWER✔✔-foreign |key
A |is |a |column |that |refers |to |a |primary |key |column |in |another |table. |- |CORRECT |ANSWER✔✔-
foreign |key
The |relational |model |has |provided |the |basis |for |numerous |database |design |methodologies.
True
False |- |CORRECT |ANSWER✔✔-True
A |is |a |subset |of |the |Cartesian |product |of |a |list |of |domains |characterized |by |a |name; |the |
technical |term |for |table |or |file. |- |CORRECT |ANSWER✔✔-relation
A |is |a |technical |term |for |row |or |record. |- |CORRECT |ANSWER✔✔-tuple
In |the |properties |of |a |table |the |sequence |of |rows |is |significant.
True
False |- |CORRECT |ANSWER✔✔-False
The |relational |data |model |was |introduced |by |in |1970. |- |CORRECT |ANSWER✔✔-C.F. |Codd
The |standard |database |access |language |is:
English
Answers
A |is |a |column |or |set |of |columns |that |uniquely |identifies |each |row |in |a |table. |- |CORRECT |
ANSWER✔✔-primary |key
A |is |additional |documentation |that |is |often |used |to |further |explain |keys |and |columns |in |the |
physical |database. |- |CORRECT |ANSWER✔✔-table |diagram
represents |an |association |between |two |or |more |entities. |- |CORRECT |ANSWER✔✔-
relationships
Advantages |of |Relational(Multiple-Table) |Databases |are |all |the |following |except:
Less |redundancy
Data |integrity
Normally |a |single |file
Avoidance |of |inconsistency |- |CORRECT |ANSWER✔✔-Normally |a |single |file
The |of |the |table |diagram |contains |the |tables |name |and |the |short |name. |- |CORRECT |
ANSWER✔✔-first |row
Words |that |have |a |special |meaning |in |the |Oracle |database |and |in |the |SQL |programming |
language |are |called |. |- |CORRECT |ANSWER✔✔-reserved |words
,What |is |the |one |value |found |at |the |intersection |of |a |row |and |a |column? |- |CORRECT |
ANSWER✔✔-field
The |is |derived |from |business |specifications, |and |its |intended |goal |is |to |create |a |clear |picture |of
|the |information |that |will |be |stored |in |a |future |database. |- |CORRECT |ANSWER✔✔-entity |
relationship |model
A |is |a |simple |structure |where |data |is |organized |and |stored. |- |CORRECT |ANSWER✔✔-table
The |is |the |unique |identifier |for |each |row. |- |CORRECT |ANSWER✔✔-primary |key
A |conceptual |model |is |important |to |a |business |because |of |all |the |following |except:
Forms |a |sound |basis |for |physical |database |design.
Describes |the |exact |information |needs |of |the |business.
Ignores |regulations |and |laws |of |governing |industry.
Facilitates |discussion. |- |CORRECT |ANSWER✔✔-Ignores |regulations |and |laws |of |governing |
industry
A |is |an |attribute |that |describes |the |information |in |the |table. |- |CORRECT |ANSWER✔✔-column
A |UID |is |a |combination |of |attributes. |- |CORRECT |ANSWER✔✔-composite
A |is |additional |documentation |that |is |often |used |to |further |explain |keys |and |columns |in |the |
physical |database. |- |CORRECT |ANSWER✔✔-table |diagram
What |is |the |one |value |found |at |the |intersection |of |a |row |and |a |column? |- |CORRECT |
ANSWER✔✔-field
, A |is |a |column |or |combination |of |columns |in |one |table |that |refers |to |a |primary |key |in |the |same
|table |or |another |table. |- |CORRECT |ANSWER✔✔-foreign |key
A |is |a |column |that |refers |to |a |primary |key |column |in |another |table. |- |CORRECT |ANSWER✔✔-
foreign |key
The |relational |model |has |provided |the |basis |for |numerous |database |design |methodologies.
True
False |- |CORRECT |ANSWER✔✔-True
A |is |a |subset |of |the |Cartesian |product |of |a |list |of |domains |characterized |by |a |name; |the |
technical |term |for |table |or |file. |- |CORRECT |ANSWER✔✔-relation
A |is |a |technical |term |for |row |or |record. |- |CORRECT |ANSWER✔✔-tuple
In |the |properties |of |a |table |the |sequence |of |rows |is |significant.
True
False |- |CORRECT |ANSWER✔✔-False
The |relational |data |model |was |introduced |by |in |1970. |- |CORRECT |ANSWER✔✔-C.F. |Codd
The |standard |database |access |language |is:
English
