Examice

Exam C2090-616 All QuestionsBrowse all questions from this exam

Go to Exam

Question 46

If you are already connected to a database, what does running the following statement do?

Db2 CONNECT -

Prompts you for the database name or alias

Returns information about the current server

Prompts you for the authentication information

Returns an error, because you provided no database or alias

Correct Answer: D

Running the statement 'Db2 CONNECT' without specifying a database name or alias when you are already connected to a database will return an error. The DB2 command requires that if you are connecting or reconnecting to a database, you must provide the database name or alias. Without this information, the command cannot proceed and will result in an error.

Discussion

KalliopiOption: B

Answer is B. Question specifies "If you are already connected to a database" .

JamesBondOption: B

Answer is B if you are connected then [db2inst2@vbox1 ~]$ db2 connect Database Connection Information Database server = DB2/LINUXX8664 11.5.5.0 SQL authorization ID = XXXXXXX Local database alias = XXXXXXX

deepdg23Option: D

Answer should be D: db2 CONNECT SQL1024N A database connection does not exist. SQLSTATE=08003