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
```

Computer Science & Information Technology

You might also like to view...

You use the ____ method to convert a string to uppercase.

A. ConvToUpper B. strUpper C. ToUpper D. ConvUpper

Computer Science & Information Technology

What is described by a runtime complexity of O(1)?

a. Algorithm efficiency is independent of the problem size, and is the fastest b. There is a limit on performance c. Memory use is inefficient d. Constant 1 needs to be removed

Computer Science & Information Technology

Give a command for viewing the size of your home directory?Give a command for displaying the sizes of all the files in your home directory

What will be an ideal response?

Computer Science & Information Technology

Sharing photos on the Web can be done privately or publicly, depending on your goal.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology