Oracle Database 12c SQL 1z0-071 Question # 50 Topic 6 Discussion

Oracle Database 12c SQL 1z0-071 Question # 50 Topic 6 Discussion

1z0-071 Exam Topic 6 Question 50 Discussion:
Question #: 50
Topic #: 6

Examine these statements and results:

SQL> SELECT COUNT(*) FROM emp

COUNT(*)

---------------------

14

sQL> CREATE GLOBAL TEMPORARY TABLE t emp As SELECT * FROM emp;

Table created

SQL> INSERT INTo temp SELECT * FROM emp;

14 rows created

SQL> COMMIT:

Commit complete*

SQL> INSERT INTo temp SELECT * EROM emp;

14. rows created

SQL> SELECT COUNT(*) FROM t emp

How many rows are retrieved by the last query?


A.

28


B.

0


C.

14


D.

42


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.