1.3 Managing Databases

Question 1

What is a database system instance?

Answer 1

A database system instance is a single executing copy of a database system.

Question 2

How many instances of a database system do personal computers usually run?

Answer 2

Personal computers usually run just one instance of a database system.

Question 3

How many instances of a database system do shared computers typically run?

Answer 3

Shared computers, such as those used for cloud services, usually run multiple instances of a database system.

Question 4

What does the command CREATE DATABASE DatabaseName do?

Answer 4

CREATE DATABASE DatabaseName creates a new database.

Question 5

What does the command DROP DATABASE DatabaseName do?

Answer 5

DROP DATABASE DatabaseName deletes a database, including all tables in the database.

Question 6

What is the purpose of the USE DatabaseName command?

Answer 6

USE DatabaseName selects a default database for use in subsequent SQL statements.

Question 7

What does the command SHOW DATABASES do?

Answer 7

SHOW DATABASES lists all databases in the database system instance.

Question 8

What does the command SHOW TABLES do?

Answer 8

SHOW TABLES lists all tables in the default database.

Question 9

What does the command SHOW COLUMNS FROM TableName do?

Answer 9

SHOW COLUMNS FROM TableName lists all columns in the TableName table of the default database.

Question 10

What does the command SHOW CREATE TABLE TableName do?

Answer 10

SHOW CREATE TABLE TableName shows the CREATE TABLE statement for the TableName table of the default database.