VELS INSTITUTE OF SCIENCE, TECHNOLOGY AND ADVANCED
STUDIES
DEPARTMENT : Department of BCA & IT
SEMESTER V
TITLE OF THE PAPER : Data Analytics using SQL
SUBJECT CODE : 22DBDS51
TIME: 03 Hours Max. Marks: 100
SECTION – A (3 M ARKS)
S. No Questions Unit K-Level CO PO
1. What is a database? I 1 1 PO1,PO3
2. Mention the evolution of database. I 1 1 PO2
3. What is a relational database? I 2 1 PO1,PO3
4. Define a query with example. I 3 1 PO3
5. Define the force of SQL in IT world. I 2 1 PO1,PO2
6. Write the query to display even rows inEmployee I 2 1 PO1,PO3
table?
7. Write the query to create table with same I 4 1 PO3
structure of Employee table?
8. Define T-SQL statements. I 3 1 PO4
9. List the needs of databases? I 1 2 PO2,PO3
10. Define DDL I 2 2 PO2,PO3
11. Define DML. I 1 2 PO3
12. What is TCL? I 1 2 PO5,PO6
13. What is early history of SQL ? I 2 1 PO1,PO3
14. What are the benefits of SQL ? I 2 2 PO1
15. Define JDBC. I 2 1 PO1
16. What are the types of SQL statements? II 1 2 PO2
17. What is structure of SQL query? II 2 2 PO1,P03
18. What is module binding? II 1 2 PO1,PO2
,PO3
19. What is embedded SQL? II 1 2 PO2
20. Define call level interface. II 3 2 PO1,PO2
,PO3
21. What is sql datatype? II 1 2 PO1,PO3
22. What is floating point number? II 1 2 PO3
23. Define datetime syntax. II 2 2 PO3
24. What is numeric constant? II 1 3 PO3
25. What is string constant?. II 1 2 PO2
26. What is date time constant? II 1 2 PO2,PO3
27. Define sql expression. II 1 2 PO3,PO4
28. Define builtin function . II 1 2 PO1,PO2
29. Give example for null value. II 1 2 PO1,PO2
30. Define primary key. II 3 2 PO1,PO2
31. What is the need for types of sql tables?. III 1 4 PO2,PO3
, PO4
32. What is core table? III 1 4 PO2,PO3
, PO4
33. Define lookup table. III 1 4 PO2,PO3
34. What is list table ? III 3 4 PO2,PO3
,PO4
35. Define detail table. III 1 4 PO1,PO3
36. What is cross reference table? III 1 4 PO1,PO3
37. What is the use of create database table? III 1 4 PO2,PO3
, P04
38. What is the use drop query? III 1 4 PO1,PO3
, PO4
39. Mention the example for USE statement. III 1 4 PO2,PO3
40. Write the drop table query. III 1 4 PO2,PO3
,PO4
41. Write the query for index. III 1 4 PO1,PO2
42. Why to use a describe query ? III 1 4 PO1,PO3
,PO4
43. What is a truncate statement? III 1 4 PO1,PO3
44. What is the use of alter query? III 1 4 PO2,PO3
,PO4
45. What is attribute of alter query? III 4 4 PO3
46. Define Sql attributes. IV 1 3 PO1,PO3
47. What is column constraints? IV 1 3 PO1,PO3
48. What is column default value? IV 1 5 PO1,PO2
49. Write the query for alter table . IV 1 5 PO1,PO2
50. Write the select statement uses. IV 1 5 PO2,PO3
51. Define update query. IV 4 5 PO1,PO2
52. Define logical operators. IV 2 5 PO1,PO3
53. Give example for delete query. IV 2 5 PO1,PO2
54. Give example for not null query. IV 3 5 PO1,PO3
55. What is MS ACCESS? IV 1 5 PO1,PO3
, PO5
56. What is user defined datatypes? IV 1 5 PO1,PO3
, PO5
57. List the factors of sql alter query. IV 2 5 PO3,P05
58. Mention the use of rename sql columns. IV 1 3 PO5
59. Give the example of update data query. IV 3 2 PO1,PO2
60. Give the example of multiple row update.
IV 2 5 PO1,PO3
61. Write a query using Have statement. V 1 1 PO1,PO3
,PO5
62. Write a query using Avg function . V 1 1 PO1,PO3
,PO5
63. Write a query using Max function V 1 1 PO1,PO3
64. Write a query using Min function. V 6 2 PO1,PO3
65. Write a query using Except function. V 2 2 PO3
66. Write a query using Count function. V 3 2 PO3
67. Write a query using Sum function. V 2 2 PO1,PO3
68. Write a query using Outer join function. V 1 2 PO1,PO3
,PO5
69. What are the types of outer join? V 1 1 PO1,PO3
70. What is an inner query? V 1 1 PO1,PO3
71. List the advantage of explicit group query? V 1 1 PO3,PO5
72. List the use of union query? V 1 1 PO1,PO3
73. List the use of intersection query. V 1 4 PO1,PO3
,PO5
74. Write the benefits of full outer join. V 1 4 PO3
75. Write the benefits of left ouer join V 1 4 PO3,PO5
SECTION – B (8 MARKS)
[Link] Questions Unit K Level CO PO
76. Explain about any 4 SQL built-in functions with I 3 1 PO1,PO3
examples
77. Explain the use of SQL constants and NULL values I 3 2 PO1,PO3
with examples.
78. Explain about SQL commands can be executed with I 2 2 PO1,PO5
suitable examples
79. Write a code snippet to open database using sqlite3 I 4 6 PO5,PO7
library with table creation.
80. Write down features and benefits of SQL. I 1 2 PO1,PO3
81. Draw the steps of SQL process. I 4 2 PO3
82. With a diagram , explain role of SQL in detail. I 2 1 PO1,PO3
83. Explain the standards of SQL language. I 2 6 PO5,PO7
84. Explain about the concept of networking in SQL. I 4 6 PO5,PO7
85. List out the features of centralized architecture. I 2 6 PO5,PO7
86. Explain Data types in SQL II 2 3 PO1,PO3
87. Explain about the primary and foreign key with II 2 2 PO1,PO3
advantages.
88. Write short notes on the datatypes in sql. II 1 2 PO1,PO2,
PO5
89. List out the advantages of types of sql execution . II 2 2 PO1,PO3
90. Discuss the different types of constants in sql. II 6 2 PO1,PO3
91. Explain the data definition language with example. II 3 6 PO5,PO7
92. Discuss the data manipulation language withexample.. II 2 2 PO3
93. List out the steps in SQL execution of directinvocation . II 3 2 PO3
94. Write short notes on built in functions. II 3 2 PO3
95. With a example explain about the database II 6 2 PO3
expressions.
96. Mention the need for various forms of SQL tables . III 6 4 PO1,PO3
97. Explain about the creation and usage of databases. III 5 4 PO3,PO4
98. Discuss about the creation of employee database III 1 6 PO5,PO7
andqueries.
99. Using an example write the index creation. III 6 4 PO3,PO5
100. Explain about the creation of student table with III 1 4 PO3,PO5
describe statement.
101. Explain about the use of truncate and delete III 1 4 PO1,PO3
Statements
102. Explain in detail various insert into statement. III 1 4 PO1,PO3
103. Write short notes on the SQL column attributes. III 1 4 PO1,PO4
104. Using an example explain about the column III 2 4 PO2,PO3
defaultvalues.
105. With the example, explain about the sql transaction III 1 4 PO1,PO2
Queries
106. Explain various select statement with example. IV 3 5 PO2,PO3,
107. Write about the return of distinct rows. IV 6 5 PO3,PO4,
PO5
108. Write about the aliases in sql statements. IV 3 5 PO3,PO4,
PO5
109. Explain about the logical operations . IV 4 5 PO5,PO7
110. Write the advantages operator precedence. IV 2 5 PO4,PO5,
PO7
111. Write the various math functions. IV 2 5 PO3,PO5
112. With queries , write about the string sql functions.. IV 6 6 PO5,PO7,
113. Explain in detail about trim and length queries. IV 1 6 PO5,PO7
114. Write short notes on absolute and power function. IV 2 4 PO1,PO3
115. Discuss the factors of date functions. IV 4 4 PO1,PO3
116. Compare the equi join and non equi join operations. V 2 1 PO5,PO7
117. Write short notes on join with more than two tables V 2 1 PO3
118. Describe about the cross join in detail. V 5 1 PO3,PO5
119. Explain the grouby operation with sql. V 2 1 PO1,PO3
120. Write short notes on counting resultset . V 1 1 PO1,PO3
121. What does max and min function does? V 1 1 PO1,PO3,
PO5
122. What are the merits of multiple joins? V 1 1 PO1,PO3
123. Using the full outer join explain with example. V 2 4 PO1,PO3
124. List the uses of Union ,intersection operations V 2 6 PO5,PO7
125. Explain in detail user defined and default data types. V 6 4 PO5,PO7
SECTION – C (15 MARKS)
S. No Questions Unit K Level CO PO
126. Explain about SQL builtin functions in detail. I 1 1 PO1,PO3
,PO5
127. Explain about the history and evolution of SQL in detail I 2 2 PO1,PO3
128. Explain about different types of database architecture I 2 2 PO1,PO3
in detail.
129. Explain in detail the data warehouse with example. I 1 6 PO5,PO7
130. With suitable example explain about OLAP with real I 4 6 PO5,PO7
time example.
131. Explain in detail the concept of OLTP applications. II 5 2 PO3,PO5
132. Explain the different types of SQL execution in detail. II 5 2 PO1,PO3
133. Explain about the various constants in SQL. II 2 2 PO1,PO3
134. Explain in detail with the process bulitin function. II 3 6 PO5,PO7
135. With an example explain in detail sql datatypes. II 2 6 PO5,PO7
136. Explain about the types of SQL tables. III 2 6 PO5,PO7
137. Compare Lookup and core tables with example. III 1 4 PO3,PO5
138. Explain about the database object creations with III 4 6 PO5,PO7
example.
139. Using an example explain in detail table operations. III 4 6 PO5,PO7
140. Explains in detail the linear various insert into queries. III 6 4 PO1,PO3
141. Explain about the different logical operators and IV 2 6 PO5,PO7
precedence.
142. Write the advantages of ordering results with recordset. IV 5 6 PO5,PO7
143. Write the various date functions with example. IV 5 6 PO5,PO7
144. Describe about the string functions with example. IV 3 5 PO1,PO3
145. Compare and contrast ordering and grouping IV 4 6 PO5,PO7
Functions
146. With an example explain the concept of join queries in V 2 6 PO7
detail .
147. Explain the concept of data aggregation in detail. V 2 5 PO1,PO3
148. Compare inner and outer join sql statement with V 6 6 PO3
example.
149. Write the advantages of Equijoin, non-equijoin, union V 6 6 PO7
statements.
150. Explain the relationship between parent and child V 6 4 PO5,PO7
Queries.
K1- Remember; K2- Understand; K3- Apply;
K4- Analyze; K5-Evaluate; K6-Create