1
1
Which of the following command is used to add attributes to an existing relation?
Which of the following command is used to add attributes to an existing relation?
1). modify table
2). drop table
3). set table
4). alter table
1). modify table
2). drop table
3). set table
4). alter table
This Question has 1 answers.
The alter table command to add attributes to an existing relation. All tuples in the relation are assigned null as the value for the new attribute. The form of the alter table command is
alter table r add A D;
where r is the name of an existing relation, A is the name of the attribute to be added, and D is the type of the added attribute.Similar Questions
- In an alloy, zinc and copper are in the ratio 1 : 2. In the second alloy, the same elements are in the ratio 2 : 3. If these two alloys be mixed to form a new alloy in which two elements are in the ratio 5:8, the ratio of these two alloys in the new allow
- Study the following information carefully to answer these questions.A vehicle starts from point P and run 10 km towards North. It takes a right turn and runs 15 km. Now it runs 6 km after taking a left turn. Finally, it takes a left turn, runs 15 km and s
- Three measuring rods are of length 120 cm, 100 cm and 150 cm. Find the least length of the fence that can be measure an exact number of times, using any of the rods. How many times each rod will be used to measure the length of the fence?
- Suppose A is an abstract class, B is a concrete subclass of A, and both A and B have a default constructor. Which of the following is correct?1. A a = new A();2. A a = new B();3. B b = new A();4. B b = new B();
- Study the following information carefully and answer the questions given below:Each of the six persons, P, Q, R. S. T and U has travelled to different number of countries. R has travelled to more number of countries than only S and T. Q has travelled to m