Describe how TCP/IP is used in SQL Server 2012 remote connectivity.
What will be an ideal response?
TCP/IP is the most common protocol used for remote connectivity. The default instance of SQL Server is configured to listen on TCP port 1433; other TCP ports are assigned for a named instance dynamically when the database engine service starts.
You might also like to view...
Assume a PHP document named hello.php has been saved in a folder named carla inside the htdocs folder on your computer. Which is the correct path to enter to view this page in a browser?
a. localhost/Carla/hello.php b. localhost/htdocs/hello.php c. localhost/htdocs/Carla/hello.php d. carla/hello.php
Files saved as templates use the ________ extension
A) .pptx B) .ppsx C) .potx D) .potm
What type of packet-filtering rules are typically defined?
What will be an ideal response?
When writing a program, a(n) ____ structure provides the ability for the same operation to be repeated based on the value of a condition.
A. sequence B. selection C. iteration D. invocation