DBMS 110 Final 2025/2026 Exam
Questions and Detailed Answers | Get it
100% Correct Answers
According to the reading you can connect to an Oracle Database using
SQL*Plus
Correct!
True - 🧠ANSWER ✔✔True
SQL provides an interface to a - 🧠ANSWER ✔✔Relational Database
Data is stored in a two-dimensional matrix known as a - 🧠ANSWER ✔✔File
SQL stands for Structured question language - 🧠ANSWER ✔✔False
What is the second stage of the SQL processing? - 🧠ANSWER
✔✔Optimization
DDL stands for Data Definition Language - 🧠ANSWER ✔✔True
Table names and column names can start with number value. - 🧠ANSWER
✔✔False
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
1
STATEMENT. ALL RIGHTS RESERVED
, To issue a CREATE TABLE statement, you must have: - 🧠ANSWER
✔✔You can logically relate data from multiple tables using
A DML statement is executed when you: - 🧠ANSWER ✔✔Add new rows to
a table
Add rows to a table by using? - 🧠ANSWER ✔✔INSERT
Values for a specific row or rows are modified if you specify the clause. -
🧠ANSWER ✔✔WHERE
The function records the current date and time. - 🧠ANSWER
✔✔SYSDATE()
A consists of a collection of DML statements that form a logical unit of
work. - 🧠ANSWER ✔✔transaction
Which of the following statements modify existing values in a table? -
🧠ANSWER ✔✔UPDATE
The ROLLBACK rolls the database back to factory setting. - 🧠ANSWER
✔✔F
You can remove existing rows from a table by using the statement. -
🧠ANSWER ✔✔DELETE
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
2
STATEMENT. ALL RIGHTS RESERVED
Questions and Detailed Answers | Get it
100% Correct Answers
According to the reading you can connect to an Oracle Database using
SQL*Plus
Correct!
True - 🧠ANSWER ✔✔True
SQL provides an interface to a - 🧠ANSWER ✔✔Relational Database
Data is stored in a two-dimensional matrix known as a - 🧠ANSWER ✔✔File
SQL stands for Structured question language - 🧠ANSWER ✔✔False
What is the second stage of the SQL processing? - 🧠ANSWER
✔✔Optimization
DDL stands for Data Definition Language - 🧠ANSWER ✔✔True
Table names and column names can start with number value. - 🧠ANSWER
✔✔False
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
1
STATEMENT. ALL RIGHTS RESERVED
, To issue a CREATE TABLE statement, you must have: - 🧠ANSWER
✔✔You can logically relate data from multiple tables using
A DML statement is executed when you: - 🧠ANSWER ✔✔Add new rows to
a table
Add rows to a table by using? - 🧠ANSWER ✔✔INSERT
Values for a specific row or rows are modified if you specify the clause. -
🧠ANSWER ✔✔WHERE
The function records the current date and time. - 🧠ANSWER
✔✔SYSDATE()
A consists of a collection of DML statements that form a logical unit of
work. - 🧠ANSWER ✔✔transaction
Which of the following statements modify existing values in a table? -
🧠ANSWER ✔✔UPDATE
The ROLLBACK rolls the database back to factory setting. - 🧠ANSWER
✔✔F
You can remove existing rows from a table by using the statement. -
🧠ANSWER ✔✔DELETE
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
2
STATEMENT. ALL RIGHTS RESERVED
