Database 9
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 Mark for Review (1) Points User-defined integrity Column integrity Referential integrity Entity integrity
Column integrity (*)
Column integrity refers to Mark for Review (1) Points 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 values consistent with the defined data format (*)
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. Mark for Review (1) Points Column integrity User-defined integrity Referential integrity Entity integrity
Entity integrity (*)
An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False? Mark for Review (1) Points True False
True (*)
In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'? Mark for Review (1) Points 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
You cannot have spaces between words in a table name (*)
The "Arc Implementation" is a synonym for what type of implementation? Mark for Review (1) Points Supertype and Subtype Implementation Cascade Implementation Supertype Implementation Subtype Implementation
Supertype and Subtype Implementation (*)
The "Arc Implementation" is a synonym for what type of implementation? Mark for Review (1) Points Supertype and Subtype Implementation Supertype Implementation Cascade Implementation Subtype Implementation
Supertype and Subtype Implementation (*)
Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) Mark for Review (1) Points (Choose all correct answers) 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 (*) A single column that uniquely identifies each row in a table (*) A set of columns that uniquely identifies each row in a table (*)
Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review (1) Points (Choose all correct answers) 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. (*) Only one column that must be null. (*) A single column that uniquely identifies each column in a table. (*)
Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review (1) Points (Choose all correct answers) 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. (*) Only one column that must be null. (*) A set of columns in one table that uniquely identifies each row in another table. (*)
Which of the following is a valid reason for considering a Subtype Implementation? Mark for Review (1) Points 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
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
Which of the following is a valid reason for considering a Subtype Implementation? Mark for Review (1) Points 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.
Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
In a physical data model, an attribute becomes a _____________. Mark for Review (1) Points Constraint Column Table Foreign Key
Column (*)
In a physical data model, an attribute becomes a _____________. Mark for Review (1) Points Constraint Table Foreign Key Column
Column (*)
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 Mark for Review (1) Points Column integrity User-defined integrity Referential integrity Entity integrity
Column integrity (*)
The Physical model is created by transforming which of the following models? Mark for Review (1) Points Constraint Table Physical Conceptual
Conceptual (*)
The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False? Mark for Review (1) Points True False
False
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? Mark for Review (1) Points True False
False
A foreign key always refers to a primary key in the same table. True or False? Mark for Review (1) Points True False
False (*)
Foreign keys must be null. True or False? Mark for Review (1) Points True False
False (*)
One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False? Mark for Review (1) Points True False
False (*)
Why would this table name NOT work in an Oracle database? this_year_end+next_year Mark for Review (1) Points 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.
The Plus sign + is not allowed in object names. (*)
Why would this table name NOT work in an Oracle database? this_year_end+next_year Mark for Review (1) Points 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.
The Plus sign + is not allowed in object names. (*)
A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review (1) Points The Check Constraint The Column Name The Table Name The Primary Key
The Primary Key (*)
Attributes become columns in a database table. True or False? Mark for Review (1) Points True False
True (*)
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? Mark for Review (1) Points True False
True (*)
In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'? Mark for Review (1) Points 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
You cannot have spaces between words in a table name (*)
Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) Mark for Review (1) Points (Choose all correct answers) 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
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 (*)
One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False? Mark for Review (1) Points True False
False (*)
Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? Mark for Review (1) Points True False
False (*)
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? Mark for Review (1) Points True False
False (*)
To resolve a many to many relationship in a physical model you create a(n) ___________________? Mark for Review (1) Points Unique key constraints Intersection entity Intersection table Two tables with Foreign key constraints between them
Intersection table (*)
Foreign keys cannot be null when Mark for Review (1) Points 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 is part of a primary key (*)
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) (Choose Two) Mark for Review (1) Points (Choose all correct answers) 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 optional (*) Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review (1) Points 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.
Object names must not start with a number. They must begin with a letter. (*)
In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review (1) Points 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.
Object names must not start with a number. They must begin with a letter. (*)
In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review (1) Points 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.
Object names must not start with a number. They must begin with a letter. (*)
Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review (1) Points (Choose all correct answers) 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. (*) A set of columns in one table that uniquely identifies each row in another table. (*)
One-to-Many Optional to Mandatory becomes a _______________ on the Master table. Mark for Review (1) Points Optional Foreign Key Unique Key Primary Key Mandatory Foreign Key
Optional Foreign Key (*)
A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review (1) Points The Primary Key The Column Name The Check Constraint The Table Name
The Primary Key (*)
An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False? Mark for Review (1) Points True False
True
The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review (1) Points True False
True (*)
When an Arc is transformed to the physical model every relationship in the Arc becomes a mandatory Foreign Key. True or False? Mark for Review (1) Points True False
false
