Create a sequence to add room IDs and then insert a new room into LOCATION table using the newly created sequence. What is the CURRVAL after the new row is inserted?
Use case study databases for the following queries.
```
SQL> CREATE SEQUENCE LOCATION_ROOMID_SEQ
2 START WITH 22
3 MAXVALUE 99
4 NOCACHE;
SEQUENCE CREATED.
SQL> INSERT INTO LOCATION
2 VALUES (LOCATION_ROOMID_SEQ.NEXTVAL, 'NEHRU', 311, 50, 'C');
1 ROW CREATED.
SQL> SELECT LOCATION_ROOMID_SEQ.CURRVAL
2 FROM DUAL;
CURRVAL
----------
22
```
You might also like to view...
_________________ has to do with how the amount of memory used can change depending on some factor(s), usually the number of elements.
A. Heapiness B. Space complexity C. Dynamic memory D. RAM-inosity
Which of the following statements is false?
a. A public class can be accessed by a class from a different package. b. A private method cannot be accessed by a class in a different package. c. A protected method can be accessed by a subclass in a different package. d. A method with no visibility modifier can be accessed by a class in a different package.
Running a macro in Excel deletes the entire Undo history
Indicate whether the statement is true or false
In the Audio or Video dialog box, you can switch to the Details pane by first tapping or clicking the ____ button.
A. OneDrive B. Properties C. Views D. Organize