Scoop Questions

http://hadooptutorial.info/sqoop-interview-questions-and-answers-for-experienced/

1) Number of map's to work on a table can be controlled by
 sqoop import -connect jdbc:mysql://localhost:3306/test -username root --table Name -map 1 --target-dir DirName
 sqoop import -connect jdbc:mysql://localhost:3306/test -username root --table Name -m 1 - r 1 --target-dir DirName
 can't control
 sqoop import -connect jdbc:mysql://localhost:3306/test -username root --table Name -m 1 --target-dir DirName

2) By Default Parallelism(Multiple MR jobs to work on one table) is Off
 True
 False

3) Sqoop import create-hive-table. Create-Hive-Import Role is
 Import data
 Import Table Defination
 None
 Import Table defination and data

4) Best performed mode will be
 Sqoop MySql Driver
 All will perform more or less same
 JDBC Import
 Direct Import(MySqlDump)

5) We can't import MySql table without primary key in HDFS.
 False
 True

6) Number of map's required to transfer whole data in HDFS is decided by
 Input Format
 DataDrivenInput Format
 DBInput Foramt
 FileInputFormat

7) When we use Direct Import(example mysqldump tool), JDBC use can be avoided.
 True
 False

8) Default file format during sqoop import to hdfs is
 Text
 CSV
 Binary( like sequence)
 TSV

9) Multiple maps can't work when we transfer single table import
 False
 True

10) Table A has column Imagedata, of type blob, Which one is fastest possible method.
 Using Sqoop Lobfile for ImageData
 JDBC
 MySqlDump
 No Need, will automatically handled efficiently