IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 41

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

Db2 CONNECT -

Answer options

• A. Prompts you for the database name or alias
• B. Returns information about the current server
• C. Prompts you for the authentication information
• D. Returns an error, because you provided no database or alias

Correct answer: B

Explanation

The correct answer is B because running 'Db2 CONNECT -' while connected will display information about the current server. The other options do not apply since the command does not prompt for a database name, authentication information, or result in an error when a connection is already established.