Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 4 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.

IF_XP_CMDSHELL_HAS_BEEN_DISABLED_WITH_SP_DROPEXTENDEDPROC,_WE_CAN_SIMPLY_INJECT_THE_FOLLOWING_CODE:?$

A. sp_addextendedproc ‘xp_cmdshell’,’xp_log70.dll’
B. sp_addproc ‘xp_cmdshell’,’xp_log70.dll’
C. sp_addextendedproc ‘xp_cmdshell’,’log70.dll’
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
2.

Which of the stored procedure is used to test SQL injection attack ?

A. xp_write
B. xp_regwrite
C. xp_reg
D. All of the mentioned
Answer» C. xp_reg
Discussion
3.

Any user-controlled parameter that gets processed by the application includes vulnerabilities like :

A. Host-related information
B. Browser-related information
C. Application parameters included as part of the body of a POST request
D. All of the mentioned
Answer» B. Browser-related information
Discussion
4.

SQL injection is an attack in which _________ code is inserted into strings that are later passed to an instance of SQL Server.

A. malicious
B. redundant
C. clean
D. non malicious
Answer» B. redundant
Discussion