12c LAB_CHAPTER_6_QUIZ
Which of the following is a correct statement?
A PUBLIC synonym can be referenced by any user.
Which of the following commands is used to create a function-based index?
CREATE INDEX...ON
When creating a sequence, which of the following is not an optional clause?
CREATE SEQUENCE
Which command will create a synonym for a table?
CREATE SYNONYM synonymname FOR tablename;
The last value generated by a sequence is stored in the ____ pseudocolumn.
CURRVAL
THE __ CLAUSE IS USED TO SPECIFY THE INTERVAL BETWEEN TWO SEQUENTIAL VALUES
INCREMENT BY
An index can be created__
Implicitly and Explicitly
If the last values generated by a sequence were 277 and 278, which of the following changes cannot be initiated by the ALTER SEQUENCE command?
MAXVALUE
A function-based index can be created based on which of the following?
UPPER(lastname) (retail-cost) UPPER(firstname) * all of the above
If a sequence is set to pre-generate sequential values, ____ values will be generated at one time by default.
20
NEXTVAL call generates the sequence value of 5. After the value is generated, what value will be stored in CURRVAL?
5
Which of the following statements about sequences is incorrect?
A sequence can be used to generate unique names for database objects.
Which of the following commands can be used to modify an index?
ALTER INDEX...MODIFY ALTER INDEX...CHANGE ALTER TABLE...INDEX * none of the above
Which command will create a sequence named NEWSEQUENCE to generate a series of integers?
ALTER SEQUENCE sequencename XX
WHICH OF THE FOLLOWING STATEMENTS ABOUT INDEXES IS INCORRECT?
An index is only beneficial if a large percentage of a table is expected to be returned in query results.
Which option is used to have Oracle 12c pre-generate a set of values and store those values in the server's memory?
CACHE
Based on the structure of the BOOKS table, which of the following is a valid SQL statement?
CREATE INDEX books_title_idx ON books (INITCAP(title));
Based on the structure of the CUSTOMERS table, which of the following is a valid SQL statement?Structure of the CUSTOMERS table
CREATE INDEX customers_name_idx ON customers (lastname, firstname); XX
Which command will create an index?
CREATE INDEX indexname ON tablename (columnname)
The ____ options are used to determine whether Oracle 12c should begin reissuing values from the sequence once the minimum or maximum value has been reached.
CYCLE | NOCYCLE
A negative number can be assigned to the ____ clause to generate sequential numbers in decreasing order.
DECREMENT BY XX
Which of the following can be used to remove an index that currently exists on the column of a database table?
DELETE INDEX XX
Which of the following SQL statements will delete the private synonym named MYSYNON?
DROP PRIVATE SYNONYM mysynon; XX
Which of the following commands can be used to remove a sequence from a database?
DROP SEQUENCE
Which command will delete a sequence?
DROP SEQUENCE SEQUENCENAME
Which of the following contains the ROWID of referenced rows?
INDEX
Which of the following is a valid SQL statement when referencing a sequence?
INSERT INTO orderitems VALUES (nextvalue, 1, 811794939, 1); XX
Which of the following serves the same basic purpose as an index in a book, by allowing users to quickly locate specific records?
Index
Which of the following is used to establish a minimum or maximum value, respectively, for a sequence?
MINVALUE | MAXVALUE
Which of the following is a pseudocolumn?
NEXTVAL
Which of the following keywords is used to actually generate a sequence value?
NEXTVAL
Which of the following statements about NEXTVAL and CURRVAL is incorrect?
NEXTVAL and CURRVAL are pseudocolumns that store unique names for database objects.
Which command will create a sequence named NEWSEQUENCE to generate a series of integers?
NONE OF THE ABOVE
Which options are used in application cluster environments where multiple users may be requesting sequence values at the same time?
ORDER | NOORDER
Which of the following is defined in Oracle12c as simply anything that has a name and a defined structure?
Object
A(n) ____ synonym is used by an individual to reference objects owned by that person.
PRIVATE
If the PUBLIC keyword is not included when a synonym is created, the command will create a(n) ____ synonym, by default.
PRIVATE
To remove a PUBLIC synonym, you must include the ____ keyword in the DROP command.
PUBLCI
A(n) ____ synonym is used by others to access an individual's database objects.
PUBLIC
Oracle10g will begin each sequence with the value of one, unless another value is specified in the ____ clause.
START WITH
Which of the following sequence settings cannot be changed with the ALTER SEQUENCE command?
START WITH
Which of the following can be created so other users will not need to prefix a table owned by user Jeff with his schema name?
SYNONYM
A(n) ____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.
Sequence
Which of the following can be used to provide an alternative, simplified name, to identify database objects?
Synonym
To verify individual settings for the clauses of a sequence, you can query the ____ table in the data dictionary.
USER_SEQUENCES
When working with cached sequence values, which of the following is correct?
When a value has been generated and cached, that value has been assigned and cannot be regenerated until the sequence begins a new cycle.
Who can remove a public synonym from the database?
a user with DBA privileges
An index is not implicitly created when which type of constraint is created?
none of the above XX
The purpose of an index is to __
speed up DML operations speed up full table scans efficiently determine whether a value exists in a table * all of the above XX