CLASS- XII
COMPUTER SCIENCE (Code -083)
Ch 12: MySQL SQL
Assignment-3
Q1. ………………….functions operates on a single value to return a single value.
(a) Multiple row (b) Aggregate
(c) Single (d) Summation
Q2. Which is not a single row function?
(a) Numeric functions (b) String functions
(c) Date & time functions (d) Aggregate functions
Q3. Select CHAR(65, 65.1, 65.2) will display the output:
(a) ABC (b) AAB
(c) AZY (d) AAA
Q4. SELECT CONCAT(CONCAT(ENAME,” IS A” ),JOB) FROM EMP WHERE EMPNO =
7369;will display the output.
(a) CONCAT ENAME IS A JOB (b) CONCAT SMITH IS A JOB
(c) SMITH IS A MANAGER (d) SMITH IS A CLERK
EMPNO ENAME JOB MGR HIREDAT SAL COMM DEPTN
E O
7369 SMITH CLERK 7902 1980-12-17 800.00 NULL 20
7499 ALLEN SALESMAN 7698 1981-02-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-02-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-04-02 2975.00 NULL 20
7654 MARTIN SALESMAN 7698 1981-09-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-05-01 2850.00 NULL 30
7782 CLARK MANAGER 7839 1981-06-09 2450.00 NULL 10
7788 SCOTT ANALYST 7566 1982-12-09 3000.00 NULL 20
7839 KING PRESIDENT NULL 1981-11-17 5000.00 NULL 10
7844 TURNER SALESMAN 7698 1981-09-08 1500.00 0.00 30
7876 ADAMS CLERK 7788 1983-01-12 1100.00 NULL 20
7900 JAMES CLERK 7698 1981-12-03 950.00 NULL 30
7902 FORD ANALYST 7566 1981-12-03 3000.00 NULL 20
7934 MILLER CLERK 7782 1982-01-23 1300.00 NULL 10
Q5. SELECT LOWER(CONCAT(ENAME, JOB) FROM EMP WHERE EMPNO = 7934; will
give the output.
(a) MILLER CLERK (b) Miller Clerk
(c) millerclerk (d) MillerClerk
1
Q6. SELECT UPPER(LOWER(“FORD”)) will display the out put.
(a) FORD (b) Ford
(c) ford (d) fORD
Q7. SELECT SUBSTRING('Quadratically',5); will display the out put.
(a) ratically (b) Quadr
(c) cally (d) none of the above
Q8. SELECT SUBSTRING('foobarbar' FROM 4); will display the out put.
(a) 'barbar‟ (b) 'barba
(c) barbar (d) rbar
Q9. SELECT SUBSTRING('Sakila', -3);will display the out put
(a) 'Sa (b) Sak
(c) ali (d) ila
Q10. SELECT SUBSTRING('Sakilakumari', -5, 3); will display the out put
(a) lik (b) uma
(c) aku (d) none of the above
Q11. SELECT SUBSTRING('Sakilakumari'FROM -4 FOR 2); will display the out put
(a) ma (b) la
(c) ik (d) amuk
Q12. ………………. Function removes trailing & ………………. Function removes leading
spaces.
(a) LTRIM, RTRIM (b) RTRIM, LTRIM
(c) LTRIM, TRIM (d) RTRIM, TRIM
Q13. SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx');will display the out put.
(a) barxxx (b) xxxbar
(c) bar (d) None
Q14. Write a query to remove leading and trailing x characters from string „xxxbarxxx‟.
(a) Select TRIM(BOTH „x‟ FROM „xxxbarxxx‟);
(b) SELECT LTRIM(RTIM(„xxxbarxxx‟, „x‟));
(c) Select TRIM(LEADING „x‟ FROM „xxxbarxxx‟);
(d) Select TRIM(TRAILING „x‟ FROM „xxxbarxxx‟);
2
Q15.Which function returns the position of the first occurrence of substring substr in string str.
(a) SUBSTR (b) INSTR
(c) MID (d) TRUNCATE
Q16. Which SELECT statement wills the result 'ello world' from the string 'Hello World'?
(a) SELECT INITCAP (TRIM ('Hello World',1,1);
(b) SELECT LOWER (SUBSTR ('Hello World',1,1);
(c) SELECT LOWER (SUBSTR ('Hello World',2,1);
(d) SELECT LOWER (TRIM ('H' FROM 'Hello World'));
Q17. SELECT INSTR('foobarbar', 'bar');will display the output.
(a) 3 (b) 4 (c) 2 (d) 0
Q18. SELECT LENGTH(SUBSTRING('foobarbar' FROM 4));will display the output.
(a) 5 (b) 6 (c) 4 (d) 7
Q19. SELECTLEFT('foobarbar', -5);will display the output.
(a) fooba (b) arbar
(c) rabra (d) no out put will display
Q20. Which function returns the specified rightmost number of characters?
(a) LTRIM (b) RTIM
(c) LEFT (d) RIGHT
Q21. Which function is a synonym of SUBSTR( )?
(a) INSTR (b) MID
(c) TRUNCATE (d) NONE
Give the output of following statement using EMP table. The structure of EMP table is
described below and answer:
EMPNO ENAME JOB MGR HIREDAT SAL COMM DEPTN
E O
7369 SMITH CLERK 7902 1980-12-17 800.00 NULL 20
7499 ALLEN SALESMAN 7698 1981-02-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-02-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-04-02 2975.00 NULL 20
7654 MARTIN SALESMAN 7698 1981-09-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-05-01 2850.00 NULL 30
7782 CLARK MANAGER 7839 1981-06-09 2450.00 NULL 10
7788 SCOTT ANALYST 7566 1982-12-09 3000.00 NULL 20
7839 KING PRESIDENT NULL 1981-11-17 5000.00 NULL 10
7844 TURNER SALESMAN 7698 1981-09-08 1500.00 0.00 30
3
7876 ADAMS CLERK 7788 1983-01-12 1100.00 NULL 20
7900 JAMES CLERK 7698 1981-12-03 950.00 NULL 30
7902 FORD ANALYST 7566 1981-12-03 3000.00 NULL 20
7934 MILLER CLERK 7782 1982-01-23 1300.00 NULL 10
Q22. SELECT MOD(SAL,COMM) FROM EMP WHERE EMPNO =7499;will display the
output.
(a) 1 (b) 100 (c) 200 (d) 0
Q23. SELECT POWER(COMM,2) FROM EMP WHERE EMPNO =7499;will display the
output.
(a) 300 (b) 900 (c) 60000 (d) 90000
Q24. SELECT ROUND(SAL,-2) FROM EMP WHERE EMPNO = 7521;will display the
output.
(a) 1250 (b) 1200
(c) 1300 (d) 1000
Q25. SELECT ROUND(145.2356,-2), ROUND(145.2356,2); display the out put
(a) 145.23, 145.24 (b) 100.23, 145.23
(c) 100, 145.23 (d) 100, 145.24
Q26. SELECT TRUNCATE (122.796, 2), TRUNCATE (122.796, -2); display the output.
(a) 100, 122.79 (b) 122.79, 100
(c) 122.78, 100 (d) 100, 122.78
Q27. Date & Time function allow us to manipulate on……………… type data.
(a) Numeric type (b) String type
(c) Date type (d) All of the above
Q28. Select DAYOFMONTH(„2013-01-30); display the output.
(a) 01 (b) 2013 (c) 30 (d) Wednesday
Q29. Write a query to display the current date & time.
(a) SELECT NOW(); (b) SELECT DATETIME();
(c) SELECT DATE(); (d) SELECT TIME();
Q30. Which function returns the name of the weekday.
(a) DAYOFWEEK() (b) DAYNAME()
(c) DAY() (d) NOW()
4
Answers Answers
Q. No.
1 c
2 d
3 d
4 d
5 c
6 a
7 a
8 c
9 d
10 b
11 a
12 b
13 c
14 a
15 b
16 d
17 b
18 b
19 d
20 d
21 b
22 b
23 d
24 c
25 d
26 b
27 c
28 c
29 a
30 b
