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

The ____ function determines the lowest number in a range.

A. MAX B. AVERAGE C. SUM D. MIN

Computer Science & Information Technology

_____ is designed to exchange and transport data.?

A. ?Extensible Markup Language (XML) B. ?JavaScript C. ?Unified Modeling Language (UML) D. ?Practical Extraction and Report Language (PERL)

Computer Science & Information Technology