Information Technology > EXAM > C170 coaching-Data management exam (All)
PRE-ASSESSMENT: DATA MANAGEMENT - APPLICATIONS (FJO1) PFJO Attempt #1 Status: Not Passed 1. 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? YOUR ANSWER CORRECT ANSWER One-to-one One-to-many Many-to-many One-to-one binary 2. 1/2 Which kind of relationship is displayed in this entity-relationship diagram? YOUR ANSWE R CORRECT ANSWER One-to-one binary One-to-one unary Many-to-many binary Many-to-many unary In this entity-relationship diagram, Salesperson 361 is related to two customers. The table follows the restrict delete rule. What happens if someone tries to delete Salesperson 361 from the customer records? YOUR ANSWE R CORRECT ANSWER The delete is prohibited. The delete occurs immediately. A new salesperson is assigned instead. The lack of a salesperson is flagged for later. 8. Refer to the given SQL statement. CREATE TABLE member CONTINUED.................... [Show More]
Last updated: 3 years ago
Preview 1 out of 60 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Can't find what you want? Try our AI powered Search
Connected school, study & course
About the document
Uploaded On
Apr 20, 2022
Number of pages
60
Written in
All
This document has been written for:
Uploaded
Apr 20, 2022
Downloads
0
Views
52
Scholarfriends.com Online Platform by Browsegrades Inc. 651N South Broad St, Middletown DE. United States.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Scholarfriends · High quality services·