GEMS is an Oracle 12c database which holds information regarding PLAZA GOLDS LTD. industries with two pluggable databases CORAL and RUBY. JENIFER is a local user of CORAL pluggable database, she has been provided with the privilege to connect and create table in CORAL database. She creates a table named account_holders using the below statement.
SQL> CREATE TABLE ACCOUNT_HOLDERS (ACC_NO INT);
Then tries to insert values into the table and faces below error. What would be the possible reasons for the error?

Question

GEMS is an Oracle 12c database which holds information regarding PLAZA GOLDS LTD. industries with two pluggable databases CORAL and RUBY. JENIFER is a local user of CORAL pluggable database, she has been provided with the privilege to connect and create table in CORAL database. She creates a table named account_holders using the below statement.

SQL> CREATE TABLE ACCOUNT_HOLDERS (ACC_NO INT);

Then tries to insert values into the table and faces below error. What would be the possible reasons for the error?

anonymous · Accepted Answer

Correct Solution - d

Important Links