×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Review the following ER diagram:
Which of the following queries will properly display the average unit_cost (rounded to two decimal places) for a given product on a Saturday and Order the results by the PROD_NAME column?
Which of the following queries will properly display the average unit_cost (rounded to two decimal places) for a given product on a Saturday and Order the results by the PROD_NAME column?
2.
Which of the following SQL functions may require the use of a GROUP BY clause in a
SELECT statement?
Each correct answer represents a complete solution. Choose all that apply.
3.
You work as a Database Administrator for Pass4sure.com. You create a database that has a table named
Students. The table is used for storing the records of students. Due to security reasons, you want to
permanently remove all data from the table without removing the table structure.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
4.
Which of the following clauses is used with the CREATE VIEW statement?
5.
Which of the following clauses is used with the CREATE VIEW statement?
6.
You work as a Database Administrator for Realtech Inc. A database has a table named Product. The auto commit mode of the database is turned off. You want to perform an update on the Product table. Which of the
following queries will permanently save the changed value of ProductID in the table?
1. UPDATE Product
SET COST=49.90
WHERE ProductID='121'
2. UPDATE Product
SET COST=49.90
WHERE ProductID='121'
COMMIT
following queries will permanently save the changed value of ProductID in the table?
1. UPDATE Product
SET COST=49.90
WHERE ProductID='121'
2. UPDATE Product
SET COST=49.90
WHERE ProductID='121'
COMMIT
7.
You work as a Database Administrator for Pass4sure.com. You have written the following code for creating a view:
CREATE VIEW Student_View
AS SELECT Stu_ID, Stu_Description
FROM Students
WHERE Stu_ID = 512
ORDERED BY Stu_Description;
After executing the above code, you got an error. Which of the following statements is incorrect in the view?
CREATE VIEW Student_View
AS SELECT Stu_ID, Stu_Description
FROM Students
WHERE Stu_ID = 512
ORDERED BY Stu_Description;
After executing the above code, you got an error. Which of the following statements is incorrect in the view?
8.
Which of the following statements is true about the GROUP BY clause?
9.
You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database.
You have created a table named Employees in the database. The structure of the table is as follows:
Now, you want to rename the Emp_join_date column to Joining_date. Which of the following statements is true according to the scenario?
You have created a table named Employees in the database. The structure of the table is as follows:
Now, you want to rename the Emp_join_date column to Joining_date. Which of the following statements is true according to the scenario?
10.
Which of the following statements will a user use to display a database in MySQL?