c. d. e. MINIMUMVAL NOCACHE All of the above are valid options. 19. What can be
ID: 3689613 • Letter: C
Question
c. d. e. MINIMUMVAL NOCACHE All of the above are valid options. 19. What can be referenced to determine whether an index is used to perform a query? a. USER INDEXES view b. query source code c. explain plan d. database access plan 7. 20. Which of the following commands creates a private synonym? a. CREATE PRIVATE SYNONYM b. CREATE NONPUBLIC SYNONYM c. CREATE SYNONYM d. CREATE PUBLIC SYNONYM Hands-On Assignments To perform the following assignments, refer to the tables in the Justlee Books database. 1. Create a sequence for populating the Customer# column of the CUSTOMERS table. When setting the start and increment values, keep in mind that data already exists in this table.
Explanation / Answer
1)
create sequence seq_id start with 1 increment by 1 nocache;
SELECT customer from CUSTOMER where customerID = seq_id.nextval;
---------------------------------------------------------------------------
2) create sequence seq_id start with 1 increment by 1 nocache;
INSERT into CUSTOMER (customerID,lastname,firstname,zip) VALUES (seq_id.nextval,'shoulders','Frank',23567)
----------------------------------------------------------------------------------------------------------
3) create sequence MY_FIRST_SEQ start with 5 increment by 3 nocache;
--------------------------------------------------------------------------------------------
4) SELECT * FROM DUAL where customerID = MY_FIRST_SEQ.nextval;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.