You have been tasked to create a table for a banking application.One of the columns must meet three requirements:1. Be s

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You have been tasked to create a table for a banking application.One of the columns must meet three requirements:1. Be s

Post by answerhappygod »

You have been tasked to create a table for a banking application.One of the columns must meet three requirements:1. Be stored in a format supporting date arithmetic without using conversion functions2. Store a loan period of up to 10 years3. Be used for calculating interest for the number of days the loan remains unpaidWhich data type should you use?

A. INTERVAL YEAR TO MONTH
B. INTERVAL DAY TO SECOND
C. TIMESTAMP WITH LOCAL TIMEZONE
D. TIMESTAMP E. TIMESTAMP WITH TIMEZONE
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply

Return to “Archived Questions & Answers”