MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Hive does not support literals for ______ types. |
| A. | Scalar |
| B. | Complex |
| C. | INT |
| D. | CHAR |
| Answer» C. INT | |
| 2. |
One supported data type that deserves special mention are : |
| A. | money |
| B. | counters |
| C. | smallint |
| D. | tinyint |
| Answer» C. smallint | |
| 3. |
_________ will overwrite any existing data in the table or partition |
| A. | INSERT WRITE |
| B. | INSERT OVERWRITE |
| C. | INSERT INTO |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 4. |
Serialization of string columns uses a ________ to form unique column values. |
| A. | Footer |
| B. | STRIPES |
| C. | Dictionary |
| D. | Index |
| Answer» D. Index | |
| 5. |
Which of the following statement will create column with varchar datatype ? |
| A. | CREATE TABLE foo (bar CHAR(10)) |
| B. | CREATE TABLE foo (bar VARCHAR(10)) |
| C. | CREATE TABLE foo (bar CHARVARYING(10)) |
| D. | All of the mentioned |
| Answer» C. CREATE TABLE foo (bar CHARVARYING(10)) | |
| 6. |
Which of the following will prefix the query string with parameters: |
| A. | SET hive.exec.compress.output=false |
| B. | SET hive.compress.output=false |
| C. | SET hive.exec.compress.output=true |
| D. | All of the mentioned |
| Answer» B. SET hive.compress.output=false | |
| 7. |
Integral literals are assumed to be _________ by default. |
| A. | SMALL INT |
| B. | INT |
| C. | BIG INT |
| D. | TINY INT |
| Answer» C. BIG INT | |
| 8. |
Use ________ and embed the schema in the create statement. |
| A. | schema.literal |
| B. | schema.lit |
| C. | row.literal |
| D. | all of the mentioned |
| Answer» B. schema.lit | |
| 9. |
To force Hive to be more verbose, it can be started with : |
| A. | *hive –hiveconf hive.root.logger=INFO,console* |
| B. | *hive –hiveconf hive.subroot.logger=INFO,console* |
| C. | *hive –hiveconf hive.root.logger=INFOVALUE,console* |
| D. | All of the mentioned |
| Answer» B. *hive –hiveconf hive.subroot.logger=INFO,console* | |
| 10. |
An ORC file contains groups of row data called : |
| A. | postscript |
| B. | stripes |
| C. | script |
| D. | none of the mentioned |
| Answer» C. script | |
| 11. |
________ was designed to overcome limitations of the other Hive file formats. |
| A. | ORC |
| B. | OPC |
| C. | ODC |
| D. | None of the mentioned |
| Answer» B. OPC | |
| 12. |
_______ is a lossless data compression library that favors speed over compression ratio. |
| A. | LOZ |
| B. | LZO |
| C. | OLZ |
| D. | All of the mentioned |
| Answer» B. LZO | |
| 13. |
_______ is interpolated into the quotes to correctly handle spaces within the schema. |
| A. | $SCHEMA |
| B. | $ROW |
| C. | $SCHEMASPACES |
| D. | $NAMESPACES |
| Answer» B. $ROW | |
| 14. |
_______ can change the maximum number of cells of a column family. |
| A. | set |
| B. | reset |
| C. | alter |
| D. | select |
| Answer» D. select | |
| 15. |
The ________ class provides the getValue() method to read the values from its instance. |
| A. | Get |
| B. | Result |
| C. | Put |
| D. | Value |
| Answer» C. Put | |
| 16. |
__________ does re-write data and pack rows into columns for certain time-periods. |
| A. | OpenTS |
| B. | OpenTSDB |
| C. | OpenTSD |
| D. | OpenDB |
| Answer» C. OpenTSD | |
| 17. |
The _________ suffers from the monotonically increasing rowkey problem |
| A. | rowkey |
| B. | columnkey |
| C. | counterkey |
| D. | all of the mentioned |
| Answer» B. columnkey | |
| 18. |
HBase uses the _______ File System to store its data. |
| A. | Hive |
| B. | Imphala |
| C. | Hadoop |
| D. | Scala |
| Answer» D. Scala | |
| 19. |
__________ class adds HBase configuration files to its object. |
| A. | Configuration |
| B. | Collector |
| C. | Component |
| D. | None of the mentioned |
| Answer» B. Collector | |
| 20. |
_________ is the main configuration file of HBase. |
| A. | hbase.xml |
| B. | hbase-site.xml |
| C. | hbase-site-conf.xml |
| D. | none of the mentioned |
| Answer» C. hbase-site-conf.xml | |
| 21. |
________ communicate with the client and handle data-related operations. |
| A. | Master Server |
| B. | Region Server |
| C. | Htable |
| D. | All of the mentioned |
| Answer» C. Htable | |
| 22. |
Which of the following is not a table scope operator ? |
| A. | MEMSTORE_FLUSH |
| B. | MEMSTORE_FLUSHSIZE |
| C. | MAX_FILESIZE |
| D. | All of the mentioned |
| Answer» B. MEMSTORE_FLUSHSIZE | |
| 23. |
You can delete a column family from a table using the method _________ of HBAseAdmin class. |
| A. | delColumn() |
| B. | removeColumn() |
| C. | deleteColumn() |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |