Page 1 of 1
14. Character data type can be stored as A. Fixed length string B. Variable length string C. Either Fixed or Variable le
Posted: Fri Jul 08, 2022 6:44 am
by answerhappygod
- 14 Character Data Type Can Be Stored As A Fixed Length String B Variable Length String C Either Fixed Or Variable Le 1 (116.56 KiB) Viewed 50 times
14. Character data type can be stored as A. Fixed length string B. Variable length string C. Either Fixed or Variable length string D. Integer 15. SELECT a.branch_name, COUNT (d.customer_name) AS count FROM account a, depositor d WHERE a.account_number= d.account_number GROUP BY a.branch_id; A. The query is missing "Having" clause B. The query is syntactically incorrect C. The query is syntactically correct D. The query contains incorrect join. 16. A domain is atomic if elements of the domain is considered A. Different B. Indivisible C. Constant D. Divisible 17. Person table has PK personid with values of 1, 2, 3 and 4. "DELETE from Person WHERE personid = 2". How many rows will be deleted when you run above SQL? A. 0 B. 1 C. 2 D. None of the above units. 18. Which of the following clause must be present with 'HAVING' clause in SQL? A. Group by B. Where C. Order by D. None of the above