Which of the following statements will prevent you from getting error messages if a database with the given name already exists on the database server?

You work as a Database Administrator for Domain.com. The company uses MySQL as the
database development platform. You have created a database named Employee. Which of the

following statements will prevent you from getting error messages if a database with the given
name already exists on the database server?

You work as a Database Administrator for Domain.com. The company uses MySQL as the
database development platform. You have created a database named Employee. Which of the

following statements will prevent you from getting error messages if a database with the given
name already exists on the database server?

A.
CREATE DATABASE NOT EXISTS Employee;

B.
CREATE DATABASE NONAME EXISTS Employee;

C.
CREATE DATABASE IF NONAME EXISTS Employee;

D.
CREATE DATABASE IF NOT EXISTS Employee;



Leave a Reply 0

Your email address will not be published. Required fields are marked *