MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
WHICH_OF_THE_FOLLOWING_PAIR_OF_VIEWS_HAS_ONE_TO_MANY_RELATIONSHIP_??$ |
| A. | sys.server_event_session_actions.event_session_id, sys.sys.server_event_sessions.event |
| B. | sys.server_event_session_actions, sys.sys.server_event_sessions.event_session_id |
| C. | sys.server_event_session_actions.event_session_id,sys.sys.server_event_sessions.event _session_id |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 2. |
Which_of_the_following_format_output_events_in_an_Event_Tracing_for_Windows_?$ |
| A. | event_file |
| B. | ring_buffer |
| C. | histogram |
| D. | etw_classic_sync_target |
| Answer» E. | |
| 3. |
_________ returns a row for each customizable column that was explicitly set on events and targets? |
| A. | sys.server_event_session_targets |
| B. | sys.server_event_session_fields |
| C. | Returns a row for each event in an event session |
| D. | All of the mentioned |
| Answer» C. Returns a row for each event in an event session | |
| 4. |
Which of the following catalog view is used for SQL Server Extended Events ? |
| A. | sys.server_sessions |
| B. | sys.server_event_sess |
| C. | sys.server_event_session_actions |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 5. |
_________ can be applied to the metadata or to an active session and the metadata. |
| A. | DROP EVENT SESSION |
| B. | ALTER EVENT SESSION,STATE=STOP |
| C. | ALTER EVENT SESSION,STATE=START |
| D. | All of the mentioned |
| Answer» E. | |
| 6. |
Which of the DDL statement creates a session object that contains the metadata ? |
| A. | CREATE EVENT SESSION |
| B. | CREATE SESSION |
| C. | CREATE EVENT SESSION METADATA |
| D. | None of the mentioned |
| Answer» B. CREATE SESSION | |
| 7. |
SQL Server Extended Events Packages consist of : |
| A. | Events |
| B. | Predicates |
| C. | Types |
| D. | All of the mentioned |
| Answer» E. | |
| 8. |
Which of the following is a extended event task ? |
| A. | create an Extended Events session |
| B. | alter an Extended Events session |
| C. | find out what events are available in the registered packages |
| D. | All of the mentioned |
| Answer» E. | |