Class 11 IP Chapter 14 Simple Queries in SQL – Solutions – Sumita Arora New Syllabus / Uncategorized / By Neha Ex 14.1 1. Maximum how many characters can be stored in a (i) text literal (ii) numeric literal? ...click here for solutions 2. What is a datatype ? Name some datatypes available in MySQL. ...click here for solutions 3. What are fixed length fields ? What are variable length fields ? ...click here for solutions 4. Compare Char and Varchar datatypes. ...click here for solutions 5. What is null value in MySQL database ? Can you use nulls in arithmetic expressions ? ...click here for solutions 6. Which keyword eliminates the redundant data from a query result ? ...click here for solutions 7. Which keyword retains duplicate output rows in a query result ? ...click here for solutions 8. How would you display system date as the result of a query ? The SQL ...click here for solutions 9 . How would you calculate 13 * 15 in SQL ? To calculate ...click here for solutions 10. Which function is used to substitute NULL values in a query result ? ...click here for solutions 11. Which operator concatenates strings in a query result ? ...click here for solutions 12. Which comparison operator is used for comparing ? ...click here for solutions
