Interview Questions And Answers

Q: - What is minimum privilege required for one to create a tablespace?

CREATETS privileges

Submitted By:-Jashmin            Email-ID: -kaur.jashmin@gmail.com

Q: - What is a foreign key?

A foreign key is the key defined in one table to reference the primary key of a reference table. This foreign key must have the same structure as the reference table’s primary key.

Submitted By:-Jashmin            Email-ID: - kaur.jashmin@gmail.com

Q: - What is the basic difference between a join and a union?

A join selects columns from 2 or more tables. A union selects rows.

Submitted By:-Jashmin            Email-ID: - kaur.jashmin@gmail.com