MySQL

Question 1

List all database names

Answer 1

show databases;

Question 2

login to remote DB engine (given user = admin and remote = somedbinstance.com)

Answer 2

mysql -h somedbinstance.com -u admin -p

Question 3

add a new database with the name somedb

Answer 3

create database somedb

Question 4

delete a database named somedb

Answer 4

drop database somedb

Question 5

When referencing database names, MySQL is case sensitive. (True or False)

Answer 5

True

Question 6

SQL commands are case sensitive. (True or False)

Answer 6

False

Question 7

display name of current database

Answer 7

select database()

Question 8

switch to another database that has the name somedb

Answer 8

use somedb

Question 9

What are the 3 types of data

Answer 9

Numeric, String, and Date

Question 10

What is the type and range of INT variables?

Answer 10

Numeric
-2.147483647 billion to +2.147483647 billion

Question 11

List columns and metadata in a table called sometbl

Answer 11

desc sometbl

Question 12

List table in current database

Answer 12

show tables

Question 13

Delete a table from current database

Answer 13

drop