View the step-by-step solution to:

Question

 


Saved






/>

Your cousin, a senior in high school, asks you to play a Jeopardy-style game with her to help prepare for her computer science exam next week. She gives you these two clues about a type of relational database key: No column values may be NULL, and columns must be necessary for uniqueness. Which type of key is she referring to? Select one.

Question 1 options:


Foreign key


Simple primary key


Composite primary key


Alternate key

Question 2 (2 points)

 








During a water cooler chat, your colleague claims that both data types and names of foreign and primary keys must be the same. Is this true or false?

Question 2 options:

TrueFalse

Question 3 (2 points)

 








Four actions that can be implemented on a database to autocorrect violations of referential integrity, and the outcomes of the actions are listed below. Match the violation with the corrective action.

Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once.

Question 3 options:

1

2

3

4

Rejects an insert, update, or delete

1

2

3

4

Propagates primary key changes to foreign keys

1

2

3

4

Sets invalid foreign keys to NULL

1

2

3

4

Sets invalid foreign keys to a default primary key value, specified in SQL

1.Restrict

2.Set Null

3.Set Default

4.Cascade

Question 4 (2 points)

 








Which of these are ways in which referential integrity can be violated? Select all that apply.

Question 4 options:


A primary key is inserted.


A row containing a primary key is deleted.


A foreign key is updated.


A row containing a foreign key is deleted.


A primary key is updated.


A row containing a foreign key is inserted.

Question 5 (2 points)

 








At a local hackathon, you and your classmates are invited to play a "Deal or No Deal" type of game about databases. To win the first round, you must state whether the following statement is true or false: For primary key deletions and updates, most databases support only the corrective action Restrict.

Question 5 options:

TrueFalse

Question 6 (2 points)

 








Three actions that databases can take when autocorrecting foreign key insertions and updates are listed below, as are the additional limitations on databases for each action. Match each action to its associated limitation.

Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once.

Question 6 options:

1

2

3

It cannot be used when a foreign key is not NULL.

1

2

3

The value specified for it must be a valid primary key.

1

2

3

It is applied when no action is specified.

1.Restrict

2.Set Null

3.Set Default

Question 7 (2 points)

 








When the action Cascade propagates the changes made to a primary key to the associated foreign key, which of the following are the outcomes? Select all that apply.

Question 7 options:


Rows containing invalid foreign keys are deleted when the primary key is deleted.


Rows containing valid foreign keys are inserted when the primary key is inserted.


Invalid foreign keys are set to the new primary key value when a primary key is updated.


Rows containing valid foreign keys are deleted when the primary key is deleted.


Rows containing valid foreign keys are inserted when the primary key is duplicated.

Question 8 (2 points)

 








The four types of joins or SELECT statements that relational databases allow are listed below, as are the combinations that these statements select from the database tables. Match each join type with its associated combination.

Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once.

Question 8 options:

1

2

3

4

Only matching left and right table rows

1

2

3

4

Only matching left table rows but all right table rows

1

2

3

4

All left and right table rows, regardless of match

1

2

3

4

Only matching right table rows but all left table rows

1.Inner join

2.Left join

3.Right join

4.Full join

Question 9 (2 points)

 








Your coworker has decided to take an online course about the basics of databases so that he can improve his job performance. As you study with him at lunch, he says that he thinks attributes are essential in an ER diagram. Is this true or false?

Question 9 options:

TrueFalse

Question 10 (2 points)

 








If you needed the database to select values in a specific order but order them in ascending order, which of the following clauses should you use along with the SELECT command? Select one.

Question 10 options:


Order By LIKE BINARY


Order By LIKE NIT


Order By NOT DESC


Order By ASCE


Order By

Top Answer

1) Composite Primary Key 2) False 3) Rejects an insert, update, or delete - Restrict Propagates primary key changes to... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question