When creating customers, multiple users could be creating new customers at the same time. However, each customer created will be assigned a unique customer number. Which of the following ACID properties apply in this situation? (Select all that applies)Group of answer choicesConsistency – following a rule within the system that no two customers can have the same customer numberAtomicity – everyone is assigned a customer number, or no one is assigned a customer numberDurability – ensuring that customer data that has been created is savedIsolation – if two customers are created at the same time, ensure each customer is assigned a unique customer number

In creating purchase orders, multiple users could be creating new purchase orders at the same time. However, each purchase order will be assigned a unique purchase order number. Which of the following ACID properties apply in this situation? (Select all that applies)Group of answer choicesIsolation – if two purchase orders are created at the same time, ensure each purchase order is assigned a unique numberDurability – ensuring that the purchase order that has been created is savedConsistency – following a rule within the system that no two purchase orders number can have the same purchase order numberAtomicity – everyone is assigned a purchase order number, or no one is assigned a purchase order number

Question:-Which of these is/are called Characteristics of the customer-centric organizations : (i) Use customer data to better understand and segment the customer base (ii).Engage with customers only at the beginning (iii).Measure what matters to customersChoices:- i only ii only i and iii only All of the aboveSave AnswerSkip this questionFinish Exam

Consider the creation of the following table: Customer(CustId, AccountNo, CustName) with combination of columns Custid and AccountNo should be UNIQUE. Which one of the following options is CORRECT?Put UNIQUE constraint on both the columns separatelyThis type of constraint is not possiblePut PRIMARY KEY constraint on both the columns separatelyPut a table level UNIQUE constraint involving both the columns

A database administrator is setting up a new table that will contain customer information. The fields include name, address, company, phone, email, and customer ID. The administrator is using the customer ID to uniquely identify each customer record. Which of the following BEST describes the customer ID field?answerForeign keyPublic keyPrimary keyPrivate key

Question 13 Question 13 of 13 5 pointsSave Answ Acme Realty employs a number of sales representatives, each of whom managesone or more of Acme's customers. Their database has the following tables. SalesRep (repIdrepName)Customer (custId, custName, salesRep, priority) Each row of the SalesRep table gives the unique id and the name of one ofAcme's sales representatives. Each row of the table Customer stores information about one customer, including a unique customer id, and the name of thecustomer. The third column, salesRep, contains the id of the sales representative who deals with that customer. The final column priority indicates thepriority of the customer, taking one of the values low or high, depending onhow valuable the customer is to Acme. You may assume that every sales rephas at least one customer, and that the priority is never NULLWhat does the following query return? SELECT S.repName FROM SalesRep SWHERE NOT EXISTS (SELECT * FROM Customer CWHERE C.salesRep = S.repIdAND C.priority = 'high'); The names of the reps with customers of only one priority The names of the reps who only have high-priority customer The names of the reps with at least one high-priority custome O The names of the reps who only have low-priority customers The names of the reps with at least one low-priority custome