Databases | SQL | Oracle | MS Access Answers

Questions: 284

Free Answers by our Experts: 199

Ask Your question

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Search & Filtering

Practical Related Questions:(write step by step command)

CREATE BELOW TABLE
CREATE TABLE empl (month INT, emp VARCHAR(15), dept VARCHAR(15), salary
INT);
INSERT INTO empl VALUES
(1, "Oliver", "HR", 9000),
(1, "George", "IT", 8000),
(3, "Harry", "HR", 20000),
(6, "Jack", "IT", 110123),
(6, "Jacob", "SALES", 3000),
(12, "Noah", "SALES", 101000),
(12, "Charlie", "IT", 123456);

1.Count total no of Employee
2. Find the lowest salaries in each dept
3. Find month-wise maximum salaries
4. Find the sum all employee salaries
5. Find the average of salaries in each dept
Practical Related Question
(Write step by step command)

1. Create table COURSE in that it Contain 3 fields(COURSE_ID AS PRIMARY KEY&NOT
NULL,COURSE_NAME)

2. Create 2nd Table COURSE_STRENGTH(COURSE_ID FOREIGN KEY,COURSE_STRENGTH)

3. Enter 5 record in Both table:
COURSE NAME: STRENGTH
1.PYTHON 30
2..NET 20
3.HADOOP 45
4.SOFTWARE TESTING 40
5.JAVA 35

4. DELETE SOFTWARE TESTING COURSE & SHOW BOTH TABLES.
Practical Related Questions:(step by step command)
1. Create Database NCER
2. Create Table Student it contain 3 fieldS(Roll No,Name ,Age,City)
3. Insert 5 records into table
4. Update name of student (Updated Name=XYZ)
5. Add ‘Blood Group’ Column into table
6. Rename ‘Student’ Table to ‘Stud’
7. Delete all record from ‘Stud’ table
8. Drop ‘Stud’ Table
9. Drop ‘NCER’ database
Explain union, intersection, cross product, difference in relational algebra
List and explain different types of Joins.
Explain insertion, deletion and modification amenities with an example.
List and explain the different DML commands with example
List the operation of relational algebra and purpose of each with an example.
Write short note on Open and Commercial DBMS Software
Explain unary relational operation in detail.
LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS