Bissoy.com
Doctors Medicines MCQs Q&A

What does the ALTER TABLE clause do?

What does the ALTER TABLE clause do? Correct Answer The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The ALTER TABLE statement is used to add, delete, or modify columns.

Related Questions

Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. Which of the following is an acceptable sequence of negotiators around the table ?
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. If T sits directly across the table from O, who must sit on the other side of P?
Read the given seating arrangement information and answer the question that follows. Prashant, Kamal, Rishi, Sunita, Tanvi, Vimal, Wazir and Yogita are sitting at a square table in such a way that four of them are sitting at four corners of the table, while the other four are sitting in the middle of each of four sides of the table. The four who are sitting at the corners of the table are facing the centre, whereas those who are sitting in the middle of the sides of the table are facing outside. Prashant, who is facing the centre, is sitting third to the right of Vimal. Tanvi, who is facing the centre, is not an immediate neighbour of Vimal. Only one person is sitting between Vimal and Wazir. Sunita sits second to the right of Kamal. Kamal is facing the centre. Rishi is not an immediate neighbour of Prashant. Which of the following statements regarding Kamal is true?
Consider a database table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;
Which of the following statement(s) is/are false regarding the modern periodic table? i. In the modern periodic table, the elements are arranged in decreasing order of their atomic numbers. ii. In the modern periodic table, the elements are arranged in increasing order of their atomic masses. iii. In the modern periodic table, isotopes are placed in adjacent groups. iv. In the modern periodic table, the elements are arranged in increasing order of their atomic numbers.
Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
Ranjan purchased 120 tables at a price of Rs. 110 per table. He sold 30 tables at a profit of Rs. 12 per table and 75 tables at a profit of Rs. 14 per table. The remaining tables were sold at a loss of Rs. 7 per table. What is the average profit per table ?
Which of the following statements is/are false regarding modern periodic table?
1. Elements in the modern periodic table are arranged in decreasing order of their atomic numbers.
2. Elements in the modern periodic table are arranged in increasing order of their atomic masses.
3. In the modern periodic table, isotopes are placed in adjacent groups.
4. Elements in modern periodic table are arranged in increasing order of their atomic numbers.