InterviewSolution

Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.	Which of the following option can be used to launch Perfmon?(a) Type “start perfmon” at the command prompt(b) Go to Start \| Programs \| Administrative Tools \| Performance Monitor(c) Go to Start \| Run \| Perfmon(d) All of the mentionedI have been asked this question in unit test.I would like to ask this question from Performance Monitoring in division Monitoring and Auditing of SQL Server
Answer» The CORRECT option is (d) All of the mentioned The explanation is: There are three ways to launch PERFMON which is PERFORMANCE monitoring tool for SQL Server.

52.	Point out the wrong statement.(a) There are hundreds of Performance Counters(b) Performance Counters are very important to evaluate(c) SQL Server provides several tools for monitoring events in SQL Server and for tuning the physical database design(d) None of the mentionedThis question was addressed to me by my school principal while I was bunking the class.This is a very interesting question from Performance Monitoring topic in section Monitoring and Auditing of SQL Server
Answer» The correct CHOICE is (a) There are HUNDREDS of Performance Counters Explanation: There are more than THOUSANDS of Performance Counters.

53.	Which of the following database level event si raised whenever a REFERENCES permission is checked.(a) EXECUTE(b) REFERENCES(c) UPDATE(d) SELECTThis question was addressed to me in unit test.This interesting question is from Schema Audit topic in portion Monitoring and Auditing of SQL Server
Answer» Correct OPTION is (b) REFERENCES To ELABORATE: Database-level audit ACTIONS do not APPLY to Columns.

54.	DDL Trigger can capture the information about the EVENT that fired it by using __________ function.(a) EVENTDATA()(b) EVENT()(c) EVENTS()(d) None of the mentionedI had been asked this question in unit test.The query is from Schema Audit topic in portion Monitoring and Auditing of SQL Server
Answer» The correct option is (a) EVENTDATA() To elaborate: The EventData xml value includes the TRIGGERING SQL STATEMENT, the event time, the type of event and DEPENDING on what type of event was CALLED, extra INFORMATION such as the database name.

55.	You can use the handy event name of __________ to make sure your trigger covers all DDL events.(a) DDL_DATABASE_EVENTS(b) DDL_DATABASE_LEVEL_EVENTS(c) DDL_DATABASE_LEVEL(d) All of the mentionedI had been asked this question by my college director while I was bunking the class.Enquiry is from Schema Audit in section Monitoring and Auditing of SQL Server
Answer» Right choice is (B) DDL_DATABASE_LEVEL_EVENTS Easy EXPLANATION: DDL_DATABASE_LEVEL_EVENTS is used for auditing DATABASE OBJECTS in SQL Server.

56.	__________ could potentially lead to large audit records.(a) DATABASE_OBJECT_ACCESS_GROUP(b) DATABASE_MIRRORING_LOGIN_GROUP(c) DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP(d) DATABASE_OBJECT_PERMISSION_CHANGE_GROUPThe question was asked in a national level competition.The doubt is from Schema Audit in chapter Monitoring and Auditing of SQL Server
Answer» CORRECT OPTION is (a) DATABASE_OBJECT_ACCESS_GROUP The best I can EXPLAIN: DATABASE_OBJECT_ACCESS_GROUP event is raised for any access to any DATABASE.

57.	AUDIT_CHANGE_GROUP event is raised whenever any audit is _____________(a) Created(b) Modified(c) Delete(d) All of the mentionedThe question was asked in class test.Enquiry is from Schema Audit topic in section Monitoring and Auditing of SQL Server
Answer» The correct answer is (d) All of the mentioned For EXPLANATION: Any change to an audit is AUDITED in that audit.Equivalent to the Audit Change Audit Event CLASS.

58.	Point out the wrong statement.(a) When the query processor parameterize the query, the parameter can appear in the audit event log instead of the column values of the query(b) To access the triggering event we can use the EventData function in our DDL trigger(c) AUDIT_DATABASE_CHANGE_GROUP event is raised whenever CREATE DATABASE AUDIT is issued(d) None of the mentionedThe question was asked in semester exam.The above asked question is from Schema Audit in chapter Monitoring and Auditing of SQL Server
Answer» Right ANSWER is (c) AUDIT_DATABASE_CHANGE_GROUP EVENT is RAISED whenever CREATE DATABASE AUDIT is issued Explanation: AUDIT_ CHANGE_GROUP event is raised whenever CREATE SERVER AUDIT is issued.

59.	Which of the following is server-level audit action group?(a) BACK_RESTORE_GROUP(b) BACKUP_RESTORE_GROUP(c) DB_LOGOUT_GROUP(d) None of the mentionedThis question was posed to me in an interview.This intriguing question comes from Schema Audit topic in portion Monitoring and Auditing of SQL Server
Answer» The correct answer is (B) BACKUP_RESTORE_GROUP To EXPLAIN: BACKUP_RESTORE_GROUPevent is raised WHENEVER a BACKUP or restore command is issued.

60.	Which of the following event is not intrinsically audited?(a) ALTER DATABASE AUDIT SPECIFICATION(b) CREATE SERVER AUDIT SPECIFICATION(c) DROP SERVER AUDIT SPECIFICATION(d) All of the mentionedThe question was asked in an internship interview.The above asked question is from Schema Audit in section Monitoring and Auditing of SQL Server
Answer» CORRECT ANSWER is (d) All of the mentioned The best EXPLANATION: All AUDITS are disabled when initially CREATED.

61.	Point out the correct statement.(a) You can use Source control to audit schema changes(b) The SQL Server Audit feature enables you to audit column level groups of events and individual events(c) Audit level actions encompass data manipulation languages (DML) and data definition language (DDL) operations(d) None of the mentionedThis question was addressed to me in semester exam.Asked question is from Schema Audit topic in section Monitoring and Auditing of SQL Server
Answer» Right option is (a) You can use Source CONTROL to audit SCHEMA changes Easiest explanation: Whether you do or not, this code in source control will need to be stored SEPARATELY from your development code in order to isolate keeping track of PRODUCTION changes from your development PROCESSOR.

62.	How many ways of auditing the schema is available in SQL Server?(a) 2(b) 3(c) 4(d) 5The question was asked in an internship interview.My question is taken from Schema Audit topic in chapter Monitoring and Auditing of SQL Server
Answer» The correct ANSWER is (a) 2 For explanation: There are mainly two WAYS to audit:Using BACKUPS and Scripts in SQL Server.