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
Consider the transaction: Begin Transaction Create table A ( x smallint , y smallint ) Create table B ( p smallint , q smallint ) Update A set x=600 where y > 700 Update B set p=78 where q=99 If @@ error != 0 Begin RollBack Transaction Return End Commit Transaction Select the correct option:
You should avoid the use of cursors because:
How can you change 'Hansen' into 'Nilsen' in the LastName column in the PersonsTable?
A cursor is a pointer that identifies a specific working row within a set
What is the numeric range that is supported by the datatype tinyint?
The IF UPDATE (column_name) parameter in a trigger definition will return TRUE in case of an INSERT statement being executed on the triggered table:
View the following Create statement: 1 Create table Pers 2(EmpNo Int not null, 3 EName Char not null, 4 Join Datetime not null, 5 Pay Smallmoney) Which line contains an error?
Which of the following are false for batches (batch commands)?
Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries work?
Which query is valid?