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.
Escuela, estudio y materia
- Institución
- WGU C170 - DATA MANAGEMENT APPLICATIONS
- Grado
- WGU C170 - DATA MANAGEMENT APPLICATIONS
Información del documento
- Subido en
- 10 de febrero de 2024
- Número de páginas
- 15
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
Temas
-
access plan
-
alter table
-
wgu c170 data management applications
-
automatic query optimization
Documento también disponible en un lote