Advanced SQL

Which of the term is used to describe fields in a database?

• Information
• Rows
• Properties
• Entity

Trigger is invoked before/after data row is:

• deleted

• updated

• inserted

• all answers are correct

Below are the Data Definition Command, EXCEPT

• CREATE
• ALTER
• MERGE
• SELECT

The SQL command to create a new user with password is: —CREATE USER

‘YJChin’@’localhost’ IDENTIFIED BY ‘password123’

• FALSE

• TRUE

Which of the following is the correct command to create a view?

• CREATE VIEW Inv_1 AS
• SELECT VIEW Inv_1 FROM
• CREATE TABLE VIEW Inv_1 AS
• CREATE VIEW TABLE Inv_1 FROM

What command to use if I want to execute the stored procedure through Xampp?

• EXECUTE
• EXEC
• CALL
• CALLING

Below are the procedural SQL that can be used to enhance the power of SQL, EXCEPT:

• Triggers
• Stored procedures
• Function
• View

Assume that you have the following:
CREATE FUNCTION totalPaidByCust(custID INT)
........
END
If you want to query the function, the command will be:

• CALL totalPaidByCust(3);
• SELECT totalPaidByCust(3);
• EXECUTE totalPaidByCust(3);
• None of the answer is correct

Which SQL statement can eliminate duplicate rows?

• SELECT UNIQUE

• SELECT DIFFERENT

• SELECT INDEX

• SELECT DISTINCT

Which of the following command is correct?

• CREATE TRIGGER SumTotal AFTER CREATE ON

• CREATE TRIGGER SumTotal AFTER DROP ON

• CREATE TRIGGER SumTotal AFTER DELETE ON

• CREATE TRIGGER SumTotal AFTER SELECT ON