Unlock and Upgrade

Remove all limits from your Quizzes

You've reached the limit of our free version but can immediately unlock and go pro.

Continue No thanks

Make your own Quiz

Make your own Quiz Copy & Edit

Make your own quiz Manage my Quizzes Plans / Features Guides and Help Contact Privacy & Security

DDL AND DML COMMANDS in hive

What is the command to start a database in hive?

Create

Update

Modify

In Hadoop,the database is kept at ------- mode by default

Alter

Restrict

Truncate

-------- command is used to modify the owner property and change the role of the owner

Update

Alter

Modify

------- command shows how many databases are stored in the current schema

Use

Display

Show

Command used to select a specific portion of the database

Use

Show

Update

Is it possible to change the default location of managed tables in hive

Yes

How to change the column data type in hive

Alter

Alter and change

Change

Which of the following Is the data types in hive

Array

Struct

Map

All of the above

The results of a hive query can be stored as

Local file

HDFS File

Both

Which kind of keys (constraints) hive can have?

Primary keys

Foreign keys

Unique keys

None of the above

A view in hive can be seen by using

Show tables

Show views

Describe views

View views

Expand YARN

Yet another resource advancement

Yet another resource architecture

Yet another resource architect

Full form of DDL

Data Definition language

Data derived language

Data distribution language

The index in hive can be seen by

Describe index

Show index

View index

Find index

When one of the join tables is small enough to fit into memory, the type of join used by hive is

Inner join

Reduce join

Sort join

Map join

{"name":"DDL AND DML COMMANDS in hive", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is the command to start a database in hive?, In Hadoop,the database is kept at ------- mode by default, -------- command is used to modify the owner property and change the role of the owner","img":"https://www.poll-maker.com/3012/images/ogquiz.pngNaN000600005300?sz=1200-00000000000775005300","accounts":"sweetymanuchapala@gmail.com"}