LOYOLA ACADEMY

DEGREE & PG COLLEGE

OLD ALWAL, SECUNDERABAD - 500 010,
TELANGANA, INDIA
An Autonomous Institution Affiliated to Osmania
University
Re-accredited with ‘A’ Grade (III Cycle) by NAAC
A “College with Potential for Excellence” by UGC

Practical Record

CERTIFICATE
This is to certify that this is a Bonafide record work done in ADVANCED DATABASES
practical during IST year IST semester of the academic year 2024-2025

Name: G. Aishwarya
UID No: 111724720022
Class: AMDS

Signature of Internal Signature of HoD

Signature of External Signature of Principal

 INDEX

NORMAL QUERIES:

SNO QUERY NAME PAGE NO SIGNATURE

1 Write a query to create a table with the following
parameters sno, sname, dob, sub1, sub2 & sub3
using appropriate data type.

2 Write a query to insert data into table & display

the table.
3(a) Write a query to display the data in a table as
follows:
a) all rows and all columns
3(b) Selected columns and all rows.
3(c) Selected row and all columns.
3(d) Selected row and selected columns.
4 Write a query to eliminate duplicate rows using
select statement.
5(a) Write a query to sort the data in the table.
Descending order.
5(b) Ascending Order
6 Write a query to create a table from another table
7 Write a query to create a table from a table by
specifying certain conditions.
8 Write a query to insert data into a table from other
table
9 Write a query to insert a data set into a table from
another table.
10 Write a query to delete all rows from a table.
11 Write a query to delete selected rows
12 Write a query to update the contents of a table.
13 Write a query to update all rows of a table.
14 Write a query to modify the structure of the table.
15 Write a query to drop a column from the table.
16 Write a query to modify the existing columns in a
table
17 Write a query to truncate a table.
18 write a query to destroy the table
19 Create a table client-master which stores the client
info.
20 Write a query to add pin code to client-master
table
21 Write a query to create a table customer with
cust id as primary key followed by other
columns.
22 Write query to establish foreign key
constraint.
23 Write a query to calculate salary of employee
per day.
24 Write a query to calculate annual salary of an
employee.
25 Write a query to add unique constraints.
26 Write a query to create a table having bname &
bno and display values where bno is null.
27 Write a query to create a table that does take a
null value.
28 Write a query to implement primary key
constraints.
29 Write a query to drop primary key constraint
from a table.
30 Write a query to display details of employee
whose salary ranges between14500- 15500
31 Write a query to implement OR.
32 Write a query to implement NOT.
33 Write a query to implement range searching
34 Write a query to display the employee name
that begins with m
35 Write a query display the employee name that
ends with a.
36 Write a query to display the employee name
that have exactly three characters
37 Write a query to display the employee name
that have ‘a’ has second letter
38 Write a query to display the employee names
whose names are soumya, pranav and tarun.
39 Write a query to display the employee name
except whose names are soumya, pranav and
tarun.
40 Write a query to implement oracle table dual.
41 Write a query to implement system dates.
42 Write a query to find the average of salary of
hcl table.
43 Write a query to find the minimum of salary of
hcl table.
44 Write a query to find the maximum of salary of
hcl table.
45 Write a query to implement count function in
hcl table.

46 Write a query to implement sum function in

hcl table.
 47 Write a query to implement numeric function
that returns absolute value of -24
48 Write a query to implement numeric function
using power
49 Write a query to implement Round numeric
function.
50 Write a query to implement Square root
numeric function.
51 Write a query to implement Exp numeric
function
52 Write a query to implement Greatest numeric
function.
53 Write a query to implement least numeric
function
54 Write a query to implement mod numeric
function.
55 Write a query to implement trunc numeric
function
56 Write a query to implement floor numeric
function.
57 Write a query to implement ceil numeric
function
58 Write a query to implement lower string
function.
59 Write a query to implement upper string
function.
60 Write a query to implement ASCII string
function.
61 Write a query to implement substr string
function.
62 Queries on Order by clause
63 Queries on Group by clause
64 Queries on Group Functions
65 Joins

ADVANCE QUERIES

ASSIGNMENT-I
SNO QUERY NAME PAGE NO SIGNATURE
1 What is the highest numbers of copies sold by a
package?
2 Display lowest course fee.

3 How many programmers has done PGDCA

course.
4 How much revenue has been earned through sales
of packages in C.
5 Display the details of software developed by
Ramesh?
6 ow many programmers studied at SABHARI.
7 Display the details of PACKAGES whose sales
crossed the 20000 mark.
8 Find out the number of copies which should be
sold in order to recover the development cost of
each package
9 What is the price of the costliest software
developed in BASIC?
10 Display the details of packages for which
development cost has been recovered
11 How many packages were developed in dbase?
12 How many programmers studies at paragathi?
13 How many programmers paid 5000 to 10000 for
their course?
14 What is the average course fee?
15 Display the details of programmers knowing c?
16 How many programmers know either Cobol or
Pascal?
17 How many programmers don't know Pascal & C?
18 Calculate the experience in years for each
programmers and display along with the names in
descending order?
19 How many female programmers are there?
20 What is the Average salary?
21 How many people draw 2000 to 4000?
22 Display the details of those who don't know
Clipper, Cobol or Pascal?
23 How many Female programmers knowing C are
above 24 years of age?
24 List the packages which have not been sold so far?
25 Display the institute names from the studies table
without duplicates?
26 How many different courses are mentioned in the
studies table?
27 Display the names of programmers whose names
contain upto 5 characters?
28 How many female programmers knowing COBOL
have more than 2 years experience?
29 What is the length of the shortest name in the
programmer table?
30 What is the average development cost of a package
developed in COBOL?
31 Who are the programmers who were born on the
last day of the month?
32 What is the amount paid in salaries of the male
programmers who do not know Cobol?
 33 Display the name, dob, doj of those month of birth
and month of joining are same?

ASSIGNMENT-2:

SN0 QUERY NAME PAGE NO SIGNATURE

1 Count the customers with grades above
banglore’s average.
2 Find the name numbers of all salesman who
had more than one customer
3 Create a view that finds the salesman who has
the customer with the highest order of a day.
4 Demonstrate the delete operation by removing
salesman with id 1000.all his orders must also
be deleted.

ASSIGNMENT-3:

SNO QUERY NAME PAGE NO SOGNATURE

1 List the titles of all movies directed by
‘Hitchcock’.
2 Find the movie names where one or more actors
acted in two or more movies
3 Find the title of movies and number of stars for
each movie that has at least one rating and find
the highest number of stars that movie received.
Sort the result by movie title
4 Update rating of all movies directed by ‘Steven
Spielberg’ to 5

MONGO DB COMPASS:

SNO QUERY NAME PAGENO SIGNATURE

1 Introduction to MongoDB
2 Procedure to Install MongoDB
3 Mongo db commands
4 Create database
5 Crud
6 Mongo db compass
7 Mongo db shell
8 Adding new documents
9 Finding documents
10 Sorting & limiting data
11 Nested documents
12 Operators & complex queries
13 Logical operator
14 Aggregation techniques

15 Text searching
16 Limit() and skip() methods