I need help with SQl questions. Thanks 1. Describe how a user, already logged on

ID: 3719254 • Letter: I

Question

I need help with SQl questions. Thanks

1. Describe how a user, already logged on, would change the default directory?

2. Why would a user want to change the default directory?

3. Consider the following syntactically valid SELECT statement:

SELECT DISTINCT city, state FROM MyTable;

What is the effect of the keyword DISTINCT, i.e., how does DISTINCT function in the above SELECT statement?

4. What is the purpose of an alias? List three (3) circumstances when it is necessary to use a column alias in a SELECT statement?

1. You can change the default directory in the settings of the SQL server.

2. If the user wants to make use files of another directory then the user changes the default directory.

3. DISTINCT is used to find the unique items in a table.

a. Assign a temporary name to the column

b. To hide the real column name of table

c. Make column names more readable.

**Comment for any further queries.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.