Oracle PL SQL interview question | External Table related questions | Oracle DB

Oracle PL SQL interview question | External Table related questions | Oracle DB 1. External Table    • Oracle PL SQL interview question |  Extern...   2. SQL Loader Vs External Table    • Oracle PL SQL interview question Differenc...   3. Inline External Table    • oracle 18c inline external table   00:00 Introduction 00:18 What is External Table? Introduction to External Table 01:01 Q1 Can DML (INSERT, UPDATE, DELETE) be performed on an external table? 02:15 Q2 Are DDL operations like ALTER or TRUNCATE allowed on external tables? 04:46 Q3 Are log and bad files generated every time an external table is queried? Are they overwritten or retained? 08:47 Q4 What happens if the source file is modified while the external table is being queried? 09:51 Q5 Can an external table be queried if the source file is deleted? 10:39 Q6 What happens if the source file contains invalid data or column mismatches? 12:19 Thank you -------------------------------------------------------------- This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.    / sivaacademy   Home page: https://sivakacademy.blogspot.com/ Telegram Channel : https://t.me/SivaAcademy -------------------------------------------------------------- Home page: https://sivakacademy.blogspot.com/ List of all oracle SQL/PLSQL Interview questions https://sivakacademy.blogspot.com/p/s... List of all PLSQL Scenario based Interview Questions https://sivakacademy.blogspot.com/p/p... List of all Subscriber questions and answers https://sivakacademy.blogspot.com/p/a... -------------------------------------------------------------- Oracle Interview questions playlist    • oracle interview questions and answers for...   Oracle 18C New features playlist    • Oracle 18C New Feature   Oracle 12C New features playlist    • Oracle 12C New Feature Series   Oracle PLSQL records and collections playlist    • oracle plsql records and collections   -------------------------------------------------------------- My video courses at UDEMY https://www.udemy.com/user/2c29d781-3... -------------------------------------------------------------- About Myself: ---------------------- I am Siva, [LEARN | CODE | TRAIN | SHARE]. Being in IT industry for more than 12+ years. In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX. I am passionate about "DATA", coding & training. In my spare time, I teach database technologies , ETL etc. I am very glad that you are reading my Profile, and I value your time as well as mine. Looking forward to see you in my videos For any questions, please drop me a mail at [email protected] --------------------------------------------------------------