PrepAway - Latest Free Exam Questions & Answers

which schema is the table MYTABLE created?

Consider the following scenario. You are currently connected to a database called MYDB as the
user MYUSER. When creating a table within this database, you use the command:
CREATE TABLE MYTABLE (DEPT CHAR(3) NOT NULL)

Under which schema is the table MYTABLE created?

PrepAway - Latest Free Exam Questions & Answers

A.
MYDB

B.
MYUSER

C.
DB2INST1

D.
You get an error because your command is ambiguous, as the table schema is not specifieD.

Explanation:


Leave a Reply