Database Final Exam Questions With 100% Verified Answers
4 views 0 purchase
Course
Database
Institution
Database
Database Final Exam Questions With 100%
Verified Answers
One-to-One relationships are transformed into Check Constraints in the tables created at either
end of that relationship. True or False? - answerFalse
The Oracle Database can implement a many-to-many relationship. You simply create two
f...
Database Final Exam Questions With 100%
Verified Answers
One-to-One relationships are transformed into Check Constraints in the tables created at either
end of that relationship. True or False? - answer✔False
The Oracle Database can implement a many-to-many relationship. You simply create two
foreign keys between the two tables. True or False? - answer✔False
When translating an arc relationship to a physical design, you must turn the arc relationships into
foreign keys. Assuming you are implementing an Exclusive Design, you must also create two
Unique Key Constraints to ensure the Arc is implemented correctly. True or False? -
answer✔False
The transformation from an ER diagram to a physical design involves changing terminology.
Secondary Unique Identifiers become:
A. Columns
B. Tables
C. Unique Constraints
D. Primary Key Constraints - answer✔Unique Constraints
In a physical data model, an attribute becomes a _____________.
A. Table
D. Column - answer✔Column
In an Oracle database, why would 1_TABLE not work as a table name?
A. The database does not understand all capital letters.
B. There is no problem here. You can create a table called 1_TABLE.
C. Object names must not start with a number. They must begin with a letter.
D. TABLE is a reserved word. - answer✔Object names must not start with a number. They must
begin with a letter.
The explanation below is a column integrity constraint. True or False? A column must contain
only values consistent with the defined data format of the column. - answer✔True
Foreign keys must be null. True or False? - answer✔False
A table must have a primary key. True or False? - answer✔False
The explanation below is a User Defined integrity rule and must, therefore, be manually coded;
the Database cannot enforce this rule automatically. True or False? A primary key must be
unique, and no part of the primary key can be null. - answer✔False
The text below is an example of what constraint type? If the number of BOOKS lent to a
BORROWER in the LIBRARY exceeds 5, then we must send him a letter requesting the return
of the BOOKS; this will require extra programming to enforce.
D. Referential integrity - answer✔User-defined integrity
System Documentation is developed right at the end once the system has gone live and users
have been using it for a little while. You are more likely to get it correct that way. True or False?
- answer✔False
In the Analysis phase, the tables are created and populated with test data. True or False? -
answer✔False
Once you have created a table, it is not possible to alter the definition of it. If you need to add a
new column you must delete the table definition and create a new, correct table. True or False? -
answer✔False
The f_customers table contains the following data:
ID NAME ADDRESS CITY STATE ZIP
1 Cole Bee 123 Main Street Orlando FL 32838
2 Zoe Twee 1009 Oliver Avenue Boston MA 02116
3 Sandra Lee 22 Main Street Tampa FL 32444
If you run the following statement: DELETE FROM F_CUSTOMERS WHERE ID <= 2;
How many rows will be left in the table?
A. 0
B. 3
C. 1
D. 2 - answer✔1
The DESCRIBE command returns all rows from a table. True or False? - answer✔False
The _______ clause can be added to a SELECT statement to return a subset of the data.
A. ANYWHERE
B. WHICH
C. WHERE
D. EVERY - answer✔WHERE
What command will return data from the database to you?
A. FETCH
B. GET
C. SELECT
D. RETURN - answer✔SELECT
When you use the SELECT clause to list one or two columns only from a table and no WHERE
clause, which SQL capability is used?
A. Joining only
B. Selection only
C. Projection only
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Brainbarter. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
