©EVERLY 2024/2025 ALL RIGHTS RESERVED.
Oracle 12c SQL (ICT 3722) Exam Questions
And Answers (Guaranteed 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
1NF - Answer✔indicates that all values of the columns are atomic - meaning that they contain no
repeating groups
1|Page
, ©EVERLY 2024/2025 ALL RIGHTS RESERVED.
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
4.Next step is to look for any transitive dependency
Foreign Key - Answer✔A foreign key is established by a connection between 2 tables by using a
common field. The foreign key appears in the many side of a "one to many" relationship
2|Page
Oracle 12c SQL (ICT 3722) Exam Questions
And Answers (Guaranteed 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
1NF - Answer✔indicates that all values of the columns are atomic - meaning that they contain no
repeating groups
1|Page
, ©EVERLY 2024/2025 ALL RIGHTS RESERVED.
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
4.Next step is to look for any transitive dependency
Foreign Key - Answer✔A foreign key is established by a connection between 2 tables by using a
common field. The foreign key appears in the many side of a "one to many" relationship
2|Page
