Correct Answer:
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Hadoop Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Hadoop MCQ Questions
A table has following values for its department field: marketing, production, production, sales, NULL, NULL, Marketing, Null What will the following query return: Select distinct(department) from employees
___________ is the highest level of a transaction isolation implemented by SQL Server.
Which one must be specified in every DELETE statement?
What does referential integrity (also called relational integrity) prevent?
Which one is true with reference to Triggers?
Which ones are aggregate functions in SQL?
Which one is not a SQL operator?
Consider the following tables: Books ------ BookId BookName AuthorId SubjectId PopularityRating (the popularity of the book on a scale of 1 to 10) Language (such as French, English, German etc) Subjects --------- SubjectId Subject (such as History, Geography, Mathematics etc) Authors -------- AuthorId AuthorName Country What is the query to determine the names of the Authors who have written more than 1 book?
Consider the following tables: Books ------ BookId BookName AuthorId SubjectId PopularityRating (the popularity of the book on a scale of 1 to 10) Language (such as French, English, German etc) Subjects --------- SubjectId Subject (such as History, Geography, Mathematics etc) Authors -------- AuthorId AuthorName Country What is the query to determine how many books have been written on each subject. Displaying Name of Subject and count of the Books?
Consider the following table structure of students: rollno int name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?