1. What does DDL stand for? List the SQL DDL statements
Data Definition Language, is used to remove database objects such as tables, indexes and users. It is necessary to be conscious of the database you are working in before issuing SQL commands such as DDL that can manipulate data. Create, alter and drop schema objects are considered DDL statements. Chapple, M. (2015). Data Defintion Language. Retrieved June 7, 2015. 2. What is a user-defined function? User defined functions in SQL is simply a programmed routine which its parameters are set by the user of a system such as a database or spreadsheet program.
In order to utilize user-defined functions, the user must have been granted CREATE function permissions to create, alter or drop user-defined functions. 3. What is the relationship between a trigger and a table or view? …show more content…
Triggers are automatic. They are activated immediately after any modification to a tables data. Triggers can also cascade changes through related tables within a database. The trigger uses the title_id column as a unique key to locate matching rows. Triggers can also enforce restrictions that are more complex than those defined within check constraints. Harmon, M. (2013, April 13). Retrieved June 7, 2015. 4. Summarize the key advantages of stored procedures.
Stored procedures allow modular programming and faster execution to reduce network traffic. An SQL server stored procedure with the SQL CREATE procedure statement can be modified with the ALTER PROCEDURE statement. A stored definition contains two primary components. The procedure name and its parameters, and the body of the procedure. 5. Review the three sources of database design and