C175 Test Questions with 100% Correct Answers
When during ETL are raw data sets aggregated?
Transformation
What is data?
Numeric, text, visual, audio, that describes realworld systems.
What does DBMS do?
Reads and writes data, ensures data is secure, consistent and available.
What is a database ?
Structured format of data collection.
What's is the conceptual design?
Specifies database requirements.
What is a logical design?
Implements database requirements.
What is physical design?
Indexes and specifies how table is designed, can affect performance but not results.
What are the 3 rules a table must obey?
1. Tables must be normalized
2. No duplicate column names.
3. No duplicate rows
Drop table does?
When during ETL are raw data sets aggregated?
Transformation
What is data?
Numeric, text, visual, audio, that describes realworld systems.
What does DBMS do?
Reads and writes data, ensures data is secure, consistent and available.
What is a database ?
Structured format of data collection.
What's is the conceptual design?
Specifies database requirements.
What is a logical design?
Implements database requirements.
What is physical design?
Indexes and specifies how table is designed, can affect performance but not results.
What are the 3 rules a table must obey?
1. Tables must be normalized
2. No duplicate column names.
3. No duplicate rows
Drop table does?