The above CREATE TABLE statement is acceptable, and will create a Table named bioclass that contains a hire_date, first_name and last_name column. True or False?
Mark for Review (1) Points
True (*)
False
Correct
4.
When creating a new table, which of the following naming rules apply: (Choose three)
Mark for Review (1) Points
(Choose all correct answers)
Must begin with a letter (*)
Can have the same name as another object owned by the same user
Must contain ONLY A - Z, a - z, 0 - 9, _ (underscore), $, and # (*)
An external table with the data stored in a file outside the database. (*)
A View.
An external table with the data stored in a file inside the database.
None. This is in invalid statement.
7.
I have a table named School_Friends in my schema. You want to build a table in your schema named School_Friends. This is ______________, because ____________________________________.
Mark for Review (1) Points
possible; my schema is separate from yours, and it is okay for us to have like-named tables in our separate schemas. (*)
possible; our data will merge into one table, and we can more easily access our mutual friends information.
impossible; no matter what, there can never be two tables with the same name, even if they are in separate schemas.
impossible; School_Friends is a reserved term in SQL.
Correct
8.
DCL, which is the acronym for Data Control Language, allows:
Mark for Review (1) Points
the ALTER command to be used.
a Database Administrator the ability to grant privileges to users. (*)
the TRUNCATE command to be used.
the CONTROL TRANSACTION statement can be used.
Correct
9.
It is possible to create a table by using the CREATE TABLE command in conjunction with a subquery. True or False?
felicitari, arata mult mai bine asa cum ii acum, da si inainte se intelegea perfect! Daca treci prin Deva da un buzz si dau o bere
RăspundețiȘtergereok! o sa dau un "buzz" asta daca nu uit :))
RăspundețiȘtergere