Quiz Maker LogoMake your own QuizCopy & Edit
Make your own quizManage my QuizzesPlans / FeaturesGuides and HelpContactPrivacy & 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
No
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"}

More Quizzes

420
Kvíz o Lige Majstrov 2021-22
1050
Fuzzy Friends/Brandon Quiz
10533
Welcher Typ bist du im Digitalen Zeitalter? Apokalyptiker oder Evangelist?
520
Durham University Collections
1050
SK Knowledge
1169
Test Your Knowledge on Prophet Ibrahim (as)
10551
Euro Chapter 3
1160
Books
1166
Prosthetics
10527
IFS FREDAGSQUIZ
11615
Grupo IV - Meteorologia - Teste 15 - quiz criado por Igor Fraga
105380
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker