Suppose you created a PRIMARY KEY constraint at the same time you created a table and later
Question:
Suppose you created a PRIMARY KEY constraint at the same time you created a table and later decide to name the constraint. Which of the following commands can you use to change the constraint’s name?
a. ALTER TABLE…MODIFY
b. ALTER TABLE…ADD
c. ALTER TABLE…DISABLE
d. None of the above commands can be used.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 68% (19 reviews)
d None o...View the full answer
Answered By
Akshay Singla
as a qualified engineering expert i am able to offer you my extensive knowledge with real solutions in regards to planning and practices in this field. i am able to assist you from the beginning of your projects, quizzes, exams, reports, etc. i provide detailed and accurate solutions.
i have solved many difficult problems and their results are extremely good and satisfactory.
i am an expert who can provide assistance in task of all topics from basic level to advance research level. i am working as a part time lecturer at university level in renowned institute. i usually design the coursework in my specified topics. i have an experience of more than 5 years in research.
i have been awarded with the state awards in doing research in the fields of science and technology.
recently i have built the prototype of a plane which is carefully made after analyzing all the laws and principles involved in flying and its function.
1. bachelor of technology in mechanical engineering from indian institute of technology (iit)
2. award of excellence in completing course in autocad, engineering drawing, report writing, etc
4.70+
48+ Reviews
56+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
What is the difference between a PRIMARY KEY constraint and a UNIQUE constraint?
-
Which of the following statements is correct? a. A PRIMARY KEY constraint allows NULL values in the primary key column(s). b. You can enable a dropped constraint if you need it in the future. c....
-
You issue the following command: INSERT INTO homework10 (col1, col2, col3) VALUES (A, NULL, C). The command will fail if which of the following statements is true? a. Col1 has a PRIMARY KEY...
-
Explain how the structure of the balance sheet corresponds to the accounting equation.
-
During 2017, Aubergine Co. borrowed cash from Chartreuse Company by issuing notes payable as follows: 1. July 1, 2017, issued an eight-month, 4% note for $75,000. Interest and principal are payable...
-
What method was most likely used to negotiate the instruments described here? The Brown family owns several companies, including the J. H. Stevedoring Company and Penn Warehousing and Distribution,...
-
Distinguish between the main approaches to impact assessment. Explain the three steps that lead to construction of an EIA index. Can environmental impact added ever be negative?
-
Jay Company has had a defined benefit pension plan for several years. At the beginning of 2016, Jay amended the plan; this amendment provided for increased benefits to employees based on services...
-
Iron Man turns off his boosters and begins to fall through the atmosphere 2 km above the Earth's surface, where the density of the air is 0.94 kg/m. If Iron man's suit has a drag coefficient of 0.47,...
-
Trace or copy the graph of the given function f. (Assume that the axes have equal scales.) Then use the method of Example 1 to sketch the graph of f' below it. yA
-
Which of the following types of constraints cant be created at the table level? a. NOT NULL b. PRIMARY KEY c. CHECK d. FOREIGN KEY e. None of the above constraints can be created at the table level.
-
Youre creating a new table consisting of three columns: Col1, Col2, and Col3. Col1 should be the primary key and cant have any NULL values, and each entry should be unique. Col3 must not contain any...
-
(a) What is the difference between chlorofluorocarbons and hydrofluorocarbons? (b) Why are hydrofluorocarbons potentially less harmful to the ozone layer than CFCs?
-
Today, interest rates on 1-year T-bonds yield 1.3%, interest rates on 2-year T-bonds yield 2.4%, and interest rates on 3-year T-bonds yield 3.5%. a. If the pure expectations theory is correct, what...
-
How are direct materials, direct labor, and manufacturing overhead allocated in a job order cost system?
-
Draw a class diagram for the following code. Your diagram must include the classes, their attributes, visibility (private/public), methods, association, generalization, aggregation, and multiplicity...
-
Gibson manufacturing established the following standard price and cost data Sales price $8.90 per unit Variable manufacturing cost $4.00 per unit fixed manufacturing cost $2,400 total fixed selling...
-
What are 2 ways in which a company's STOCKHOLDER'S EQUITY would be increased. 2). Discuss the differences between a) authorized shares, b) issued shares, and c) outstanding shares. 3). What is...
-
Compute the time required to reduce the depth in the tank shown in Fig. 6.14 by 225 mm if the original depth is 1.38 m. The tank diameter is 1.25 m and the orifice diameter is 25 mm. dh
-
Refer to the table to answer the following questions. Year Nominal GDP (in billions) Total Federal Spending (in billions) Real GDP (in billions) Real Federal Spending (in billions) 2000 9,817 578...
-
If the vertices of the graph from Figure 14.11 are ordered as (JFK, LAZ, MIA, BOS, ORD, SFO, DFW), in what order would edges be added to the transitive closure during the Floyd-Warshall algorithm?...
-
Compute a topological ordering for the directed graph drawn with solid edges in Figure 14.3d. BOS ORD JFK SFO (DFW (LAX MIA (d)
-
Bob loves foreign languages and wants to plan his course schedule for the following years. He is interested in the following nine language courses: LA15, LA16, LA22, LA31, LA32, LA126, LA127, LA141,...
-
Solutions Inc. signs a 10-year lease for a building owned by Property Inc. that is appropriately classified as an operating lease by both the lessee and lessor. Lease payments are $150,000 per year....
-
1] The following information is available for Blasser Company. In preparation of the Statement of Cash Flows Net Income Depreciation Expense $187,500 $49,500 Loss on sale of equipment $3,000 Increase...
-
Wagner Enterprise sells two products, large tractors and small tractors. A large tractor sells for $62,000 per unit with variable costs of $28,520 per unit. Small tractors sell for $34,000 per unit...
Study smarter with the SolutionInn App