IBM Exam Questions

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?

A.
MYDB

B.
MYUSER

C.
DB2INST1

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

Explanation: