WGU C175 DATA MANAGEMENT FOUNDATIONS QUESTIONS WITH VERIFIED ANSWERS

WGU C175 DATA MANAGEMENT FOUNDATIONS QUESTIONS
WITH VERIFIED ANSWERS




Correct 115

Incorrect 00




1 of 115

Term



The SQL SELECT command is used to ___ a relational database.


a) retrieve data from
b) update records in
c) insert new records into
d) delete records from
e) None of the above.



Give this one a try later!



C D




B A

, Don't know?




2 of 115

Term



A table can be deleted from the database by using the ___ command.


a) DROP
b) DELETE
c) MODIFY
d) ERASE



Give this one a try later!



A D




C B


Don't know?




3 of 115

Term



Problems caused by two or more users trying to update the same data
simultaneously fall primarily under the heading of_ _.

,a) computer security
b) backup and recovery
c) concurrency control
d) integration control
e) access control


Give this one a try later!



C A




E D


Don't know?




4 of 115

Term



A foreign key must ____.


a) be numeric
b) be unique
c) be defined in all tables within the database
d) match the value of a primary key in a related table



Give this one a try later!



D C

, A B


Don't know?




5 of 115

Term



Which type of relationship exists between Student and Course?


a) One-to-many binary
b) Many-to-many binary
c) One-to-many unary
d) Many-to-many unary



Give this one a try later!



A B




C B


Don't know?




6 of 115

Term