©THESTAR 2024/2025 ALL RIGHTS RESERVED 9:50PM.
Oracle 12c SQL (ICT 3722) Exam Questions
And Answers |Latest 2025 | Guaranteed Pass.
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
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
1
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED 9:50PM.
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
Bridging Entity - Answer✔A "many to many" relationship cannot exist in a relational database.
The most common approach to eliminating a "many to many" relationship is to create two "one
to many" relationships by adding a bridging entity. A bridging entity is placed between the
original entities and serves as a "filter" for the data.
Lookup Table - Answer✔is a common description for a table referenced in a foreign key
relationship. often used in application development to provide values in a selection list for a
user to choose one for data input.
SQL - Answer✔The industry standard to interact with a relational database. (Structured Query
Language)
Name the Five types of SQL commands - Answer✔Query
-SELECT
--Retrieve data values
Data Manipulation Language (DML)
-INSERT, UPDATE, DELETE
--Create or modify values
Data Definition Language (DDL)
-CREATE, ALTER, DROP
--Define data structure
Transaction Control (TC)
-COMMIT, ROLLBACK
--Save or undo data value modifications
2
Oracle 12c SQL (ICT 3722) Exam Questions
And Answers |Latest 2025 | Guaranteed Pass.
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
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
1
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED 9:50PM.
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
Bridging Entity - Answer✔A "many to many" relationship cannot exist in a relational database.
The most common approach to eliminating a "many to many" relationship is to create two "one
to many" relationships by adding a bridging entity. A bridging entity is placed between the
original entities and serves as a "filter" for the data.
Lookup Table - Answer✔is a common description for a table referenced in a foreign key
relationship. often used in application development to provide values in a selection list for a
user to choose one for data input.
SQL - Answer✔The industry standard to interact with a relational database. (Structured Query
Language)
Name the Five types of SQL commands - Answer✔Query
-SELECT
--Retrieve data values
Data Manipulation Language (DML)
-INSERT, UPDATE, DELETE
--Create or modify values
Data Definition Language (DDL)
-CREATE, ALTER, DROP
--Define data structure
Transaction Control (TC)
-COMMIT, ROLLBACK
--Save or undo data value modifications
2
