Interview Questions



Good SQL Queries Collection /* CREATE TABLE FOR DEPARTMENT */ CREATE TABLE DEPARTMENT ( “DEPT_ID” NUMBER, “DEPT_NAME” VARCHAR2(30), PRIMARY KEY (“DEPT_ID”) ) /* CREATE TABLE FOR EMP */ CREATE TABLE EMPLOYEE ( “EMP_ID” NUMBER, “MGR_ID” NUMBER, “DEPT_ID” NUMBER, “EMP_NAME” VARCHAR2(30), “SAL” NUMBER, “DOJ” DATE, PRIMARY KEY (“EMP_ID”) ENABLE, FOREIGN KEY […]

Good SQL Queries Collection


Real Time Hadoop Interview Questions from Various interviews Hive – Where do you use Internal or Managed table? What scenarios? In your resume, what do you mean by, “monitoring & managing MapReduce jobs”? Explain? Interviewer’s Project: How to modify the RDBMs’ Nested SQL queries into Hadoop framework using Pig. Sqoop: […]

Real Time Hadoop Interview Questions From Different Readers




2
1. What does commodity Hardware in Hadoop world mean? ( D ) a) Very cheap hardware b) Industry standard hardware c) Discarded hardware d) Low specifications Industry grade hardware 2. Which of the following are NOT big data problem(s)? ( D) a) Parsing 5 MB XML file every 5 minutes […]

100 Interview Questions on Hadoop


15
In this post we will provide some practical Sqoop Interview Questions and Answers for experienced hadoop developers. Sqoop Interview Questions and Answers for Experienced 1. What is Sqoop? Sqoop is an open source tool that enables users to transfer bulk data between Hadoop eco system and relational databases. 2. What are […]

Sqoop Interview Questions and Answers for Experienced



5
Below are some the of important hive Interview Questions and Answers for experienced hadoop developers. Hive Interview Questions and Answers for experienced 1. What is the Hive configuration precedence order? There is a precedence hierarchy to setting properties. In the following list, lower numbers take precedence over higher numbers: The […]

Hive Interview Questions and Answers for experienced Part – 4


2
Below are a few more Pig Interview Questions and Answers 1. What is a tuple? A tuple is an ordered set of fields and A field is a piece of data. 2. What is a relation in Pig? A Pig relation is a bag of tuples. A Pig relation is similar […]

Pig Interview Questions and Answers Part – 2


Below are some of the Hadoop Pig Interview questions and answers that suitable for both freshers and experienced hadoop programmers. 1. What is Apache Pig? Pig is a scripting language for exploring huge data sets of size gigabytes or terabytes very easily. Pig provides an engine for executing data flows in […]

Hadoop Pig Interview Questions and Answers Part – 1



1
Below are a few important Hadoop HBase Interview Questions and Answers that are suitable for hadoop freshers or experienced developers. 1. What is HBase? HBase is Column-Oriented , Open-Source, Multidimensional, Distributed database. It run on the top of HDFS. 2. Why do we use HBase? HBase provide random read and […]

HBase Interview Questions and Answers Part – 1


4
In this post, we will discuss about another 50 Mapreduce Interview Questions and Answers for experienced mapreduce developers. Mapreduce Interview Questions and Answers for experienced 1. What are the methods in the Mapper class and order of their invocation? [crayon-59e58113ac6b4687700339/] The Mapper contains the run() method, which call its own […]

Mapreduce Interview Questions and Answers Part – 4


1
Below are some of the hadoop interview questions and answers. 1. As the data is replicated thrice in HDFS, does it mean that any calculation done on one node will also be replicated on the other two? Since there are 3 nodes, when we send the MapReduce programs, calculations will […]

Hadoop Interview Questions and Answers Part – 5



1
In this post, we will discuss about a few more hadoop hive interview questions and answers for hadoop freshers and experienced developers. Hive Interview Questions and Answers 1. What are the types of tables in Hive? There are two types of tables. Managed tables External tables Only while dropping tables […]

Hive Interview Questions and Answers – Part 3


4
In this post, we will discuss about hive Interview Questions and Answers for experienced and freshers. Hive Interview Questions and Answers for experienced: 1. How to start Hive metastore service as a background process? We can start hive metastore service as a background process with below command. [crayon-59e58113ad81c917097565/] By using kill -9 […]

Hive Interview Questions and Answers for experienced – Part 2


4
Below are some of the important Hive Interview Questions and Answers required for Hadoop developers and administrators. Hive Interview Questions and Answers 1. What is Metadata? Data about Data. 2. What is Hive? Hive is one of the important tool in Hadoop eco system and it provides an SQL like dialect […]

Hive Interview Questions and Answers – Part 1