Test Bank For Oracle 11G SQL 2nd Edition By Joan Casteel
Original price was: $25.00.$20.00Current price is: $20.00.
Test Bank For Oracle 11G SQL 2nd Edition By Joan Casteel
Chapter 6: Additional Database Objects
TRUE/FALSE
1. A sequence serves as a nickname for a database object.
ANS: F PTS: 1 REF: 176
2. A database index allows users and application programs to quickly locate specific records.
ANS: T PTS: 1 REF: 176
3. A synonym is an alternate name assigned to a database object.
ANS: T PTS: 1 REF: 176
4. When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE
command, numeric values are generated in descending order.
ANS: F PTS: 1 REF: 178
5. When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE
command, numeric values are generated in descending order.
ANS: T PTS: 1 REF: 178
6. The START WITH clause is used to identify the starting numeric value for a synonym.
ANS: F PTS: 1 REF: 179
7. By default, the START WITH clause has a value of one.
ANS: T PTS: 1 REF: 179
8. By default, the lowest value that can be generated by a sequence is 0.
ANS: F PTS: 1 REF: 178
9. If the minimum value for a sequence is not specified, then NOMINVALUE will be assumed as the
default.
ANS: T PTS: 1 REF: 179
10. The highest possible value for a descending sequence is -1.
ANS: T PTS: 1 REF: 179
11. The highest possible value for a sequence can be specified through the MAXVALUE clause.
ANS: T PTS: 1 REF: 179
2
12. After the highest possible value for a sequence has been reached, previous values can be reused if
the NOCYCLE option has been specified.
ANS: F PTS: 1 REF: 179
13. The NOCACHE option specifies that the sequence can generate a number only after a request has
been made by a user.
ANS: T PTS: 1 REF: 180
14. Pre-generated sequence numbers that have not been used when the database is shut down will no
longer be available when the database is restarted.
ANS: T PTS: 1 REF: 180
15. When a sequence is created for internal control purposes, the values should not be cached
otherwise gaps may appear in the sequence.
ANS: T PTS: 1 REF: 180
16. The USER_SEQUENCES view of the data dictionary can be used to determine the current values
and settings for a sequence.
ANS: T PTS: 1 REF: 182
17. The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.
ANS: F PTS: 1 REF: 183
18. The NEXTVAL pseudocolumn can be referenced in an INSERT command to add the value to a
database table.
ANS: T PTS: 1 REF: 183
19. The START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.
ANS: T PTS: 1 REF: 185
20. To change the starting value for a sequence, the sequence must be dropped and then re-created.
ANS: T PTS: 1 REF: 185
Additional information
Frequently Asked Questions:
🚨 Warning: This Isn’t Your Typical Textbook! 🚨.
This Test Bank is a complete collection of study questions, instantly available for download in PDF format. It covers every chapter, giving you immediate access to high-quality, reliable study materials for effective exam preparation. All content is original and features 100% verified answers for your confidence.
What is a Test Bank?
A Test Bank is a study aid featuring a collection of questions with corresponding answers, typically related to academic textbooks. Publishers provide these test banks to instructors to assist in creating effective exams and tests for students.
Are all chapters included, and are there questions for each chapter?
Are answers to the questions verified?
Yes, all answers provided in the Test Bank are thoroughly verified to ensure accuracy.
Is the content original and directly from the publisher?
Yes, rest assured that the content is original and sourced directly from the publisher.
Can I share the Test Bank with others?
No, the Test Bank is for personal use only, and sharing or distributing it is not permitted.
Can I study the material on any device?
Absolutely! The Test Bank is in PDF format, making it compatible with all devices and browsers for your convenience.
How soon can I start studying after making a purchase?
Immediately! The Test Bank is available for instant download, allowing you to begin your study journey right after completing the purchase.
Are there any additional Test Banks or resources available?
Yes, we offer a variety of Test Banks, ATI, Hesi Exams, and more. Feel free to contact us for information on additional study resources.
What if I encounter technical issues with the download?
In case of any technical difficulties, please contact our support team, and they will promptly assist you in resolving the issue.
You May Also Be Interested In
Products related to this item
Principles of Pediatric Nursing Caring for Children 7th Edition Marcia London Test Bank
Original price was: $60.00.$35.00Current price is: $35.00. Buy Now
What Our Customers Say About e-testbank.com
Excellent
Based on 653 reviews
Only logged in customers who have purchased this product may leave a review.
Reviews
There are no reviews yet.