View data. Delete data. Modify constraints. Give update access to other users. l

Question

       View data.
       Delete data.
       Modify constraints.
       Give update access to other users.

last name is Brown, Chan, or Lindsey;

job is manager, technician, or clerk; and

salary is greater than $30,000.

Review this query.
SELECT CONCAT(FirstName, ' ', LastName) AS CustomerName,
Street, City, State, ZipPostalCode
FROM CUSTOMER
ORDER BY CustomerName;

Create a stored function named FirstNameFirst() so that the following query will generate the same output as the above query.

SELECT FirstNameFirst(FirstName, LastName) AS CustomerName,
Street, City, State, ZipPostalCode
FROM CUSTOMER
ORDER BY CustomerName;

You are the DBA of a development project. Your developers are arguing about whether to write a query using a join, a subquery, a correlated subquery, or a set operator. Each faction claims that one method performs better than the others. Write a brief synopsis that tells the developer how to prove whether one query performs better than another. Include the different factors that affect performance for queries.

You issue this command:
Grant update on employee to Sally with grant option;
Which task could Sally perform on the employee table? (Points : 5)

Explanation / Answer

Note : Multiple Questions asked

Question:

You are the DBA of a development project. Your developers are arguing about whether to write a query using a join, a subquery, a correlated subquery, or a set operator. Each faction claims that one method performs better than the others. Write a brief synopsis that tells the developer how to prove whether one query performs better than another. Include the different factors that affect performance for queries.

Answer

Each query in database has its own significance. You have to remember these 6 things as a developer while implementing these queries:

In layman’s words

These things which Database is made for

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

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