Scribd
Upload
4 views3 pages

SQL and Networking Concepts Explained

The document consists of a series of questions divided into five parts, covering topics related to SQL functions, data types, networking concepts, and statistical calculations. Each part requires answers to a specified number of questions, with varying marks assigned based on the complexity of the questions. Topics include SQL commands, network types, data communication, and statistical techniques for analyzing student marks.

Uploaded by

memegalaxy015
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views3 pages

SQL and Networking Concepts Explained

The document consists of a series of questions divided into five parts, covering topics related to SQL functions, data types, networking concepts, and statistical calculations. Each part requires answers to a specified number of questions, with varying marks assigned based on the complexity of the questions. Topics include SQL commands, network types, data communication, and statistical techniques for analyzing student marks.

Uploaded by

memegalaxy015
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

PART B

III. Answer any FOUR questions Each question Carries TW O mark s 4X2=8

21. describe insert() function in MYSQL

22. Define the char and varchar data type. How do they differ?

23. Describe any 2 clause in SQL?

A)where clause. B)Distinct clause

24. W hat is URL? explain.

25. List out any two example of network in daily life.

26. W rite a short note on HTTP.

27. W hat is protocol? need for protocol.

PART C

[Link] any FOUR questions Each question Carries THREE mark s 4X3=12

28. W hat is aggregate function explain?

[Link] DDL command syntax with example

30. Explain operational and relational

a) union b) insertion c) Cartesian product

31. W hat is single drop function in SQL explain its categories

32. W hat is the significance of MAC address.

33. Explain domain name system and DNA server

34. Explain TCP/IP, FTP, SMTP protocols

PART D

[Link] any FOUR questions Each question Carries FIVE mark s 4X5=20

35. explain prototype of radio, micro, infrared wireless transmission media.


36. Explain the type of network s.

37. Explain different device in computer network


38. what is topology explain in detail

39. what is switching techniques explain type of switching.

40. explain type of data communication.

41. explain twisted pair cable co-axial cable and optical fibre and wire transmission media.

PART E

[Link] any TW O questions Each question Carries FIVE mark s 5X2=10


42. Consider the mark s scored by students in a subject given [90, 80, 70, 95, 95, 85, 80] Calculate the

statistical technique for the following:

a) Find the range of mark s scored

b) Find the standard deviation of mark s


c) Find the average of mark s score
[Link] Name: MOVIE

Attributes: MovieID, Movie Name, Category, Release Date, ProductionCost, BusinessCost

a. Assuming suitable data type create the table MOVIE.

b. Add four records into it with suitable SQL command.

c. W rite SQL command to display MovieName with alias NAME

d. W rite SQL command to display the total production cost and business cost.

e. W rite SQL command to list the distinct categories of movies.

44. W rite SQL commands for questions (a) to (e) based on data given in the

EMPLOYEE table given below.


ID NAME DOB DEPARTMENT SALARY GENDER

111 AAA 01- 08- 1998 ACCOUNTS 156780 M

222 BBB 12- 12- 2000 HR 199950 F

1010 CCC 23- 06- 2000 SALES 140000 F

5456 ZZZ 01- 01- 2002 PRODUCTION 250000 M

7272 DDD 11- 01- 2001 ACCOUNTS 180000 M

3486 LLL 08- 0801998 HR 200000 M

a. Display information of all the employees in ascending order of their date of birth

b. To Compute the average salary of all the employees

c. To Display count of employees work ing in various departments

d. Command to Calculate the total salary of all the employees.


e. Generate report of employees whose salary is in the rangE 150000 and 200000.

You might also like