SQL MCQ - English

Set 10 MCQ Questions and Answers

Home | SQL | Set 10

SQL MCQ Questions and Answers : We provide sql quiz questions and answers, here learn mcq questions related to Structured Query Language and test online of objective questions and free download pdf.

Page: 1/7

1) ___ can be applied to the metadata or to an active session and the metadata.

    DROP EVENT SESSION
    ALTER EVENT SESSION,STATE=STOP
    ALTER EVENT SESSION,STATE=START
    All of the mentioned

Answer : D Discuss

2) Which of the following catalog view is used for SQL Server Extended Events ?

    sys.server_sessions
    sys.server_event_sess
    sys.server_event_session_actions
    All of the mentioned

Answer : C Discuss

3) ______ returns a row for each customizable column that was explicitly set on events and targets.

    sys.server_event_session_targets
    sys.server_event_session_targets
    Returns a row for each event in an event session
    All of the mentioned

Answer : B Discuss

4) Which of the following format output events in an Event Tracing for Windows ?

    event_file
    ring_buffer
    histogram
    etw_classic_sync_target

Answer : D Discuss

5) Which of the following is a change tracking function ?

    WITH CHANGE_TRACK_CONTEXT
    CHANGE_TRACKING_MAX_VALID_VERSION()
    CHANGE_TRACKING_CURRENT_VERSION
    All of the mentioned

Answer : C Discuss

6) Which of the following is biggest disadvantage of change tracking ?

    Schema changes are required in the server database
    Triggers are fired for each change that has been made to a row
    Logic for maintaining the correct row versions and deletions is easy
    All of the mentioned

Answer : B Discuss

7) Which of the following code snippet returns a version integer that is associated with the last committed transaction that was tracked by change tracking ?

    SELECT @sync_new_received_anchor = change_tracking_cur_version()
    SELECT @sync_new_received_anchor = change_tracking_current_ver()
    SELECT @sync_new_received_anchor = change_tracking_current_version()
    SELECT @sync_new_received_anchor = change_track_current_version()

Answer : C Discuss

8) __________ obtains tracking information for all changes to a table that have occurred since a specific version.

    CHANGETABLE_CONTEXT
    CHANGETABLE
    CHANGE_TRACKING_IS_COLUMN_IN_MASK
    All of the mentioned

Answer : B Discuss

9) Which of the following is catalog view used for change tracking ?

    sys.change_tracking_tables
    sys.change_tracking_views
    sys.change_tracking_columns
    None of the mentioned

Answer : A Discuss

10) Which of the following feature distinguishes change data capture from change tracking ?

    Historical data
    DML
    DML type
    Whether column was changed

Answer : A Discuss

Jump to Pages:

1 2 3 4 5 6 7

MCQ Category