Question: 1. When removing tables, we should first Drop a) The parent table b) The child table c) It doesnt matter 2. Define the datatypes in

1. When removing tables, we should first Drop

a) The parent table b) The child table c) It doesnt matter

2. Define the datatypes in SQL we use the Data Definition Language (DDL). We use the CREATE TABLE to create new table and ALTER TABLE to modify the definitions. In MS-Access, we can do this with the:

a) Datasheet view b) Design view c) SQL view

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!

In this worksheet you will learn how to use SQL as a data definition language ( DDL ) . DDL commands allow you to create, alter, and drop tables. Selected questions refer you to pages in your...

STEP 1: Create Data Dictionary for provided elements As the DBA for your company, you have decided to install a new version of the MySQL database to replace the current database version being used....

CHAPTER 3 1. Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You cant create...

Assignment 1: Setting up Databases (15%) This assignment relates to the following Cowrse Learning Requirements: CLR 1 - Plan, Prepare, Install, Configure, and Use a market-leading Database Management...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

The new line character is utilized solely as the last person in each message. On association with the server, a client can possibly (I) question the situation with a client by sending the client's...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You cant create empty tablesall...

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

List possible ways to track the presence of a protein during its purification.

Entries for Issuing Bonds and Amortizing Discount by Straight-Line Method On the first day of its fiscal year, Chin Company issued $29,400,000 of five-year, 9% bonds to finance its operations of...

The Global Community Bank, under terms of its long - term baniking agreement with the company, has agreod to lend the compary addritional monies should you elect to use debt to help finance growth...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

5. Why do you think system performance in terms of waiting time changed as it did? Why did customer behavior changed as it did?

3. How effective is the memo in Exhibit 4 in clarifying the distinction between sell and non-sell time?

4. How would you redesign compensation and performance appraisal systems at R&R? Is the sales-per-hour system an effective measure of customer satisfaction? Are R&Rs HR policies and practices fully...