*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
@krishnanselvam7863 жыл бұрын
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.
@krishnanselvam7863 жыл бұрын
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.
@NICITACADEMY3 жыл бұрын
I highly appreciate on your effort and continuous feedback. I will post answers for these questions soon.
@krishnanselvam7863 жыл бұрын
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?
@NICITACADEMY3 жыл бұрын
I highly appreciate on your effort and continuous feedback. I will post answers for these questions soon.
@krishnanselvam7863 жыл бұрын
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?
@NICITACADEMY3 жыл бұрын
I highly appreciate on your effort and continuous feedback. I will post answers for these questions soon.
@krishnanselvam7863 жыл бұрын
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?
@krishnanselvam7863 жыл бұрын
Which operator is used in query for pattern matching?
@krishnanselvam7863 жыл бұрын
Could you tell me sir in which time will choose rank and dense rank please explain sir.
@shahir-vf4tm2 жыл бұрын
4 th question answer B,D both are the same.
@krishnanselvam7863 жыл бұрын
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?
@krishnanselvam7863 жыл бұрын
What is pragma autonomous translation with details explanation and interview questions.?please post video sir.
@krishnanselvam7863 жыл бұрын
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.
@krishnanselvam7863 жыл бұрын
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.
@NICITACADEMY3 жыл бұрын
Hi Krishnan, Thanks for your feedback, I will post soon.
@krishnanselvam7863 жыл бұрын
Please post analytical functions with details explanation with interview questions.
@visalir34683 жыл бұрын
Please upload informatica / ETL too. Thanks 🙏 sir
@NICITACADEMY3 жыл бұрын
Already uploaded 60 videos, 40 videos in Tamil and 20 videos in English. Please check the playlist
@krishnanselvam7863 жыл бұрын
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.....
@krishnanselvam7863 жыл бұрын
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?
@NICITACADEMY3 жыл бұрын
I highly appreciate on your effort and continuous feedback. I will post answers for these questions soon.
@krishnanselvam7863 жыл бұрын
What is plsql collections ? Varray Nested table Index by table or associative array What is difference between With details explanation please post video sir.
@krishnanselvam7863 жыл бұрын
What is global temporary table please upload videos with details explanation sir.
@krishnanselvam7863 жыл бұрын
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.
@NICITACADEMY3 жыл бұрын
Yes, sure
@krishnanselvam7863 жыл бұрын
@@NICITACADEMY thank you sir
@krishnanselvam7863 жыл бұрын
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........🙏🙏🙏🙏
@NICITACADEMY3 жыл бұрын
As soon as possible
@krishnanselvam7863 жыл бұрын
PLEASE POST THESE ARE ALL TOPIC SIR......THIS IS INTERVIEW QUESTION SIR.... Pivot Unpivot Roll-up Cube
@NICITACADEMY3 жыл бұрын
Okay sure, Noted, I post video
@krishnanselvam7863 жыл бұрын
Please post video what is pragma autonomous translation with details explanation please post video sir. This is also interview questions sir.
@krishnanselvam7863 жыл бұрын
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...
@NICITACADEMY3 жыл бұрын
Noted
@krishnanselvam7863 жыл бұрын
What is table partitioning please upload videos with details explanation
@krishnanselvam7863 жыл бұрын
UTL_FILE and XML please video with details explanation sir.
@krishnanselvam7863 жыл бұрын
Pleast post video correlate subquery and merge topics with interview questions.
@krishnanselvam7863 жыл бұрын
What is The difference between cluster and non cluster index
@krishnanselvam7863 жыл бұрын
Advantages and disadvantage s of stored procedure
@krishnanselvam7863 жыл бұрын
What is index and index organized table with details explanation please post video sir
@NICITACADEMY3 жыл бұрын
Will do soon
@krishnanselvam7863 жыл бұрын
What is local procedure?
@krishnanselvam7863 жыл бұрын
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.
@NICITACADEMY3 жыл бұрын
Sure, I will check.
@krishnanselvam7863 жыл бұрын
Plsql DBMS _ jobs videos please upload videos with details explanation sir.
@SATHISHSATHISH-mt8cb3 жыл бұрын
Sir could u please upload a balance topics functions, triggers, cursor, packages
@NICITACADEMY3 жыл бұрын
Sure, Keep watching.
@kaviyarasus93442 жыл бұрын
@@NICITACADEMY still we are watching
@krishnanselvam7863 жыл бұрын
Please post video sir.mutating table error?
@NICITACADEMY3 жыл бұрын
As soon as possible
@krishnanselvam7863 жыл бұрын
What is online transaction processing OLTP
@NICITACADEMY3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist.
@krishnanselvam7863 жыл бұрын
what is ACID ? SIR
@krishnanselvam7863 жыл бұрын
What is local variable and bind variable?
@krishnanselvam7863 жыл бұрын
What are aggregate and scalar functions
@NICITACADEMY3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist.
@krishnanselvam7863 жыл бұрын
What is denormalization
@NICITACADEMY3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist. Data warehouse topic.
@krishnanselvam7863 жыл бұрын
What is normalization
@NICITACADEMY3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist. Data warehouse topic.
@krishnanselvam7863 жыл бұрын
What is data warehouse
@NICITACADEMY3 жыл бұрын
Hi, I have uploaded the video on this topic already, Please check the playlist.
@krishnanselvam7863 жыл бұрын
@@NICITACADEMY could you please attach the link below sir.i can't find in playlist where it is?
@sumimadhan203 жыл бұрын
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.
@NICITACADEMY3 жыл бұрын
We can handle it exception handling. Keep watching my channel. I will post videos.