Visit https://errorsea.com/interview-questions/ for more interview questions and answers.

SQL Queries Interview Questions

The given below SQL interview questions requires some data for explanation of SQL queries.

You can refer the following data tables for examples.

Table - StudentDetails

StudId

Name

EnrollmentNo

DateOfJoining

Nick Panchal

1234567

01/02/2019

Yash Panchal

2468101

15/03/2017

Gyan Rathod

3689245

27/05/2018

Table - StudentStipend

StudId

Project

Stipend

80000

10000

120000

Write an SQL query to insert a new student detail in StudentDetails table.

Ans. We can use the INSERT query to insert data into SQL database table.

INSERT INTO StudentDetails(StudId,Name,EnrollmentNo,DateOfJoining)

Values('51','Ashish Patel','2468653','09/03/2019');

Write an SQL query to select a specific student detail in StudentDetails table.

Ans. We can use the SELECT query to select data from the SQL database table.

SELECT * FROM StudentDetails WHERE Studid = '31';

Write an SQL query to update a project detail in StudentStipend table.

Ans. We can use the UPDATE query to update data into the SQL database table.

UPDATE StudentStipend SET Project = 'P3' WHERE Studid = '31';

Write an SQL query to drop a StudentStipend table with its structure.

Ans. We can use the DROP query to drop the SQL database table.

DROP TABLE StudentStipend;

Sqlqs - SQL

Computer Engineering (310243)

Savitribai Phule Pune University

Comments

Students also viewed

Related documents

Sqlqs - SQL

Course: Computer Engineering (310243)

University: Savitribai Phule Pune University

Recommended for you

Students also viewed

Related documents