Informatics Practices
Which command shows the list of database in MySQL?
- desc databases;
- show tables;
- show databases;
- describe databases;
SQL Queries
2 Likes
Answer
show databases;
Reason — The SHOW DATABASES; command lists all the databases managed by the MySQL server.
Answered By
1 Like
Related Questions
…………… command helps to see the structure of a table/relation.
- Show
- Select
- Describe
- Order by
Which of the following types of table constraints will prevent the entry of duplicate rows?
- Unique
- Distinct
- Primary Key
- NULL
Which of the following are DDL commands?
(A) Delete
(B) Create
(C) Update
(D) Alter
(E) Drop
- (B), (D) and (E)
- (A), (B) and (D)
- (B), (C) and (D)
- (A), (B) and (C)
Identify the correct statement(s):
Statement 1 (S1): Char data type in MySQL stores fixed length strings.
Statement 2 (S2): Char data type stores string smaller than the maximum field size.
- (S1) : Correct, (S2) : Correct
- (S1): Incorrect, (S2) : Correct
- (S1): Correct, (S2) : Incorrect
- (S1) : Incorrect, (S2) : Incorrect