You are providing command specifications for a datbase application. The specific

Question

You are providing command specifications for a datbase application. The specific DBMS product has not been chosen, so for the initial draft you are using sample commands and functions using SQL standard syntax.

1. You want to create a table name Ops.Quick Check. You are not defining a primary key or any constraint at this time. The column names and data types are listed below. What statement would you run?

Validation char(4)

EnterBy int

CheckBy int

Status varchar(20)

Suppose you need to periodically delete and recreate Ops.QuickCheck. How would you remove the table from the database?

Explanation / Answer

CheckBy int

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

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