Question: When using the ALTER TABLE command to modify an existing table Question 6 options: a) You can modify the table without having to shut down

When using the ALTER TABLE command to modify an existing table

Question 6 options:

a)

You can modify the table without having to shut down the database

b)

Even if users are accessing the table, it can be modified without disrupting the service

c)

Both a and b

d)

Neither a nor b

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!

Q:

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...

Q:

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS Successful people did not attain their success without first overcoming challenges.------- Catherine Pulsifer FOLLOW...

Q:

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS FOLLOW INSTRUCTIONS: DO NOT SKIP A SINGLE STEP SECTION I: NOTE: Do not specify any constraints with the create statement...

Q:

In this exercise, you will practice creating a table of given specifications. You will then add and modify data: Concepts you will need to know: How to create a table using either the designer or by...

Q:

Write SQL queries for the database and questions below. Question 1. Find how many unique artists produced at least 1 classical songs. Question 2. For each genre of songs that has songs(one or more)...

Q:

Question 1. 1. (TCO 3) The _____ column attribute will provide a value for a field if none is specified. (Points : 3) DEFAULT AUTO_INCREMENT VALUE NOT NULL Question 2. 2. (TCO 5) The _____ keyword is...

Q:

I am looking for the solution or guidance with the following case study. The case study has been asked about by other students but I cannot find the solution. can you direct me to it or provide some...

Q:

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...

Q:

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Q:

please help me with number 1,2,3,4,5,6,7,8,9,10,11,12,13,14 You need to create a table for keeping customer's banking details for the JustLee Books database. One of the columns in the table has the...

Q:

Aubry purchased a washing machine, a freezer, and a refrigerator from Gateway Appliances on credit, giving Gateway a security interest in the appliances. The appliances were for Aubry's household...

Q:

Alex wants to measure the nominal 1998 GDP of $993 billion in 2008 dollars. From the data he gathered, he knows the deflator for 1998 is 30 and for 2008, it is 74, and that real interest in those...

Q:

Suppose you buy a 3 0 - day T - bill with a face value of $ 1 , 0 0 0 at a price of $ 9 9 0 . Your discount rate yield ( DRY ) would be a . 1 2 % . b . 1 0 % . c . 9 . 7 5 % . d . 1 0 . 5 % .

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

Every October, your company has an open enrollment period during which employees select their health and dental plans for the next calendar year. Once the open-enrollment period ends, no coverage...

Q:

Assume the role of the vice president of sales at Rampart Publishing. Early in February, you attended a professional conference in another state. Dr. Daniel Loman, the motivational speaker who...

Q:

Technology.Global.Dahui Lian, a Shanghai official with whom you have met on several past visits to China, is planning to come to the United States.Through your visits and subsequent e-mail exchanges,...