Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology programming languages

You have created a cursor named test_cursor inside your stored procedure. Following is the cursor code: --------------------------------------------------------------------- DECLARE @Name AS VARCHAR(100) DECLARE test_cursor CURSOR FOR SELECT empname FROM Employee Order BY empid OPEN test_cursor FETCH NEXT FROM test_cursor INTO @Name WHILE @@FETCH_STATUS <> 0 BEGIN -- Do your internal procesing here FETCH NEXT FROM test_cursor INTO @Name END CLOSE test_cursor DEALLOCATE test_cursor --------------------------------------------------------------------- What correction is required in the code above?

  1. First Deallocate and then close

  2. Use @@FETCH_STATUS = 0 instead of @@FETCH_STATUS <> 0

  3. No need to use "FETCH NEXT FROM test_cursor INTO @Name" again before END statement

  4. Both i and ii
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology web technology

What is true about SSL

  1. a. SSL is be configured at Domain Level. All Servers in Domain use same setting

  2. b. SSL is be configured Server Level. Each Server in domain can have own SSL Setting

  3. c. SSL is configured at Cluster Level. All Servers that are part of Cluster use same setting.

  4. d. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation