| MAGNUS23 2003-07-10, 5:45 am |
| Hi ALL!
I recieved this practice question today(usual subscription) and i'm in doubt about it. Can anybody explain this to me please?
My doubt is "hardware specification" answer.
I didn't found nothing like that in BOL or MS Press... And explanation here is not saying nothing about it, but it is counted as one of a correct answers. IS that right?
How we can manage hardware specification using DDL ? 
Is that what i can encounter on a real exam?
Thanks in advance.
Question ID:70-229qod5
Data definition language is used to define and manage all attributes and properties of a database, including which of the following (Choose all that apply)?
A) row layouts
B) column definitions
C) key columns
D) file locations
E) storage strategy
F) hardware specification
Correct answer: ABCDEF
Explanation:
According to the MS Press 70-229 Training Kit:
Data definition language, which is usually part of a database management system, is used to define and manage all attributes and properties of a database, including row layouts, column definitions, key columns, file locations, and storage strategy. A DDL statement supports the definition or declaration of database objects such as databases, tables, and views. The Transact-SQL DDL used to manage objects is based on SQL-92 DDL statements (with extensions). For each object class, there are usually CREATE, ALTER, and DROP statements (for example, CREATE TABLE, ALTER TABLE, and DROP TABLE). |