- Study guides, Class notes & Summaries

Oracle 12c SQL Joan Casteel chapter 4 Questions with Correct Answers Fully Solved Which of the following statements about creating constraints is incorrect? a. When you create constraints at the column level, the constraint being created applies to the column specified b. The NOT NULL constraint can be created at either the column level or the table level c. Using the column level approach, the definition of the constraint is included as part of the column definition d. If a constraint app...

-

5 pages

Written in 2024/2025

Grade A+

TutorJosh

Oracle 12c SQL (ICT 3722) Exam Questions And Answers Verified 100% Correct How to normalize from 1NF to 3NF - ANSWER -Steps in Order 1.Remove all repeating groups. Once the repeating groups have been removed the table will be in 1NF 2.Select primary key 3.If composite primary key is chosen, make sure there are no partial dependencies. Once step 2&3 have been done the table should be in 2NF 4.Next step is to look for any transitive dependency Foreign Key - ANSWER -A fore...

-

5 pages

Written in 2025/2026

Grade A+

TheExamMaestro