Which three database objects have non-case-sensitive names on all operating system?
A.
Table
B.
Column
C.
Index
D.
Stored procedure
E.
Trigger
Which three database objects have non-case-sensitive names on all operating system?
Which three database objects have non-case-sensitive names on all operating system?
I think BCDE
BCD without E ( three objects)
Column, index, and stored routine names are not case sensitive on any platform, nor are column aliases. Trigger names are case sensitive.
BCD
BCD
https://dev.mysql.com/doc/refman/5.6/en/identifier-case-sensitivity.html
Column, index, stored routine, and event names are not case sensitive on any platform, nor are column aliases.
Note
Although database, table, and trigger names are not case sensitive on SOME platforms, you should not refer to one of these using different cases within the same statement. The following statement would not work because it refers to a table both as my_table and as MY_TABLE:
B C D
Table and Triggers are partially case-sensitive on some platforms.
BCD