Oracle Database Quiz Section 9 Quiz Answer
 |
| Image Source : dqindia.com |
1. When translating an arc
relationship to a physical design, you must turn the arc relationships into
foreign keys. What additional step must you take with the created foreign keys
to ensure the exclusivity principle of arc relationships? (Assume that you are
implementing an Exclusive Design)
Make all relationships mandatory
Make all relationships optional (*)
Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
All the above
Make all relationships mandatory
Make all relationships optional (*)
Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
All the above
2. Which of the following
is a valid reason for considering a Subtype Implementation?
The common access paths for the supertypes are different.
The resulting table will reside in a single database and be used by just ONE user.
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
Most of the relationships are at the supertype level.
The common access paths for the supertypes are different.
The resulting table will reside in a single database and be used by just ONE user.
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
Most of the relationships are at the supertype level.
3. When mapping supertypes,
relationships at the supertype level transform as usual. Relationships at
subtype level are implemented as foreign keys, but the foreign key columns all
become mandatory.
True
False (*)
True
False (*)
4. In an Oracle database,
why would 1_TABLE not work as a table name?
The database does not understand all capital letters.
TABLE is a reserved word.
There is no problem here. You can create a table called 1_TABLE.
Object names must not start with a number. They must begin with a letter. (*)
The database does not understand all capital letters.
TABLE is a reserved word.
There is no problem here. You can create a table called 1_TABLE.
Object names must not start with a number. They must begin with a letter. (*)
5. In an Oracle database,
why would the following table name not be allowed 'EMPLOYEE JOBS'?
The database does not understand all capital letters
JOBS is a reserved word
EMPLOYEE is a reserved word
You cannot have spaces between words in a table name (*)
The database does not understand all capital letters
JOBS is a reserved word
EMPLOYEE is a reserved word
You cannot have spaces between words in a table name (*)
6. Why would this table
name NOT work in an Oracle database? this_year_end+next_year
Table names must begin with an alphabetic character.
It is too long.
The Plus sign + is not allowed in object names. (*)
None of the above.
Table names must begin with an alphabetic character.
It is too long.
The Plus sign + is not allowed in object names. (*)
None of the above.
7. In a physical data
model, an attribute becomes a _____________.
Constraint
Table
Foreign Key
Column (*)
Constraint
Table
Foreign Key
Column (*)
8. To resolve a many to
many relationship in a physical model you create a(n) ___________________?
Unique key constraints
Intersection entity
Intersection table (*)
Two tables with Foreign key constraints between them
Unique key constraints
Intersection entity
Intersection table (*)
Two tables with Foreign key constraints between them
9. When an Arc is
transformed to the physical model every relationship in the Arc becomes a
mandatory Foreign Key. True or False?
True
False (*)
True
False (*)
10. The Oracle Database can
implement a many to many relationship. You simply create two foreign keys between
the two tables. True or False?
True
False (*)
True
False (*)
11. A barrred Relationship
will result in a Foreign Key column that also is part of:
The Primary Key (*)
The Column Name
The Check Constraint
The Table Name
The Primary Key (*)
The Column Name
The Check Constraint
The Table Name
12. Column integrity refers
to
Columns always containing positive numbers
Columns always containing values consistent with the defined data format (*)
Columns always containing text data less than 255 characters
Columns always having values
Columns always containing positive numbers
Columns always containing values consistent with the defined data format (*)
Columns always containing text data less than 255 characters
Columns always having values
13. The explanation below is
an example of which constraint type?
A column must contain only values consistent with the defined data format of the column
Column integrity (*)
User-defined integrity
Referential integrity
Entity integrity
A column must contain only values consistent with the defined data format of the column
Column integrity (*)
User-defined integrity
Referential integrity
Entity integrity
14. Identify all of the
incorrect statements that complete this sentence: A primary key is...
Only one column that must be null. (*)
A single column that uniquely identifies each column in a table. (*)
One or more columns in a table that uniquely identifies each row in that table.
A set of columns in one table that uniquely identifies each row in another table. (*)
Only one column that must be null. (*)
A single column that uniquely identifies each column in a table. (*)
One or more columns in a table that uniquely identifies each row in that table.
A set of columns in one table that uniquely identifies each row in another table. (*)
15. Identify all of the
correct statements that complete this sentence: A primary key is:
Only one column that cannot be null
A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
A single column that uniquely identifies each row in a table (*)
A set of columns that uniquely identifies each row in a table (*)
Only one column that cannot be null
A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
A single column that uniquely identifies each row in a table (*)
A set of columns that uniquely identifies each row in a table (*)
1. The explanation below is
an example of which constraint type?
A column must contain only values consistent with the defined data format of the column
User-defined integrity
Column integrity (*)
Referential integrity
Entity integrity
A column must contain only values consistent with the defined data format of the column
User-defined integrity
Column integrity (*)
Referential integrity
Entity integrity
2. Identify all of the
correct statements that complete this sentence: A primary key is:
A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
Only one column that cannot be null
A single column that uniquely identifies each row in a table (*)
A set of columns that uniquely identifies each row in a table (*)
A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
Only one column that cannot be null
A single column that uniquely identifies each row in a table (*)
A set of columns that uniquely identifies each row in a table (*)
3. Identify all of the
incorrect statements that complete this sentence: A primary key is...
A single column that uniquely identifies each column in a table. (*)
One or more columns in a table that uniquely identifies each row in that table.
Only one column that must be null. (*)
A set of columns in one table that uniquely identifies each row in another table. (*)
A single column that uniquely identifies each column in a table. (*)
One or more columns in a table that uniquely identifies each row in that table.
Only one column that must be null. (*)
A set of columns in one table that uniquely identifies each row in another table. (*)
4. Foreign keys cannot be
null when
It refers to another table
It is part of a primary key (*)
It contains three or more columns
It refers to the same table
It refers to another table
It is part of a primary key (*)
It contains three or more columns
It refers to the same table
5. When mapping supertypes,
relationships at the supertype level transform as usual. Relationships at
subtype level are implemented as foreign keys, but the foreign key columns all
become mandatory. True or False?
True
False (*)
True
False (*)
6. When mapping supertypes,
relationships at the supertype level transform as usual. Relationships at the
subtype level are implemented as foreign keys, but the foreign key columns all
become optional. True or False?
True (*)
False
True (*)
False
7. The "Arc Implementation"
is a synonym for what type of implementation?
Supertype and Subtype Implementation (*)
Cascade Implementation
Supertype Implementation
Subtype Implementation
Supertype and Subtype Implementation (*)
Cascade Implementation
Supertype Implementation
Subtype Implementation
8. The Physical model is
created by transforming which of the following models?
Constraint
Table
Physical
Conceptual (*)
Constraint
Table
Physical
Conceptual (*)
9. Why would this table
name NOT work in an Oracle database? this_year_end+next_year
Table names must begin with an alphabetic character.
It is too long.
The Plus sign + is not allowed in object names. (*)
None of the above.
Table names must begin with an alphabetic character.
It is too long.
The Plus sign + is not allowed in object names. (*)
None of the above.
10. In an Oracle database,
why would 1_TABLE not work as a table name?
There is no problem here. You can create a table called 1_TABLE.
The database does not understand all capital letters.
TABLE is a reserved word.
Object names must not start with a number. They must begin with a letter. (*)
There is no problem here. You can create a table called 1_TABLE.
The database does not understand all capital letters.
TABLE is a reserved word.
Object names must not start with a number. They must begin with a letter. (*)
11. Attributes become
columns in a database table. True or False?
True (*)
False
True (*)
False
12. Relationships on an ERD
can only be transformed into UIDs in the physical model? True or False?
True
False (*)
True
False (*)
13. An Arc is transformed to
the physical model by adding a foeign Key for every relationship in the Arc.
True or False?
True (*)
False
True (*)
False
14. One-to-One relationships
are transformed into Check Constraints in the tables created at either end of
that relationship. True or False?
True
False (*)
True
False (*)
15. One-to-One relationships
are transformed into Foreign Keys in the tables created at either end of that
relationship. True or False?
True
False (*)
True
False (*)
1. When mapping supertypes,
relationships at the supertype level transform as usual. Relationships at
subtype level are implemented as foreign keys, but the foreign key columns all
become mandatory. True or False?
True
False (*)
True
False (*)
2. Which of the following
is a valid reason for considering a Subtype Implementation?
The common access paths for the supertypes are different.
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
Most of the relationships are at the supertype level.
The resulting table will reside in a single database and be used by just ONE user.
The common access paths for the supertypes are different.
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
Most of the relationships are at the supertype level.
The resulting table will reside in a single database and be used by just ONE user.
3. The "Arc
Implementation" is a synonym for what type of implementation?
Supertype and Subtype Implementation (*)
Supertype Implementation
Cascade Implementation
Subtype Implementation
Supertype and Subtype Implementation (*)
Supertype Implementation
Cascade Implementation
Subtype Implementation
4. In a physical data
model, an attribute becomes a _____________.
Constraint
Column (*)
Table
Foreign Key
Constraint
Column (*)
Table
Foreign Key
5. The conceptual model is
transformed into a physical model. The physical implementation will be a
relational database. True or False?
True (*)
False
True (*)
False
6. In an Oracle database,
why would the following table name not be allowed 'EMPLOYEE JOBS'?
The database does not understand all capital letters
JOBS is a reserved word
You cannot have spaces between words in a table name (*)
EMPLOYEE is a reserved word
The database does not understand all capital letters
JOBS is a reserved word
You cannot have spaces between words in a table name (*)
EMPLOYEE is a reserved word
7. In an Oracle database,
why would 1_TABLE not work as a table name?
There is no problem here. You can create a table called 1_TABLE.
Object names must not start with a number. They must begin with a letter. (*)
The database does not understand all capital letters.
TABLE is a reserved word.
There is no problem here. You can create a table called 1_TABLE.
Object names must not start with a number. They must begin with a letter. (*)
The database does not understand all capital letters.
TABLE is a reserved word.
8. When an Arc is
transformed to the physical model every relationship in the Arc becomes a
mandatory Foreign Key. True or False?
True
False (*)
True
False (*)
9. One-to-Many Optional to
Mandatory becomes a _______________ on the Master table.
Optional Foreign Key (*)
Unique Key
Primary Key
Mandatory Foreign Key
Optional Foreign Key (*)
Unique Key
Primary Key
Mandatory Foreign Key
10. An Arc is transformed to
the physical model by adding a foeign Key for every relationship in the Arc.
True or False?
True (*)
False
True (*)
False
11. A barrred Relationship
will result in a Foreign Key column that also is part of:
The Check Constraint
The Column Name
The Table Name
The Primary Key (*)
The Check Constraint
The Column Name
The Table Name
The Primary Key (*)
12. Foreign keys must be
null. True or False?
True
False (*)
True
False (*)
13. The explanation below is
an example of which constraint type?
A primary key must be unique, and no part of the primary key can be null.
Column integrity
User-defined integrity
Referential integrity
Entity integrity (*)
A primary key must be unique, and no part of the primary key can be null.
Column integrity
User-defined integrity
Referential integrity
Entity integrity (*)
14. Identify all of the
incorrect statements that complete this sentence: A primary key is...
A set of columns in one table that uniquely identifies each row in another table. (*)
One or more columns in a table that uniquely identifies each row in that table.
Only one column that must be null. (*)
A single column that uniquely identifies each column in a table. (*)
A set of columns in one table that uniquely identifies each row in another table. (*)
One or more columns in a table that uniquely identifies each row in that table.
Only one column that must be null. (*)
A single column that uniquely identifies each column in a table. (*)
15. A foreign key always
refers to a primary key in the same table. True or False?
True
False (*)
True
False (*)
1. The conceptual model is
transformed into a physical model. The physical implementation will be a
relational database. True or False?
True (*)
False
True (*)
False
2. In an Oracle database,
why would the following table name not be allowed 'EMPLOYEE JOBS'?
You cannot have spaces between words in a table name (*)
The database does not understand all capital letters
EMPLOYEE is a reserved word
JOBS is a reserved word
You cannot have spaces between words in a table name (*)
The database does not understand all capital letters
EMPLOYEE is a reserved word
JOBS is a reserved word
3. Attributes become
columns in a database table. True or False?
True (*)
False
True (*)
False
4. The transformation from
an ER diagram to a physical design involves changing terminology. Entities in
the ER diagram become __________ :
Unique Keys
Tables (*)
Columns
Foreign Keys
Unique Keys
Tables (*)
Columns
Foreign Keys
5. Foreign keys must be
null. True or False?
True
False (*)
True
False (*)
6. A table does not have to
have a primary key. True or False?
True (*)
False
True (*)
False
7. The explanation below is
an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce.
Column integrity
Referential integrity
Entity integrity
User-defined integrity (*)
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce.
Column integrity
Referential integrity
Entity integrity
User-defined integrity (*)
8. Column integrity refers
to
Columns always containing text data less than 255 characters
Columns always containing positive numbers
Columns always containing values consistent with the defined data format (*)
Columns always having values
Columns always containing text data less than 255 characters
Columns always containing positive numbers
Columns always containing values consistent with the defined data format (*)
Columns always having values
9. Which of the following
is a valid reason for considering a Subtype Implementation?
The resulting table will reside in a single database and be used by just ONE user.
The common access paths for the supertypes are different.
Most of the relationships are at the supertype level.
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
The resulting table will reside in a single database and be used by just ONE user.
The common access paths for the supertypes are different.
Most of the relationships are at the supertype level.
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
10. An "Arc
Implementation" can be done just like any other Relationship - you simply
add the required Foreign Keys. True or False?
True
False (*)
True
False (*)
11. When mapping supertypes,
relationships at the supertype level transform as usual. Relationships at the
subtype level are implemented as foreign keys, but the foreign key columns all
become optional. True or False?
True (*)
False
True (*)
False
12. To resolve a many to
many relationship in a physical model you create a(n) ___________________?
Two tables with Foreign key constraints between them
Intersection table (*)
Unique key constraints
Intersection entity
Two tables with Foreign key constraints between them
Intersection table (*)
Unique key constraints
Intersection entity
13. Relationships on an ERD
can only be transformed into UIDs in the physical model? True or False?
True
False (*)
True
False (*)
14. The Oracle Database can
implement a many to many relationship. You simply create two foreign keys
between the two tables. True or False?
True
False (*)
True
False (*)
15. One-to-One relationships
are transformed into Check Constraints in the tables created at either end of
that relationship. True or False?
True
False (*)
True
False (*)
1. When mapping supertypes,
relationships at the supertype level transform as usual. Relationships at the
subtype level are implemented as foreign keys, but the foreign key columns all
become optional. True or False?
True (*)
False
True (*)
False
2. When mapping supertypes,
relationships at the supertype level transform as usual. Relationships at
subtype level are implemented as foreign keys, but the foreign key columns all
become mandatory. True or False?
True
False (*)
True
False (*)
3. Which of the following
is a valid reason for considering a Subtype Implementation?
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
Most of the relationships are at the supertype level.
The common access paths for the supertypes are different.
The resulting table will reside in a single database and be used by just ONE user.
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
Most of the relationships are at the supertype level.
The common access paths for the supertypes are different.
The resulting table will reside in a single database and be used by just ONE user.
4. The explanation below is
an example of which constraint type?
A column must contain only values consistent with the defined data format of the column
Column integrity (*)
User-defined integrity
Entity integrity
Referential integrity
A column must contain only values consistent with the defined data format of the column
Column integrity (*)
User-defined integrity
Entity integrity
Referential integrity
5. A table must have a
primary key. True or False?
True
False (*)
True
False (*)
6. Identify all of the
incorrect statements that complete this sentence: A primary key is...
A single column that uniquely identifies each column in a table. (*)
A set of columns in one table that uniquely identifies each row in another table. (*)
Only one column that must be null. (*)
One or more columns in a table that uniquely identifies each row in that table.
A single column that uniquely identifies each column in a table. (*)
A set of columns in one table that uniquely identifies each row in another table. (*)
Only one column that must be null. (*)
One or more columns in a table that uniquely identifies each row in that table.
7. The explanation below is
an example of which constraint type?
The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table.
Referential integrity (*)
Column integrity
User-defined integrity
Entity integrity
The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table.
Referential integrity (*)
Column integrity
User-defined integrity
Entity integrity
8. In a physical model,
many to many relationships are resolved via a structure called a(n):
________________
Intersection Entity
Intersection Table (*)
Subtype
Supertype
Intersection Entity
Intersection Table (*)
Subtype
Supertype
9. To resolve a many to
many relationship in a physical model you create a(n) ___________________?
Two tables with Foreign key constraints between them
Intersection entity
Intersection table (*)
Unique key constraints
Two tables with Foreign key constraints between them
Intersection entity
Intersection table (*)
Unique key constraints
10. A barrred Relationship
will result in a Foreign Key column that also is part of:
The Check Constraint
The Column Name
The Primary Key (*)
The Table Name
The Check Constraint
The Column Name
The Primary Key (*)
The Table Name
11. Relationships on an ERD
can only be transformed into UIDs in the physical model? True or False?
True
False (*)
True
False (*)
12. Attributes become
columns in a database table. True or False?
True (*)
False
True (*)
False
13. Why would this table
name NOT work in an Oracle database? this_year_end+next_year
Table names must begin with an alphabetic character.
It is too long.
The Plus sign + is not allowed in object names. (*)
None of the above.
Table names must begin with an alphabetic character.
It is too long.
The Plus sign + is not allowed in object names. (*)
None of the above.
14. In an Oracle database,
why would 1_TABLE not work as a table name?
TABLE is a reserved word.
There is no problem here. You can create a table called 1_TABLE.
The database does not understand all capital letters.
Object names must not start with a number. They must begin with a letter. (*)
TABLE is a reserved word.
There is no problem here. You can create a table called 1_TABLE.
The database does not understand all capital letters.
Object names must not start with a number. They must begin with a letter. (*)
15. In a physical data
model, an attribute becomes a _____________.
Constraint
Table
Foreign Key
Column (*)
Constraint
Table
Foreign Key
Column (*)