1.3 Managing databases

Question 1

database system instance

Answer 1

single executing copy of a database system

Question 2

CREATE DATABASE DatabaseName

Answer 2

creates a new database

Question 3

DROP DATABASE DatabaseName

Answer 3

deletes a database, including all tables in the database.

Question 4

SHOW statement

Answer 4

provides database users and administrators with information about databases, the database contents (tables, columns, etc.), and server status information.

Question 5

SHOW DATABASES

Answer 5

lists databases available in the database system.

Question 6

SHOW TABLES

Answer 6

lists tables available in the currently selected database

Question 7

SHOW COLUMNS

Answer 7

lists columns available in a specific table named by a FROM clause

Question 8

SHOW CREATE TABLE

Answer 8

shows the CREATE TABLE statement for a given table

Question 9

USE statement

Answer 9

selects a database and is required to show information about tables within a specific database.