Question

7- The values of a Foreign Key column in a table can be referenced to any column in a second table (Primary key or non-primary key). TRUE FALSE) 8- Using WITH GRANT OPTION clause will result in granting the user the authority to pass ONLY his/her privileges to other users. TRUE FALSE ) 9. To change the characteristics of a column, use the ALTER TABLE command with a SET clause. TRUE FALSE) 10- When inserting new values into a table from another table, the data type of columns in both tables must match but the columns names may differ. TRUE FALSE )

Answer 1

If you find this helpful, then please leave a like.

Q7. FALSE

The values of a Foreign key column in a table must only refer a Primary Key column of another table. The values in a foreign key column represent a unique column in the referencing table. So it's values have to be unique. So it has to be a Primary Key column.

Q8. TRUE

The person granting the permissions needs to have the permission. If that were not true, Person A can grant all permissions to a Fake Person B and Person B, in turn, can grant all the permissions to Person A.

Q9. TRUE

Some examples are

ALTER TABLE table01 ALTER COLUMN col1 SET NOT NULL;

ALTER TABLE table01 ALTER COLUMN col1 SET DEFAULT 'abc';

Q10. TRUE

For example:

INSERT INTO tableB (col1, col2, col3) SELECT (colA,colB,colC) FROM tableA WHERE condition;

If they are not of the same datatypes, the operation will fail.