AIncorrect Answer

This is the second-best answer. Although true by default, you can GRANT other users access to your tables. Anyway, this would not help you make sure your table name was unique.

close

BIncorrect Answer

Tables are stored centrally in the DBMS, not on each user's disk space. Even so, it would not have helped you ensure that your tables have a unique name.

close

CIncorrect Answer

I made this up. The DBA can control access and permissions to tables which exist, not ones which may exist in the future.

close

DCorrect Answer

Table names are automatically added to the start of tablenames you specify, so that "tablea" would become "jbloggs.tablea", provided your username was jbloggs. This helps you use your own tablenames locally, without having to worry to much about other users.

close

EIncorrect Answer

If this was true, how would you find out the name of the table you just created? It would be highly inconvenient, especially if the creation of the table was just part of a larger SQL program.

close

A B C D E TELL ME NEXT INDEX
 
 
Table and view names are unique in the database. To make this easier,
  1. Table names are only viewable by the person who created them.
  2. Tables are stored on each user's own disk space.
  3. The DBA can make creating tables with certain strings in the name password protected.
  4. Table names have their creator's user name prepended to the table name.
  5. A table created with the same name as another table is automatically renamed to make it unique.