Tap to unmute

Top 50 SQL Interview Questions and Answers in 2021 | Oracle SQL Quiz with answers

  Рет қаралды 13,442

NIC IT ACADEMY

NIC IT ACADEMY

Күн бұрын

Пікірлер: 70
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
*Complete 48 hours of Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/ Are you interested in joining my Live training? or Self-Paced course? You can visit our website for more details. www.nicitacademy.com/ Contact me for more details @ 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy ======================================================================= 🔵Oracle SQL Tutorial - English kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* kzbin.info/www/bejne/eWLdeImIe7JmY6M 📌*Informatica Full Course:* kzbin.info/www/bejne/jGOppY2VfrOgoMk 📌*SQL Full Course:* kzbin.info/www/bejne/n6bZq52cbNOIZ6s 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH kzbin.info/aero/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist kzbin.info/aero/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL kzbin.info/aero/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer kzbin.info/aero/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos kzbin.info/aero/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
31) How would you reference column values BEFORE and AFTER you have inserted and deleted triggers? 32) What are the uses of SYSDATE and USER keywords? 33) How does ROWID help in running a query faster? 34) What are database links used for? 35) What does fetching a cursor do? 36) What does closing a cursor do? 37) Explain the uses of Control File. 38) Explain Consistency 39) Differ between Anonymous blocks and sub-programs 40) Differ between DECODE and CASE.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
1) What is PL SQL ? 2) Differentiate between % ROWTYPE and TYPE RECORD. 3) Explain uses of cursor.? 4) Show code of a cursor for loop 5) Explain the uses of database trigger. 6) What are the two types of exceptions. 7) Show some predefined exceptions. 8) Explain Raise_application_error. 9) Show how functions and procedures are called in a PL SQL block. 10) Explain two virtual tables available at the time of database trigger execution.
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
I highly appreciate on your effort and continuous feedback. I will post answers for these questions soon.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
21) Show the two PL/SQL cursor exceptions. 22) What operators deal with NULL? 23) Does SQL*Plus also have a PL/SQL Engine? 24) What packages are available to PL SQL developers? 25) Explain 3 basic parts of a trigger. 26) What are character functions? 27) Explain TTITLE and BTITLE. 28) Show the cursor attributes of PL/SQL. 29) What is an Intersect? 30) What are sequences?
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
I highly appreciate on your effort and continuous feedback. I will post answers for these questions soon.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
41) Explain autonomous transaction. 42) Differentiate between SGA and PGA. 43) What is the location of Pre_defined_functions. 44) Explain polymorphism in PL SQL. 45) What are the uses of MERGE? 46) Can 2 queries be executed simultaneously in a Distributed Database System? 47) Explain Raise_application_error. 48) What is out parameter used for eventhough return statement can also be used in pl/sql? 49) How would you convert date into Julian date format? 50) Explain SPOOL?
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
I highly appreciate on your effort and continuous feedback. I will post answers for these questions soon.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
please post videos ...................sir......... 61) Mention what is the function that is used to transfer a PL/SQL table log to a database table? 62) When you have to use a default “rollback to” savepoint of PLVlog? 63) Why PLVtab is considered as the easiest way to access the PL/SQL table? 64) Mention what does PLVtab enables you to do when you showthe contents of PL/SQL tables? 65) Explain how can you save or place your msg in a table? 66) Mention what is the use of function “module procedure” in PL/SQL? 67) Mention what PLVcmt and PLVrb does in PL/SQL?
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Which operator is used in query for pattern matching?
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Could you tell me sir in which time will choose rank and dense rank please explain sir.
@shahir-vf4tm
@shahir-vf4tm 2 жыл бұрын
4 th question answer B,D both are the same.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
51) Mention what PL/SQL package consists of? 52) Mention what are the benefits of PL/SQL packages? 53) Mention what are different methods to trace the PL/SQL code? 54) Mention what does the hierarchical profiler does? 55) Mention what does PLV msg allows you to do? 56) Mention what is the PLV (PL/Vision) package offers? 57) Mention what is the use of PLVprs and PLVprsps? 58) Explain how you can copy a file to file content and file to PL/SQL table in advance PL/SQL? 59) Explain how exception handling is done in advance PL/SQL? 60) Mention what problem one might face while writing log information to a data-base table in PL/SQL?
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is pragma autonomous translation with details explanation and interview questions.?please post video sir.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is cursor? Type of current Cursor attributes Cursor for loop Refer cursor What is difference between for loop and cursor for loop and ref cursor? With Syntex please explain and post video sir.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Please post video sir Analytical functions: --------+++++++---------- Rank Dense_rank Lead Lag Row_number Listagg Pivot Unpivot Roll-up Cube With interview questions and details explaination sir.
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Hi Krishnan, Thanks for your feedback, I will post soon.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Please post analytical functions with details explanation with interview questions.
@visalir3468
@visalir3468 3 жыл бұрын
Please upload informatica / ETL too. Thanks 🙏 sir
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Already uploaded 60 videos, 40 videos in Tamil and 20 videos in English. Please check the playlist
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
When I am checking in playlist I have seen some plsql session vides 1 to 6 session in this session missing 4 and 5 session sir.if have 4 and 5 session video please upload sir.....
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
11) What are the rules to be applied to NULLs whilst doing comparisons? 12) How is a process of PL SQL compiled? 13) Differentiate between Syntax and runtime errors. 14) Explain Commit, Rollback and Savepoint. 15) Define Implicit and Explicit Cursors. 16) Explain mutating table error. 17) When is a declare statement required? 18) How many triggers can be applied to a table? 19) What is the importance of SQLCODE and SQLERRM? 20) If a cursor is open, how can we find in a PL SQL Block?
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
I highly appreciate on your effort and continuous feedback. I will post answers for these questions soon.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is plsql collections ? Varray Nested table Index by table or associative array What is difference between With details explanation please post video sir.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is global temporary table please upload videos with details explanation sir.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Could you post video sir... How to use collection methods? Limit Count First Last Trim(n) Delete Extennd(n) Prior(n) Next(n).....pls upload this viideo sir.
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Yes, sure
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
@@NICITACADEMY thank you sir
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Sir please upload PLSQL interview questions and answers with details explaination alest 50 questions and answers.........sir........thank you so so much sir. For your SQL questions and answer videos........🙏🙏🙏🙏
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
As soon as possible
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
PLEASE POST THESE ARE ALL TOPIC SIR......THIS IS INTERVIEW QUESTION SIR.... Pivot Unpivot Roll-up Cube
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Okay sure, Noted, I post video
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Please post video what is pragma autonomous translation with details explanation please post video sir. This is also interview questions sir.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is SQL loader and external table and what is difference between SQL loader and external table with details explanation please post video...thank you sir...
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Noted
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is table partitioning please upload videos with details explanation
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
UTL_FILE and XML please video with details explanation sir.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Pleast post video correlate subquery and merge topics with interview questions.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is The difference between cluster and non cluster index
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Advantages and disadvantage s of stored procedure
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is index and index organized table with details explanation please post video sir
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Will do soon
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is local procedure?
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is difference between RANK and DENSE_RANK AS aggregate & Analytical function? You have already post rank video in playlist but voice was breaking often sir please reupload that video and also plase add diff between aggregate & Analytical function.
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Sure, I will check.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Plsql DBMS _ jobs videos please upload videos with details explanation sir.
@SATHISHSATHISH-mt8cb
@SATHISHSATHISH-mt8cb 3 жыл бұрын
Sir could u please upload a balance topics functions, triggers, cursor, packages
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Sure, Keep watching.
@kaviyarasus9344
@kaviyarasus9344 2 жыл бұрын
@@NICITACADEMY still we are watching
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
Please post video sir.mutating table error?
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
As soon as possible
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is online transaction processing OLTP
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
what is ACID ? SIR
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is local variable and bind variable?
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What are aggregate and scalar functions
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is denormalization
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist. Data warehouse topic.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is normalization
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist. Data warehouse topic.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is data warehouse
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist.
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
@@NICITACADEMY could you please attach the link below sir.i can't find in playlist where it is?
@sumimadhan20
@sumimadhan20 3 жыл бұрын
Say a procedure is failed and insert operations performed are rolled back.Can we store the data in a table with all the data that are rolled back?Hw do we do that?.Expecting you answer on this Sir.Thanks in advance.
@NICITACADEMY
@NICITACADEMY 3 жыл бұрын
We can handle it exception handling. Keep watching my channel. I will post videos.
@sumimadhan20
@sumimadhan20 3 жыл бұрын
@@NICITACADEMY thanks Sir
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is the cluster and non cluster table?
@krishnanselvam786
@krishnanselvam786 3 жыл бұрын
What is data integrity
Informatica Tutorial demo TAMIL | Informatica in TAMIL
47:31
NIC IT ACADEMY
Рет қаралды 5 М.
Oracle PL SQL interview question SQL loader
10:58
Siva Academy
Рет қаралды 76 М.
She made herself an ear of corn from his marmalade candies🌽🌽🌽
00:38
Valja & Maxim Family
Рет қаралды 18 МЛН
SQL "difference between" interview questions (part 1)
8:20
Crack Concepts
Рет қаралды 634 М.
Need for Speed? My Top Five Oracle Performance Tuning Tips
1:08:38
New York Oracle User Group NYOUG
Рет қаралды 2,2 М.
She made herself an ear of corn from his marmalade candies🌽🌽🌽
00:38
Valja & Maxim Family
Рет қаралды 18 МЛН