Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What is the difference between using the LOCATION keyword when creating a database versus a table?
A
Using the LOCATION keyword with CREATE TABLE marks the table as unmanaged, while with CREATE DATABASE, it specifies where the database's tables will be stored.
B
The LOCATION keyword cannot be used with CREATE DATABASE but can be used with CREATE TABLE.
C
Using the LOCATION keyword has no effect whether it's used with CREATE TABLE or CREATE DATABASE.
D
Using the LOCATION keyword with either CREATE TABLE or CREATE DATABASE marks them as unmanaged or external.
E
Using the LOCATION keyword with CREATE DATABASE marks it as unmanaged, while with CREATE TABLE, it marks the table as managed.
