Download App

Structured Query Language (SQL) – II — Computer Science STD 12 Science — Question

CBSE BoardEnglish MediumSTD 12 ScienceComputer ScienceStructured Query Language (SQL) – II4 Marks
Question

Write the output for the following commands:

Table- Loan_accounts

account cust_name loan_amount installment int_rate start_rate interest
1 R.K. Gupta 300000 36 12.00 2009-07-19 Null
2 S.P. Sharma 500000 48 10.00 2008-03-22 Null
3 K.P. Jain 300000 36 Null 2007-08-03 Null
4 M.P. Yadav 800000 60 10.00 2008-12-06 Null
5 S.P. Sinha 200000 36 12.50 2010-01-03 Null
6 P. Sharma 700000 60 12.50 2008-06-05 Null
7 K.S. Dhall 500000 48 Null 2008-03-05 Null

(a)

(b)

(c)

(d)

(e)

✓

Answer

(a)

(b)

(c)

(d)

(e)

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free

Explore more

More "4 Marks Each" from Structured Query Language (SQL) – II→Structured Query Language (SQL) – II — all question types→Computer Science STD 12 Science question papers→CBSE Board STD 12 Science question papers→CBSE Board question paper generator→

Similar questions

Write a menu driven python program using function InQ(), DelQ() and DisplayQ() to implement the Queue. The program will store the name of the books.
→
How can we convert a Series to DataFrame?
→
Write a python program using function to accept the list as parameter and print the odd element of the list.
→
Write a python program using function to print the sum of first n natural numbers. 
→
Write a function search () to search a record in a binary file according to the student number entered by the user. Also display the message “Record not found” in case record not found in the file.
→
Describe Data Operations in Pandas.
→
Trine Tech Corporation (TTC) is a professional consultancy company. The company is planning to set up their new offices in India with its hub at Hyderabad. As a network adviser, you have to understand their requirement and suggest them the best available solutions. Their queries are mentioned (a) to (d) below.

Block to Block distances (in Mtrs.)

FROM To Distance
Human resource Conference 110
Human resource Finance 40
Conference Finance 80

Number of computers in each of the blocks/Center is as follows:

Human resource 25
Finance 120
Conference 90

(a) What will be the most appropriate block, where TTC should plan to install the server?

(b) Draw a block to block cable layout to connect all the buildings in the most appropriate manner for efficient communication.

(c) What will be the best possible connectivity out of the following, you will suggest to connect the new setup of offices in Bangalore with its London based office?

Satellite Link, Infrared, Ethernet cable

(d) Which of the following devices will be suggested by you to connect each computer in each of the buildings.

Switch, modem, Gateway

→
Write algorithm for Delete operation in Queue.
→

Write the SQL query questions from (i) to (iv) and write the output of SQL command for questions from (v) to (vii) given below:

EMPID FIRST NAME LAST NAME ADDRESS CITY
010 George Smith 83 First Street Howard
105 Mary Jones 842 Vine Ave. Losantiville
152 Sam Tones 33 Elm St. Paris
215 Sarah Ackerman 440 U.S. 110 Upton
244 Manila Sengupta 24 Friends Street New Delhi
300 Robert Samuel 9 Fifth Cross Washington
335 Henry Williams 12 Moore Street Boston
400 Rachel Lee 121 Harrison St. New York
441 Peter Thompson 11 Red Road Paris

Table: EMPSalary

EMPID SALARY BENEFITS DESIGNATION
010 75000 15000 Manager
105 65000 15000 Manager
152 80000 25000 Director
215 75000 12500 Manager
244 50000 12000 Clerk
300 45000 10000 Clerk
355 40000 10000 Clerk
4000 32000 7500 Salesman
441 28000 7500 Salesman

Write the SQL commands for the following :

(i) To show firstname, lastname, address and city of all employees living in paris.

(ii) To display the content of Employees table in ascending order of Firstname.

(iii) To display the firstname,lastname and total salary of all managers from the tables employee and empsalary, where total salary is calculated as
salary+benefits.

(iv) To display the maximum salary among managers and clerks from the table Empsalary.

Give the Output of following SQL commands:

(v) Select firstname, salary from employees, empsalary where designation = ‘Salesman’ and Employees.

empid=Empsalary.empid;

(vi) Select count(distinct designation) from empsalary;

(vii) Select designation, sum(salary) from empsalary group by designation having count(*) >2;

→
WAP to find the sum of first n terms of the following series:
$x-x^2+x^3+\ldots$
→