Multiple choice technology security

A tool that can perform ODBC commands on a SQL Server

  1. PSQL

  2. SQLCMD

  3. OSQL

  4. Postgre SQL
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

OSQL is a legacy command-line utility for SQL Server that uses ODBC APIs to run queries. PSQL and PostgreSQL are associated with PostgreSQL, and SQLCMD uses OLE DB or modern drivers rather than primarily targeting raw ODBC commands.

AI explanation

To answer this question, you need to be familiar with the different tools that can perform ODBC commands on a SQL Server.

Option A) PSQL - PSQL is a command-line tool for interacting with PostgreSQL databases. It is not specifically designed for performing ODBC commands on a SQL Server.

Option B) SQLCMD - SQLCMD is a command-line tool provided by Microsoft for managing and executing SQL Server commands. It supports ODBC connectivity and can be used to perform ODBC commands on a SQL Server. However, it is not the correct answer in this case.

Option C) OSQL - OSQL is a command-line tool provided by Microsoft for managing and executing SQL Server commands. It supports ODBC connectivity and can be used to perform ODBC commands on a SQL Server. This is the correct answer.

Option D) Postgre SQL - Postgre SQL is an open-source relational database management system (RDBMS), similar to SQL Server but not specifically designed for it. It does not provide native support for ODBC commands on a SQL Server.

The correct answer is C) OSQL. This option is correct because OSQL is a command-line tool provided by Microsoft that supports ODBC connectivity and can be used to perform ODBC commands on a SQL Server.

Keep practicing — related questions