In SQL, which command is used to add a column/integrity constraint to a table

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?

A

T

B

U

C

V

D

Z

In SQL, which command is used to add new rows to a table?

A

Alter Table

B

Add row

C

Insert

D

Append

What SQL command can be used to add columns to a table?

A

ALTER TABLE TableName ADD ColumnName

B

ALTER TABLE TableName ADD COLUMN ColumnName

C

MODIFY TABLE TableName ADD ColumnName

D

MODIFY TABLE TableName ADD COLUMN ColumnName

Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

A

DEFINE TABLE

B

MODIFY TABLE

C

ALTER TABLE

D

All of the above

E

None of the above

You have time constraint to answer the questions: Here the word `constraint' stands for______.

A

Restrcition

B

Consciousness

C

Relaxation

D

Extension

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 ?

A

M,S,R,T,P,O

B

M,S,T,P,R,O

C

T,O,P,S,M,R

D

T,R,M,P,S,O

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?

A

M and O

B

M and S

C

O and R

D

O and S

Which of the following is NOT a type of SQL constraint?

A

PRIMARY KEY

B

ALTERNATE KEY

C

FOREIGN KEY

D

UNIQUE

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 M sits next to P which of the following is a complete and accurate list of those who can sit next to P on P's other side ?

A

O

B

O,S

C

O,S,R

D

R,S,T

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 next to M and S sits next to R, which of the other negotiators must sit next to s ?

A

M

B

O

C

P

D

R

In SQL, which command is used to add a column/integrity constraint to a table

Related Questions