Which of the following statements is true?a. A gap can appear in a sequence created with the NOCACHE option if the system crashes before a user can commit a transaction.b. Any unassigned sequence values appears in the USER_SEQUENCE data dictionary table as unassigned.c. Only the user who creates a sequence is allowed to delete it.d. Only the user who created a sequence is allowed to use the value enerated by the sequence.
Which of the following statements is true?a. A gap can appear in a sequence created with the NOCACHE option if the system crashes before a user can commit a transaction.b. Any unassigned sequence values appears in the USER_SEQUENCE data dictionary table as unassigned.c. Only the user who creates a sequence is allowed to delete it.d. Only the user who created a sequence is allowed to use the value enerated by the sequence.
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 8MC
Related questions
Question
Which of the following statements is true?
a. A gap can appear in a sequence created with the NOCACHE option if the system crashes before a user can commit a transaction.
b. Any unassigned sequence values appears in the USER_SEQUENCE data dictionary table as unassigned.
c. Only the user who creates a sequence is allowed to delete it.
d. Only the user who created a sequence is allowed to use the value enerated by the sequence.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning