Examine these commands and their output:
SQL> SELECT * FROM emp;
ENO ENAME
--- -------
100 Adam
101 Alan
SQL> INSERT INTO emp VALUES(102,'Ben');
1 row created.
...
USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.
USER1 executes these commands:
SQL> UPDATE dept SET loc='UK' where dno=1;
1 row u...
32.choose the best answer
View the Exhibit and examine the data in EMP and DEPT tables.
In the DEPT table, DEPTNO is the PRIMARY KEY.
In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the ...
31.choose the best answer
Which statement is true regarding the USING clause in table joins?
A) It can be used to access data from tables through equijoins as well as nonequijoins.
B) It can be use...
