Question

Consider the following table named “BANK” with details of account holders. Write commands in SQL

for (i) and (ii) and outputs for (iii) and (iv).

Table : BANK

AccountNo Name Balance DateOfOpen Transaction

B08432 Mr. Naveen 30000.00 2015-01-10 6

B06714 Mr. Ravi 3800.00 2014-06-12

B04321 Mrs. Anita 24500.35 2014-03-11 8

B1238 Mr. Amit 4600.50 2013-04-10 4

B2436 Mr. Gopal 33546.80 2011-03-25

(i) To display all information of account holders whose transaction value is not mentioned.

(ii) To add another column Address with datatype VARCHAR and size (30).

(iii) SELECT name, Balance FROM BANK WEHRE Name LIKE „% i %‟;

(iv) SELECT ROUND (Balance, −3) FROM BANK WHERE AccountNo = „B2436‟;​

Answer 1

Answer:

Option (iv) is the correct answer

Explanation:

Please mark me as the Brainliest answer