Question: 1. In SQL is UPDATE considered a DDL (Data Definition Language) commmand ? I was told it is but online the only commands listed as

1. In SQL is UPDATE considered a DDL (Data Definition Language) commmand ? I was told it is but online the only commands listed as DDL are CREATE: ALTER: DROP: TRUNCATE: COMMENT: RENAME:

2. Can you please define the function of the DDL command TRUNCATE? What does it do and how would you write a TRUNCATE command?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Question 1 (3 points) Saved When performing a single-row INSERT statement, if you omit the list of columns into which the data will be inserted: The INSERT operation will fail You should specify the...

Please Help, I need help with the following programming assignment, please use PHP.... A software development firm had been asked to develop access control mechanism for a Database Management System...

Structured query language (SQL) is divided into two categories: data definition language (DDL) commands and data manipulation language (DML) commands. Data manipulation language (DML) is a set of...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

16. The external model yields some advantages such as ______________ a. use of the database subsets to make application program development much simpler. b. use of the database subsets to make...

CMIS 320 Project 3 In this assignment you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store...

The Review Questions 7.3 to 7.40, from the Kroenke book starting page 357, have been duplicated below, to assist in the completion of this Lab Assignment. RQ Questions 7.1, 7.2 and 7.3 are answered...

In this assignment you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data...

Managers of the New Hope and Ivy land Short Line Railroad conducted an experiment in which they reduced fares by about 28% for approximately a year to estimate the price elasticity of demand. This...

How could we use the margin of safety to calculate the percent change in profit given a percent change in sales?

2 A prepaid expense would be classified as an expense. 5 an unearned revenue. a liability. an asset. cost of goods sold.

In general, higher liquidity ratios indicate higher levels of liquidity and ability to meet short - term obligations. True or False?

Ethics.Teamwork. A manager of a department store tries to follow a company policy that prohibits off-the-clock work requirements of employees;however, store managers have to keep payroll costs below...

Search the Internet to learn about the International Association of Virtual Assistants. Answer the following questions: a. How large is the groups membership? b. What are the dues? c. What are the...

Locate an example of a contract. Describe the four essential elements applicable to this contract. a. Offer and acceptance b. Competency of parties c. Legality of subject matter d. Consideration