DBMS - W3 Naming Conventions

1 to 255

64

Aliases must be from __ to characters long. All other identifier names must be from 1 to characters long.

period, a backward slash (\), or a forward slash (/).

Database names can use any character that is allowed in a directory name except for a __,___,___

default

quotation marks.

By ____, MySQL encloses column names and table names in ____

Table names

period or forward slash.

___ can use any character that is allowed in a file name except for a ___ or a ___.

32

table view.

Table names must be __ characters or less because SAS does not truncate a longer name. If you already have a table name that is greater than 32 characters, it is recommended that you create a ___

Column

alias

____ names and ____ names allow all characters.

Embedded

enclose

quotation marks

_____ spaces and other special characters are not permitted unless you ___ the name in ____

quotation marks

Embedded ___ are not permitted.

Case sensitivity

UNIX

Windows

____ is specified when a server is installed. By default, the names of database objects are case sensitive on ___ and not case sensitive on ___. For example, the names CUSTOMER and Customer are different on a case-sensitive server

reserved

A name cannot be a ____ word in MySQL unless you enclose the name in quotation marks.

unique

Database names must be ___. For each user within a database, names of database objects must be unique across all users