SQL interview Questions and Answers | Frequently asked SQL interview questions | Sql Mock Interview

[Music] hello hello good morning sir good morning so tell me something about yourself okay my name is myori I'm from Washim Maharashtra I completed my graduation from electronic and telecommunication Branch from V technological Institute Mumbai VJ college and after my graduation I join Lotus hey Hub uh I join courses like C C++ SQL and plsql okay and now I am here for Mo interview okay fine so what is the SQL SQL is a uh it stand for structur c language in that we uh manipulate data we can work with our database okay uh type of SQL uh there are uh different commands in SQL uh ddl DML DCL DCL DQ okay what is the meaning of ddl ddl stand for data definition language in that there are four types uh uh trunet drop uh create and alter okay fine and DML data manipulation language in that we can update uh create and delete okay is it create come under DML in DML oh no sorry it's insert command okay fine so what is the difference between we and having uh wear and having so wear Clause we use before uh we Clause we use to filter uh a row before any grouping and having Clause we use uh after grouping okay so is it having required uh any aggregate functions yes uh having required uh aggregated function uh like maximum minimum count okay Suppose there is a group is it to uh is it okay to use where or having we in that uh we use having Clause okay and Suppose there is a normal table ID name salary then we use H Clause sorry wear Clause okay wear Clause okay so according to you when there is a group then you should use uh I guess have okay so type of joints oh there uh joints basically used uh to combine row uh to combine rows from two or more table so there are different types of joint inner joint left joint right joint cross joint self joint okay fine so what is the left outer joint in school left outer joint if there is two table let's consider two table everything from the left table and common things from the right table that is a left join left out joint okay what is the inner join inner join is a common data from the V table common data from both table what is the full outer joint full outer joint uh remaining uh not it doesn't show the common data of no full auto show the everything from the board table okay what is the difference between local and Global variable uh I I'm not sure about this question sir okay what is the normalization uh normalization is used to reduce the uh dependency on a large scale data to uh small scale data okay uh is it the process to make better database yeah okay good what is the subcy subury it is like uh we can ask ask one question to another question in that um subquery uh we write a cury in one cury we write a cery in another uh cury so in sub cury our inner query work first and then our outer query work later okay what are the constants in a SC uh constant there are uh different type of constant primary key foreign key unique not null default those are the constant okay what is the not null not null constant uh we use to uh uh not uh not null to in a data to not null value we use a not null constant okay what is the primary key primary key is a unique and uh primary key is unique and not null okay can we put more than one a primary key in a table uh in one table no okay fine so is it this is okay so we want to go with the your practical means uh so you should show the your screen laptop is screen yes myori so we are here for the we are checking out the Practical knowledge so just create any table ID name salary date of joining so myori this is the table is already existing so is it possible to drop this table yes sir yes what is the command so we use a drop command Okay so okay you have the drop table so can be can you show anywhere key this table is not exist how you will be in his table is not existing yes okay fine it's not sh there so yeah so now that name is it possible to reuse again yes sir okay once we delete any table drop any table we can create yes create the table and insert some record okay sh for e e e e e e yes display your table okay okay myori so ID salary is it possible to do uh ID in a ascending order yes sir for that we use order by okay just write the code okay good so myori is it possible to face the data like the salary should be greater than equals to 49,000 and less than equals to 70,000 yes sir okay okay salary salary should be greater than equals to 49,000 149,000 and uh can you please repeat question one and uh greater than equals to 75,000 for okay it's fine okay so myori just again you display your table is it possible to drop salary column from table yes sir we can drop yes if okay display your table okay can we delete the record where ID equal to one yes sir okay good okay mayi so do you have any question for me uh no sir uh not like that but uh can you please rate my interview okay do I need any Improvement okay so when we come to your theory part it's good but when we come to coding you needed uh more practice okay sir okay sometime you are getting confused where we should use delete and ID so it's come by practice only okay thank you thank you for coming yeah thank you so much okay [Music]

Channel: Lotus IT Hub training institute

Views: 26,891

Keywords: mock interview, HR interview, HR top interview, Hrquestions, HR Interview, HR Questions, HR question, HR mock interview, HR interview question for freshers, HR interview questions for freshers, interview tips, hr interview, hr interview tips, interviewtips, interviewpreparation, interesting, mocktestpracticeset sqlforbeginners, sqlinterviewquestions, mockinterview, sqlcommands, mock job interview, job interview tips, mock interview practice

Id: KCOWdPSAzjc

Length: 16min 45sec (1005 seconds)

Published: Sat Mar 23 2024