Oracle 11G SQL 2nd Edition By Joan Casteel – Test bank

Do you need test banks fast? eTestBank.net is the best test bank website for you! Download your test bank right after you pay. No waiting!

Why eTestBank.net is Great:

✅ Instant Download:
Get your test bank right away after payment.

✅ Unlimited Downloads:
Download your test bank anytime and as many times as you want.

✅ 24/7 Live Help:
We are here to help you all day, every day.

✅ Guaranteed Delivery:
If you don’t get the download right away, we will send it to you in 3 to 6 hours.

How to Get Your Test Bank:

Pick Your Test Bank: Choose from many test banks.
Pay Safely: Pay securely on eTestBank.net.
Download Instantly: Get your test bank immediately after payment.
Download Anytime: Unlimited downloads whenever you need them.

Need Help? Contact Us:

📧 Email: [Support@etestbank.net]
📱 WhatsApp: [https://wa.me/message/MC222DLQ4GDXL1r]

Didn’t Get Your Download?

Don’t worry! If you don’t get the file right away, we’ll send it to you in 3 to 6 hours. Need it sooner? Contact us by email or WhatsApp.

💡 Buy now from eTestBank.net for instant downloads, unlimited access, and 24/7 support—get your test bank today!

Chapter 4: Constraints

TRUE/FALSE

Constraints are rules used to enforce business rules, practices, and policies. ANS: T PTS: 1 REF: 100
Constraints are used to ensure the accuracy and integrity of the data contained in the database. ANS: T PTS: 1 REF: 100
A constraint can only be created as part of the CREATE TABLE command. ANS: F PTS: 1 REF: 102
A constraint name can consist of up to 10 characters. ANS: F PTS: 1 REF: 101
A primary key is usually given the abbreviation _pk in the constraint name if the name is assigned by the user.ANS: T PTS: 1 REF: 101
Any constraint can be created at the table or the column level.ANS: F PTS: 1 REF: 102
A foreign key constraint can only be created at the column level.ANS: F PTS: 1 REF: 102
A NOT NULL constraint can only be created at the column level.ANS: T PTS: 1 REF: 102
A constraint for a composite primary key must be created at the table level.ANS: T PTS: 1 REF: 103
The CONSTRAINT keyword is required if the user is going to assign a name to a constraint.

ANS: T PTS: 1 REF: 102 11. A constraint is always enforced at the table level.

ANS: T PTS: 1 REF: 102
12. The table-level approach can be used to create any constraint, except a CHECK constraint.

ANS: F PTS: 1 REF: 102

A PRIMARY KEY constraint will make certain the column designated as the primary key does not contain a NULL value.ANS: T PTS: 1 REF: 103
The MODIFY clause is used with the ALTER TABLE command to add a PRIMARY KEY constraint to an existing table.ANS: F PTS: 1 REF: 103
Only one PRIMARY KEY constraint can exist for each table.ANS: T PTS: 1 REF: 103
A FOREIGN KEY constraint can be added to the column of a table to ensure that the referenced data value actually exists in the other table.ANS: T PTS: 1 REF: 106
If a FOREIGN KEY constraint exists, then a record cannot be deleted from the parent table if that row is referenced by an entry in the child table.ANS: T PTS: 1 REF: 108
A FOREIGN KEY constraint will not allow a row containing a NULL value in the foreign key column to be added to the table.ANS: F PTS: 1 REF: 106
A UNIQUE constraint is the same as a PRIMARY KEY constraint, except that it will accept NULL values.ANS: T PTS: 1 REF: 111