C170

C170 Practice Test Flashcards _ Quizlet

C170 QUESTIONS AND ANSWERS LATEST UPDATE Access plan 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 An alternative name for a column or table in a SQL statement. ALTER TABLE 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 chara...

C170 - PRE-ASSESSMENT QUESTIONS WITH 100% CORRECT ANSWERS { GRADED A+} A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? One-to-one One-to-many Many-to-many One-to-one binary - Many-to-many Which two examples are attributes?

C170 EXAM QUESTIONS WITH 100% CORRECT ANSWERS { GRADED A+} A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? - Many-to-many Which two examples are attributes? - An employee number A meeting code Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table? - Set-to-Null member_id INT UNSIGNED NOT NUL...

Access plan -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 -An alternative name for a column or table in a SQL statement. ALTER TABLE -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 -In DB2, a named section of...

Access plan -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 -An alternative name for a column or table in a SQL statement. ALTER TABLE -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 -In DB2, a named section of...

DATA C170 Coaching Report WGUDATA C170 Coaching Report WGUDATA C170 Coaching Report WGUDATA C170 Coaching Report WGUDATA C170 Coaching Report WGUDATA C170 Coaching Report WGUDATA C170 Coaching Report WGUDATA C170 Coaching Report WGUDATA C170 Coaching Report WGU

Western Governors University - C170 Course Study Glossary of all Chapter Terms