SQL Server uses only PRIMARY partition by default
No, if you are talking about partitioned tables, sql uses the where clause to filter rows. if your query doesn't have the where clause it will return all rows.
if you can't test your changes you probably shouldn't be making them.