MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Command to open an existing database
A
SHOW DATABASES
B
USE
C
SHOW TABLES
D
None of the above
Explanation: 

Detailed explanation-1: -Answer: The command to open an existing database is as follows: USE database name; Question 16.

Detailed explanation-2: -To access a specific database, type the following command at the mysql> prompt, replacing dbname with the name of the database that you want to access: Copy use dbname; Make sure you do not forget the semicolon at the end of the statement. After you access a database, you can run SQL queries, list tables, and so on.

There is 1 question to complete.
Previous
Next