Enrollment No.
NAVRACHAUA
UHIVERSITY
School: School of Engineering and Technology
Programn/s: [Link]-CSE
Year: 1t Semester: 2nd
Examination: End Semester Examination
Examination year: May-2024
Course Code: CS157 Course Name: Web Technology
Total Marks: 40
Date: 16/05/2024 Total Pages: 02
Time: l1:00 AM to 01:00PM
Instructions:
Write each answer on anew page.
*COs=Course Outcome mapping. # BTL=Bloom's Taxonomy Level mapping
Marks CO BTL
Q. Details
No.
08
Q.I Doas Directed (All are compulsory) C04 BT2,
1) What is DBMS? BT3
a) DBMS is a collection ofqueries
b) DBMS is a high level language
c) DBMS is a programming language
d) DBMS stores, modifies and retrieves data
CO5 BT2,
2) Which command is used to create the first project in Django? BT3
a) django-admin startproject project_name
b) django-admin startapp project_name
c) django-admin create project_name
d) django-admin createproject project_name
1 CO3 BT2,
3) Which plugin is used to cycle through elements, like a slideshow? BT3
a) Tooltip Plugin b) Modal Plugin c) Carousel Plugin d)None
CO5 BTI
4) In Django, data is created in objects, what are these objects called
a) views b) models c) templates d) database
CO4 BTI
5) In SQL, Delete command is used for deleting the table. True/False
BT2,
BT4
CO3 BT1,
6) Document object is a part of Window object. True/False
BT2
and in SQL. C04 BT3,
7) Primary keys are BT4,
BTS
C04 BT3,
8) Write a SQL query that will select the City column from the Customers table. BT4,
Q.2 Long Answer Type Questions (Attempt any 5)
25
1. Enlist the features of Django. Explain the MVT Architecture
with neat diagram. CO5 BT1,
BT2,
BT3
2. Explain HTML DOM and discuss HTML DOM methods used to find HTML CO3 BT1,
Elements. BT2,
BT3
3. What is SQL Join? Explaintypes of Join with suitable examples. C04 BT1,
BT2,
BT3
4. What is Cookies? Explain types and limitation of cookies. CO3 BT1,
BT2,
BT3
5. Write the following queries 5 CO4 BT2,
Table Name: Employee BT3,
BT4
ElD Name City Salary
E101 Preksha Vadodara 55000
E102 Jolly Ahmedabad 52000
E103 Atharv Surat 40000
E104 GauraV Vadodara 25000
E105 Kaksha Anand 33000
1) Give the maximum salary from employee table.
2) Display the employee details whose second last character is "h".
3) Display the Employee name whose Salary is between 40000 to 60000.
4) Display the employee detailswhose not belongs to Vadodara city.
5) Increase the salary by 5000 whose belongs to the Ahmedabad City.
C04 BT1,
6. What is Integrity Constraints in SQL? Explain types of Integrity Constraints with
BT2,
suitable example. BT3
Q.3 Write the JavaScriptprogram for following problem statement. (Attemptany 1 ) 07
1. Design a login form using HTML & JavaScript with following validations on 7 CO3 BT3,
BT4,
username and password fields. BTS,
[Link] length must be 6 to 12 characters BT6
2. Username should not start with underscore, @ or number.
3. Both should not be blank.
CO3 BT3,
2. Write aJavaScript to check input string is palindrome or not. BT4,
Note : Apalindrome is a word that reads the same backwards as forwards, such BTS,
as madam. BT6
************End of Ouestion Paper************