MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Packages are contained in a module that exposes them to the Extended Events engine. A module can contain one or more packages, and can be compiled as an executable or DLL file
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -An Extended Event package is simply a container for the objects used by Extended Events. It contains all the metadata for the objects that exist within Extended Events. When creating an Extended Events session you can use objects from one or more packages and there are many different packages available.

Detailed explanation-2: -RESTORE Statements (Transact-SQL)

Detailed explanation-3: -This can be found by expanding the “Management” node with Object Explorer. You then expand “Extended Events” followed by “Sessions” which will give you a list of your sessions. After right-clicking on the session you want to view you can then select “Watch Live Data” as shown below.

Detailed explanation-4: -NOTE] One difference between interpreted (disk-based) stored procedures and natively compiled stored procedures is that an interpreted stored procedure is compiled at first execution, whereas a natively compiled stored procedure is compiled when it is created.

There is 1 question to complete.
Previous
Next