Oracle 12c SQL (ICT 3722) 2024/2025
Exam Comprehensive Questions and
Verified Answers | Accurate Solutions |
Get it 100% Correct!! | Already Graded
A+
Intelligent Key or Natural Key - 🧠ANSWER ✔✔when data that already exists for
example a book's ISBN is used as a primary key.
Surrogate Key or Artificial Key - 🧠ANSWER ✔✔if there is no data that exists that
could be used as a primary key, a system generated ID is used as a primary key
Database Management System - 🧠ANSWER ✔✔Its functions of a DBMS
1)Data Storage
2)Security
3)Multiple User Access
4)Backups
5)Data Access Language
6)Data Integrity
7)Data Dictionary
Page 1 of 9
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER:
619652435. TERMS OF USE. PRIVACY STATEMENT. ALL RIGHTS RESERVED
, 1NF - 🧠ANSWER ✔✔indicates that all values of the columns are atomic -
meaning that they contain no repeating groups
Composite Primary Key - 🧠ANSWER ✔✔When more than 1 field is used as the
primary key for a table.
Partial Dependency - 🧠ANSWER ✔✔Means that the fields contained in a record
are only dependent on one portion of the primary key
2NF - 🧠ANSWER ✔✔A table is in 2NF when there is no partial dependency on a
composite primary key.
Transitive dependency - 🧠ANSWER ✔✔means that at least one value in the
record isn't dependent on the primary key but on another field in the record
3NF - 🧠ANSWER ✔✔Once all transitive dependencies are removed from a table
that is in 2NF, only then is a table considered in 3NF
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
Page 2 of 9
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER:
619652435. TERMS OF USE. PRIVACY STATEMENT. ALL RIGHTS RESERVED
Exam Comprehensive Questions and
Verified Answers | Accurate Solutions |
Get it 100% Correct!! | Already Graded
A+
Intelligent Key or Natural Key - 🧠ANSWER ✔✔when data that already exists for
example a book's ISBN is used as a primary key.
Surrogate Key or Artificial Key - 🧠ANSWER ✔✔if there is no data that exists that
could be used as a primary key, a system generated ID is used as a primary key
Database Management System - 🧠ANSWER ✔✔Its functions of a DBMS
1)Data Storage
2)Security
3)Multiple User Access
4)Backups
5)Data Access Language
6)Data Integrity
7)Data Dictionary
Page 1 of 9
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER:
619652435. TERMS OF USE. PRIVACY STATEMENT. ALL RIGHTS RESERVED
, 1NF - 🧠ANSWER ✔✔indicates that all values of the columns are atomic -
meaning that they contain no repeating groups
Composite Primary Key - 🧠ANSWER ✔✔When more than 1 field is used as the
primary key for a table.
Partial Dependency - 🧠ANSWER ✔✔Means that the fields contained in a record
are only dependent on one portion of the primary key
2NF - 🧠ANSWER ✔✔A table is in 2NF when there is no partial dependency on a
composite primary key.
Transitive dependency - 🧠ANSWER ✔✔means that at least one value in the
record isn't dependent on the primary key but on another field in the record
3NF - 🧠ANSWER ✔✔Once all transitive dependencies are removed from a table
that is in 2NF, only then is a table considered in 3NF
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
Page 2 of 9
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER:
619652435. TERMS OF USE. PRIVACY STATEMENT. ALL RIGHTS RESERVED
