Interview Questions | Eklavya Online

Interview Questions

SQL Advance Interview Questions

1: Explain the meaning of ‘index’. Indexes help retrieve information from the database faster and with higher efficiency. In other words, it’s a method that enhances performance and there are 3 types of indexes: Clustered – reorders the table and searches for information with the use of key values Non-clustered – maintains the order of the table Unique – …

SQL Advance Interview Questions Read More »

Apache Spark Programming skill evaluation advanced interview questions

Describe the following code and what the output will be. Output: The main method, calculate, reads two sets of data. (In the example they are provided from a constant inline data structure that is converted into a distributed dataset using parallelize.) The map applied to each of them transforms them into tuples, each consisting of a userId and the …

Apache Spark Programming skill evaluation advanced interview questions Read More »

SQL Intermediate Interview Questions

1: Explain the meaning of ‘index’. Indexes help retrieve information from the database faster and with higher efficiency. In other words, it’s a method that enhances performance and there are 3 types of indexes: Clustered – reorders the table and searches for information with the use of key values Non-clustered – maintains the order of the table Unique – …

SQL Intermediate Interview Questions Read More »

Spring Integration file-input-output-channel-adaptor:Lab-5

We will Create and test an inbound file adapter. Create and test an outbound file adapter\ Here we will only be using file-inbound-channel-adapter and file-inbound-outbound-channel-adapter  channels in place of std-in-channel-adapder and stdout-channel-adapter which we have used in previous labs(Channel labs) spring-integration-file-outbound-channel-adapter.xml Main container loader class which will load all the beans Startup.java

SQL Basic Interview Questions

RDBMS is one of the most commonly used databases to date, and therefore SQL Skills are indispensable in most of the job roles. In this SQL Interview Questions article, I will introduce you to the most frequently asked questions on SQL (Structured Query Language). This article is the perfect guide for you to learn all …

SQL Basic Interview Questions Read More »

PLSQL Basic Interview Questions

Q1) What is the difference between PL SQL and SQL? Ans.  PL SQL vs SQL Comparison SQL PL/SQL Execution Single command at a time Block of code Application Source of data to be displayed Application created by data acquired by SQL Structures include DDL and DML based queries and commands Includes procedures, functions, etc Recommended …

PLSQL Basic Interview Questions Read More »

Spark Interview Questions for Beginners

1. How is Apache Spark different from MapReduce? Apache Spark MapReduce Spark processes data in batches as well as in real-time MapReduce processes data in batches only Spark runs almost 100 times faster than Hadoop MapReduce Hadoop MapReduce is slower when it comes to large scale data processing Spark stores data in the RAM i.e. …

Spark Interview Questions for Beginners Read More »

Spark Interview Questions for Intermediates

1. How to programmatically specify a schema for DataFrame? DataFrame can be created programmatically with three steps: Create an RDD of Rows from the original RDD; Create the schema represented by a StructType matching the structure of Rows in the RDD created in Step 1. Apply the schema to the RDD of Rows via createDataFrame method provided by SparkSession. 2. …

Spark Interview Questions for Intermediates Read More »

PLSQL Advanced Interview Questions

1.What is query to Find Second Highest Salary Of Employee? | Find 2nd Highest salary examples Select distinct Salary from Employee e1 where 2=Select count(distinct Salary) from Employee e2 where e1.salary<=e2.salary; Alternative: select min(salary)from(select distinct salary from emp order by salary desc)where rownum<=2; 2.Query to find Duplicate Records in Table? Select * from Employee a …

PLSQL Advanced Interview Questions Read More »

PLSQL Intermediate Interview Questions

Prepare Sample Data To Practice SQL Skill. Sample Table – Worker WORKER_ID FIRST_NAME LAST_NAME SALARY JOINING_DATE DEPARTMENT 001 Monika Arora 100000 2014-02-20 09:00:00 HR 002 Niharika Verma 80000 2014-06-11 09:00:00 Admin 003 Vishal Singhal 300000 2014-02-20 09:00:00 HR 004 Amitabh Singh 500000 2014-02-20 09:00:00 Admin 005 Vivek Bhati 500000 2014-06-11 09:00:00 Admin 006 Vipul Diwan 200000 …

PLSQL Intermediate Interview Questions Read More »