INF3707 – University Exam Preparation (2025–2026) – Verified Questions and Answers for Exam Bank Revision

INF3707 – EXAM BANK PREP
QUESTIONS WITH VERIFIED
ANSWERS GRADED A+ 2025-2026.
INF3707




BIGGYPERFECT STUVIA
SMART STUDY

, INF3707 – EXAM BANK PREP
QUESTIONS WITH VERIFIED ANSWERS
GRADED A+ 2025-2026.

,Which of the following is an interface that allows a user to create, edit, and manipulate
data on Oracle Database management System?


1. SQL


2. SQL* plus


3. ASCII


4. Database ANSWER >> 2. SQL* plus


Which of the following symbols is used for a column alias containing spaces?




1. Single quotation marks (' ')


2. Pipe (| |)


3. Double quotation marks (" ")


4. Percentage signs (% %) ANSWER >> 3. Double quotation marks (" ")


Which of the following are used to enforce business rules?




1. Syntax


2. Functions

, 3. Constraints


4. Foreign rules ANSWER >> 3. Constraints


If a PRIMARY KEY constraint named myTable_PK exists for the Col1# and Col2#
columns of the myTable table, which of the following commands will disable the
constraint?




1. Alter table myTable disable primary key constraint;


2. Alter table myTable disable constraint myTable_PK;


3. Alter table myTable remove primary key constraint;


4. Alter table myTable modify primary key constraint disable; ANSWER >> 2. Alter
table myTable disable constraint myTable_PK;


Which of the following commands will increase the size of the col1 column of the
myTable from 12 to 20?




1. Alter table myTable modify (col1 VARCHAR2(+8));


2. Alter table myTable modify (col1 VARCHAR2(20));


3. Alter table myTable modify (col1 (+8));