WGU C170 - DATA MANAGEMENT APPLICATIONS C170 study guide
Access plan - correct answer A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. Alias - correct answer An alternative name for a column or table in a SQL statement. ALTER TABLE - correct answer The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics. AREA - correct answer In DB2, a named section of permanent storage space that is reserved to store the database. Atomic attribute - correct answer An attribute that cannot be further subdivided to produce meaningful components. For example, a person's last name attribute cannot be meaningfully subdivided.
Written for
- Institution
- WGU C170 - DATA MANAGEMENT APPLICATIONS
- Course
- WGU C170 - DATA MANAGEMENT APPLICATIONS
Document information
- Uploaded on
- February 10, 2024
- Number of pages
- 15
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
- access plan
- alter table
-
wgu c170 data management applications
-
automatic query optimization
Also available in package deal