Question: Question 15 TABLE: CUSTOMER Not yet answered CUST ID NAME PHONE POSTAL CODE Marked out of 3.00 1 Taylor Swift 3126557888 34500 P Flag question

Question 15 TABLE: CUSTOMER Not yet answered CUST ID NAME PHONE

Question 15 TABLE: CUSTOMER Not yet answered CUST ID NAME PHONE POSTAL CODE Marked out of 3.00 1 Taylor Swift 3126557888 34500 P Flag question 2 Shawn Mendes 3456678891 13150 3 Angelina Jolie 6998552211 03150 11 Brad Pitt 5564876522 65410 21 Kathy Perry 4775521133 64700 Which of the following statements are TRUE if CUST_ID is set to character data type? 1. Can perform mathematical operations based on CUST_ID. II. Queries involving CUST_ID will be processed quicker. III. Sorting CUST_ID will follow the numerical order. IV. CUST_ID can store leading zeros. V. Comparison between two values in CUST_ID will be based on the numeric codes of the characters in the database character set. II, IV and V II and IV I and III II, III and IV

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

QUESTION 1 Use the following scenario and data for all questions An auto service center provides two types of services, Tire Replacement (T) and Oil Change (O). About 30% of the customers are for...

Use the following scenario and data for all questions An auto service center provides two types of services, Tire Replacement ( T ) and Oil Change (O). About 30% of the customers are for Tire...

QUESTION 1 Use the following scenario and data for all questions An auto service center provides two types of services, Tire Replacement (T) and Oil Change (O). About 30% of the customers are for...

Use the following scenario and data for all questions An auto service center provides two types of services, Tire Replacement (T) and Oil Change (O). About 30% of the customers are for Tire...

For customer arrivals, the random number interval assigned to the Time between Arrivals of 5 minutes is 0.0000-0.1499 0.1500-0.3999 0.4000-0.7999 0.8000-0.9999 None of the above QUESTION 2 For...

Please help me with the following QUESTION 15 For customer 15, the time between arrivals and the time of arrival are, respectively, 10 and 160 100 and 160 10 and 125 10 and 150 None of the above...

Question 1 (1 point) Saved In the early 1920s, Ford promised its customers that they could have any colour car they wanted, "as long as it was black." Ford's management assumed anyone buying a car...

re answering the following questions, you may use the following tables to determine the cumu = = = For customer 10 , the service type and time needed are, respectively, O and 20 O and 25 T and 20 T...

Use the following scenario and data for all questions come first served basis. During regular hours, customers arrive at the service center according to the probability distribution in the following...

Question 1: Which of the following is an example of a contra revenue account? sales discounts accounts payable sales merchandise inventory Question 2 What accounts are used to recognize a retailer's...

A salt-gradient solar pond is a shallow body of water that consists of three distinct fluid layers and is used to collect solar energy. The upper- and lower-most layers are well mixed and serve to...

Three different plans for financing a $27,000,000 corporation are under consideration by its organizers. Under each of the following plans, the securities will be issued at their par or face amount,...

Question 1 3 0 . 1 6 pts What is the percentage point difference ( spread ) between the expected return in the stock market and the mortgage interest rate? Note: Spread = ( expected return in the...

On a disk read operation, the device driver first checks if the data is already available in the buffer cache. True False