Started on Sunday, 31 January 2021, 11:37 PM
State Finished
Completed on Monday, 1 February 2021, 12:28 AM
Time taken 51 mins 29 secs
Grade 63.00 out of 80.00 (79%)
Question 1
Correct
Mark 1.00 out of 1.00
Flag question
Question text
GRANT is a _____________________ command.
Select one:
a. DDL
b. DCL
c. All of the choices
d. DML
Feedback
The correct answer is: DCL
Question 2
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Nathaniel had accidentally deleted all the records in the newly updated ORACLE database using
the DELETE SQL command.
What is the best solution that he can do to restore all the deleted records in the database.
Select one:
a. None of the choices
b. Restore the backup copy
c. Execute the UNDELETE command
d. Run the ROLLBACK command
e. Re-encode the data
Feedback
The correct answer is: Run the ROLLBACK command
Question 3
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
Which of the following is a Data Definition Language?
Select one:
a. MERGE
b. COMMIT
c. REVOKE
d. GRANT
e. DROP
Feedback
The correct answer is: DROP
Question 4
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following SQL command will display all records with part number contains the
number 9?
Select one:
a. SELECT * FROM parts WHERE partnum IN ('%9%')
b. SELECT * from parts WHERE partnum LIKE '%9%'
c. SELECT partnum FROM parts WHERE partnum = ‘%9%’
d. SELECT partnum FROM parts WHERE partnum BETWEEN = ‘%9%’
Feedback
The correct answer is: SELECT * from parts WHERE partnum LIKE '%9%'
Question 5
Correct
Mark 1.00 out of 1.00
Flag question
Question text
John want to know how many part items are there in warehouse number 3.
What SQL command he need to run?
Select one:
a. SELECT COUNT(*) FROM parts WHERE warehouse = 3;
b. SELECT ALL FROM COUNT(parts) WHERE warehouse = 3;
c. SELECT * FROM COUNT(parts) WHERE warehouse = 3;
d. SELECT partnum FROM COUNT(parts)WHERE warehouse = 3;
Feedback
The correct answer is: SELECT COUNT(*) FROM parts WHERE warehouse = 3;
Question 6
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Given the DEPARTMENTS table and USER user1, evaluate the SQL command:
GRANT select
ON user1
TO departments;
Select one:
a. The following will grant query privileges on the DEPARTMENTS table:
b. The folllowing will grant object privileges on USER user1
c. None of the choices
d. The SQL command is incorrect
Feedback
The correct answer is: The SQL command is incorrect
Question 7
Correct
Mark 1.00 out of 1.00
Flag question
Question text
When there are critical incidents, there are always victims.
Select one:
a. False
b. True
Feedback
The correct answer is: True
Question 8
Correct
Mark 1.00 out of 1.00
Flag question
Question text
This is a subset of an existing data type that may place a constraint on its base type.
Select one:
a. Data
b. Index
c. Subtype
d. Data dictionary
e. Schema
Feedback
The correct answer is: Subtype
Question 9
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following rules is INCORRECT about cursor variables?
Select one:
a. You cannot use cursor variables with remote subprograms on another server.
b. You cannot use REF CURSOR types in CREATE TABLE or VIEW statements.
c. You cannot assign a null value to cursor variables.
d. Cursors and cursor variables are not interoperable.
e. None of the choices.
f. You cannot use comparison operators to test cursor variables.
Feedback
The correct answer is: None of the choices.
Question 10
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
Those killed or injured
Select one:
a. hidden victims
b. Critical Incident Stress Debriefing (CISD)
c. indirect victims
d. direct victims
e. critical incidents
Feedback
The correct answer is: direct victims
Question 11
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Evaluate the following. What will be the output?
1. DECLARE
2. SUBTYPE Accumulator IS NUMBER (4,2);
3. v_amount accumulator;
4. v_num1 NUMBER;
5. v_num2 NUMBER;
6. v_num3 NUMBER;
7. BEGIN
8. v_amount := 10.50;
9. v_num1 := 1;
10. v_num2 := 2;
11. v_num3 := 3;
12. v_num1 := v_amount;
13. v_num2 := v_num1 + v_amount;
14. v_num2 := v_num2 - v_num3;
15.
16. dbms_output.put_line('Total is: ' || v_num2);
17.
18. END;
Select one:
a. 18
b. 8.5
c. -1
d. None of the choices
Feedback
The correct answer is: 18
Question 12
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Restrictive, specifies a RETURN type, associates only with type-compatible queries are
description of a ________________.
Select one:
a. Functional REF CURSOR
b. Relational REF CURSOR
c. Procedural REF CURSOR
d. Strong REF CURSOR
e. Weak REF CURSOR
Feedback
The correct answer is: Strong REF CURSOR
Question 13
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
Family, friends, co-workers and those identified with the direct victims
Select one:
a. direct victims
b. indirect victims
c. Critical Incident Stress Debriefing (CISD)
d. critical incidents
e. hidden victims
Feedback
The correct answer is: indirect victims
Question 14
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Display employee's name and id whose firstname starts with letter D and job id is SA_REP. Sort
the output by department.
Select one:
a. SELECT employees FROM employee_id, first_name, last_name WHERE first_name
LIKE ‘D%’ and job_id = ‘IT_PROG’ ORDER BY department_id
b. SELECT employee_id, first_name, last_name FROM employees ORDER BY
department_id WHERE first_name LIKE 'D%' and job_id = 'IT_PROG'
c. 'IT_PROG' OR first_name LIKE 'D%' and ORDER BY department_id
d. SELECT employee_id, first_name, last_name FROM employees WHERE first_name
LIKE 'D%' and job_id = 'IT_PROG' ORDER BY department_id
e. SELECT employee_id, first_name, last_name FROM employees WHERE job_id =
'IT_PROG' OR first_name LIKE 'D%' and ORDER BY department_id
Feedback
The correct answer is: SELECT employee_id, first_name, last_name FROM employees WHERE
first_name LIKE 'D%' and job_id = 'IT_PROG' ORDER BY department_id
Question 15
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Display all employees whose job id contains the word 'ACCOUNT'.
Select one:
a. SELECT * FROM EMPLOYEES WHERE job_id LIKE '_ACCOUNT%';
b. SELECT * FROM EMPLOYEES WHERE job_id LIKE '%*ACCOUNT*%';
c. SELECT * FROM EMPLOYEES WHERE job_id LIKE '_ACCOUNT_';
d. SELECT * FROM EMPLOYEES WHERE job_id LIKE '%ACCOUNT%';
e. SELECT * FROM EMPLOYEES WHERE job_id LIKE '*ACCOUNT%';
Feedback
The correct answer is: SELECT * FROM EMPLOYEES WHERE job_id LIKE '%ACCOUNT
%';
Question 16
Not answered
Marked out of 1.00
Flag question
Question text
A Answer is a weather condition that produces lightning and thunder, heavy rainfall from
cumulonimbus clouds and possibly a tornado.
Feedback
The correct answer is: thunderstorm
Question 17
Correct
Mark 1.00 out of 1.00
Flag question
Question text
SQL stands for
Select one:
a. Standard Question Language
b. Standard Query Language
c. Sequential Query Level
d. Structured Query Language
e. Structure Query Level
Feedback
The correct answer is: Structured Query Language
Question 18
Not answered
Marked out of 1.00
Flag question
Question text
Write A if the following statement is an objective of CISD, B if not.
Share experiences, feelings, reactions during and after a critical incidents.
Answer:
Feedback
The correct answer is: A
Question 19
Correct
Mark 1.00 out of 1.00
Flag question
Question text
There was 10% price increase in the all the parts in warehouse number 3. The Store Manager
asked the Database Administrator to generate a report showing the part number, the old and new
price.
Which of the following SQL statement would satisfy the requirement of the Store Manager.
Select one:
a. SELECT partnum, price, price * 0.1 FROM parts WHERE warehouse = 3
b. SELECT partnum, price, price * 10% FROM parts WHERE warehouse = 3
c. SELECT partnum, price, price * 1.1 FROM parts WHERE warehouse = 3
d. SELECT partnum, price, price * 1.10% FROM parts WHERE warehouse = 3
Feedback
The correct answer is: SELECT partnum, price, price * 1.1 FROM parts WHERE warehouse = 3
Question 20
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
Which of the following is not a recommended activity after landslides?
Select one:
a. Recommend to proper authorities to examine thoroughly the damaged structures and
utilities before reoccupying facilities.
b. Develop a school evacuation plan.
c. Stay away from the area of landslide.
d. Check with caution the injured and trapped persons within the landslide area.
e. Seek the advice of geotechnical experts for evaluating landslide hazards.
Feedback
The correct answer is: Develop a school evacuation plan.
Question 21
Correct
Mark 1.00 out of 1.00
Flag question
Question text
TRUE OR FALSE.
Multiple fields in NOT allowed in a Foreign key.
Select one:
True
False
Feedback
The correct answer is 'False'.
Question 22
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Using Data Manipulation Language, you can ADD columns in the table.
Select one:
True
False
Feedback
The correct answer is 'False'.
Question 23
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following will erase all records in the departments table
Select one:
a. DELETE FROM departments
b. TRUNCATE FROM TABLE departments
c. TRUNCATE TABLE departments
d. DELETE * FROM departments
Feedback
The correct answer is: TRUNCATE TABLE departments
Question 24
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
1. The two development environments of Oracle are _______________ and ______________.
Select one:
a. Oracle SQL Developer; SQL command line
b. Oracle SQL Developer; ANSI SQL Web
c. Oracle DB; SQL command line
d. ANSI SQL Web; Oracle Net SQL
Feedback
Your answer is incorrect.
The correct answer is: Oracle SQL Developer; SQL command line
Question 25
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Evaluate the following SQL command
SELECT employee_id, hire_date, department_name FROM employees, departments
WHERE departments.department_id = employees.department_id
Select one:
a. The SQL command should have ALIAS for the table to produce a correct output.
b. The SQL command will give an incorrect output.
c. The SQL command will produce an error.
d. The SQL command will produce a correct output.
Feedback
The correct answer is: The SQL command will produce a correct output.
Question 26
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
True or False: Flooding are sometimes caused by human activities.
False
Answer:
Feedback
The correct answer is: True
Question 27
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Fetch into a record when fetching from a cursor.
Select one:
True
False
Feedback
The correct answer is 'True'.
Question 28
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Display all the employee's id and salary whose annual salary is from 100,000 to 200,000.
Arrange the output by salary in descending order.
Select one:
a. SELECT employee_id, salary FROM employees WHERE salary *12 >= 100000 AND
salary *12 <= 200000 ORDER BY salary desc
b. SELECT employee_id, salary FROM employees WHERE salary *12 >= 100000 AND
salary *12 <= 200000 ORDER BY salary
c. SELECT employee_id, salary FROM employees WHERE salary >= 100000 AND salary
<= 200000 ORDER BY salary
d. SELECT employee_id, salary, salary *12 FROM employees WHERE 12* salary =
100000 AND 12 *salary = 200000 ORDER BY salary
Feedback
The correct answer is: SELECT employee_id, salary FROM employees WHERE salary *12 >=
100000 AND salary *12 <= 200000 ORDER BY salary desc
Question 29
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
True or False: Generally, all thunderstorms are caused by the cooling of the upper layers of air
by radiation.
True
Answer:
Feedback
The correct answer is: False
Question 30
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following describes the command below?
SELECT * FROM employees WHERE department = 60 FOR UPDATE
Select one:
a. Locks the rows in the EMPLOYEES table with department id is 60.
b. Creates a temporary table with department = 60
c. Unlock all records with department id = 60
d. All users accessing the department id 60 can accept UPDATE command simultaneously.
Feedback
The correct answer is: Locks the rows in the EMPLOYEES table with department id is 60.
Question 31
Correct
Mark 1.00 out of 1.00
Flag question
Question text
A Database Administrator can create and remove users and tables.
Select one:
a. The statement is correct
b. The information is insufficient.
c. The statement is incorrect. DBA can only create users and tables. Removal of users and
tables will be done by the higher authority of the database.
d. The statement is incorrect. Only users of the database can be created by the Database
Administrator.
Feedback
The correct answer is: The statement is correct
Question 32
Correct
Mark 1.00 out of 1.00
Flag question
Question text
A _______________ consists of a collection of DML statements that form a logical unit of work.
Select one:
a. Transaction
b. Database
c. SQL command
d. All of the choices
Feedback
The correct answer is: Transaction
Question 33
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Display the warehouse number, class, highest price & lowest price, total on hand balance whose
class is AP.
Sort the output by warehouse number.
Select one:
a. SELECT warehouse, class, MAX(price), MIN(PRICE), SUM(onhand)
FROM parts
GROUP BY warehouse, class
ORDER BY warehouse;
WHERE class = 'AP'
b. SELECT warehouse, class, MAX(price), MIN(PRICE), sum(onhand)
FROM parts
WHERE class = 'AP'
GROUP BY warehouse, class, price
ORDER BY warehouse, class
c. SELECT warehouse, class, MAX(price), MIN(PRICE), sum(onhand)
FROM parts
WHERE class = 'AP'
GROUP BY warehouse, class
ORDER BY warehouse;
d. SELECT warehouse, class, HIGH(price), LOW(PRICE), SUM(onhand)
FROM parts
GROUP BY warehouse
WHERE class = 'AP'
ORDER BY warehouse, class;
Feedback
The correct answer is: SELECT warehouse, class, MAX(price), MIN(PRICE), sum(onhand)
FROM parts
WHERE class = 'AP'
GROUP BY warehouse, class
ORDER BY warehouse;
Question 34
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following is not what to do before an incidence of flood?
Select one:
a. Be alert of the possibility of a flood.
b. Find out the frequency of occurrence of floods in the locality.
c. Ensure that electrical appliances are checked before switching them on.
d. Know the flood warning system in school
Feedback
The correct answer is: Ensure that electrical appliances are checked before switching them on.
Question 35
Not answered
Marked out of 1.00
Flag question
Question text
Write A if the following statement is an objective of CISD, B if not.
Identify and discuss coping skills for reducing stress.
Answer:
Feedback
The correct answer is: A
Question 36
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
Evaluate the given SQL syntax
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...)
WHERE condition;
Select one:
a. Correct syntax.
b. Wrong placement of WHERE and VALUES
c. This will produce an error.
d. INSERT should be UPDATE command
Feedback
The correct answer is: This will produce an error.
Question 37
Correct
Mark 1.00 out of 1.00
Flag question
Question text
You can relate data to multiple tables using a foreign key.
Select one:
True
False
Feedback
The correct answer is 'True'.
Question 38
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Display the name, jobs id and salary of the all the employees whose department id is 100 and
salary is below 8000. Arrange the output by salary in ascending order.
Select one:
a. SELECT employees FROM first_name, last_name, salary WHERE department_id = 100
AND salary < 8000 ORDER BY salary ASC
b. SELECT name, salary FROM employees WHERE department_id = 100 AND salary <
8000 ORDER BY salary ASC
c. SELECT name FROM employees WHERE salary < 8000 AND department_id = 100
AND ORDER BY department_id
d. SELECT first_name, last_name, salary FROM employees WHERE salary < 8000 AND
department_id = 100 AND ORDER BY department_id
e. SELECT first_name, last_name, salary FROM employees ORDER BY salary WHERE
department_id = 100 AND salary > 8000
f. SELECT first_name, last_name, salary FROM employees WHERE department_id = 100
AND salary < 8000 ORDER BY salary
Feedback
The correct answer is: SELECT first_name, last_name, salary FROM employees WHERE
department_id = 100 AND salary < 8000 ORDER BY salary
Question 39
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
Crisis workers, volunteers, disaster managers and staff, police, firemen, hospital workers
Select one:
a. Critical Incident Stress Debriefing (CISD)
b. hidden victims
c. indirect victims
d. direct victims
e. critical incidents
Feedback
The correct answer is: hidden victims
Question 40
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following is NOT a Data Manipulation Language?
Select one:
a. SELECT
b. DELETE
c. CREATE
d. UPDATE
e. INSERT
Feedback
The correct answer is: CREATE
Question 41
Correct
Mark 1.00 out of 1.00
Flag question
Question text
This is a subset of an existing data type that may place a constraint on its base type.
Select one:
a. Schema
b. Data dictionary
c. Data
d. Subtype
e. Index
Feedback
The correct answer is: Subtype
Question 42
Correct
Mark 1.00 out of 1.00
Flag question
Question text
ANSI SQL commands cannot be abbreviated.
Select one:
True
False
Feedback
The correct answer is 'True'.
Question 43
Correct
Mark 1.00 out of 1.00
Flag question
Question text
CISD is conducted through sharing- reflection sessions that are not confidential
Select one:
a. True
b. False
Feedback
The correct answer is: False
Question 44
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following rules is INCORRECT about cursor variables?
Select one:
a. Cursors and cursor variables are not interoperable.
b. None of the choices.
c. You cannot use cursor variables with remote subprograms on another server.
d. You cannot use comparison operators to test cursor variables.
e. You cannot assign a null value to cursor variables.
f. You cannot use REF CURSOR types in CREATE TABLE or VIEW statements.
Feedback
The correct answer is: None of the choices.
Question 45
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Display a summary table of the total quantity on hand above 50 very class per warehouse
Select one:
a. SELECT warehouse, class, sum(onhand) FROM parts GROUP BY warehouseWHERE
SUM(ONHAND) > 50
b. SELECT warehouse, class, sum(onhand) FROM parts WHERE SUM(ONHAND) > 50
c. SELECT warehouse, class, sum(onhand) FROM parts GROUP BY warehouse,class
HAVING SUM(ONHAND) > 50
d. SELECT warehouse, class, sum(onhand) FROM parts GROUP BY warehouse HAVING
SUM(ONHAND) > 50
Feedback
The correct answer is: SELECT warehouse, class, sum(onhand) FROM parts GROUP BY
warehouse,class HAVING SUM(ONHAND) > 50
Question 46
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
It is a preventive stress management strategy designed to assist affected people in handling
normal stress.
Select one:
a. direct victims
b. indirect victims
c. hidden victims
d. Critical Incident Stress Debriefing (CISD)
e. critical incidents
Feedback
The correct answer is: Critical Incident Stress Debriefing (CISD)
Question 47
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following is INCORRECT about the guidelines for cursor design?
Select one:
a. Close a cursor when it is no longer needed.
b. Simplify coding with cursor FOR loops.
c. Use column aliases in cursors for calculated columns fetched into records declared with
%COLUMNTYPE.
d. None of the choices.
Feedback
The correct answer is: Use column aliases in cursors for calculated columns fetched into records
declared with %COLUMNTYPE.
Question 48
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following is the syntax to fetch from a cursor variable?
Select one:
a. GET cursor_variable_name INTO variable_name1
[,variable_name2,. . .] | record_name;
b. RETRIEVE cursor_variable_name INTO variable_name1
[,variable_name2,. . .] | record_name;
c. POST cursor_variable_name INTO variable_name1
[,variable_name2,. . .] | record_name;
d. FETCH cursor_variable_name INTO variable_name1
[,variable_name2,. . .] | record_name;
Feedback
The correct answer is: FETCH cursor_variable_name INTO variable_name1
[,variable_name2,. . .] | record_name;
Question 49
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Debriefing was originally developed to assist crisis response teams in recognizing and managing
their own normal reactions to traumatic exposure.
Select one:
a. False
b. True
Feedback
The correct answer is: True
Question 50
Correct
Mark 1.00 out of 1.00
Flag question
Question text
What will be the output of the following SQL?
SELECT * FROM parts WHERE (warehouse = 1 or warehouse = 2) AND class IN ('HW', 'AP')
AND (price > 200 AND price < 500);
Select one:
a. Error
b. Invalid SQL command
c. 0 rows returned
d. 7 rows returned
e. 2 rows returned
Feedback
The correct answer is: 2 rows returned
Question 51
Correct
Mark 1.00 out of 1.00
Flag question
Question text
List all the employee_id of all employees whose salary is 5000 and below and belong to
department 60 or 100.
Select one:
a. SELECT employee_id,salary, department_id FROM employees WHERE salary < 5000
AND department_id IN (60,100)
b. SELECT employee_id,salary, department_id FROM employees WHERE salary < 5000
AND department_id IN (60 OR 100)
c. SELECT employees FROM employee_id,salary, department_idWHERE salary < 5000
AND department_id IN (60,100)
d. SELECT employee_id FROM employee WHERE salary < 5000 AND department_id IN
('60,'100')
Feedback
The correct answer is: SELECT employee_id,salary, department_id FROM employees WHERE
salary < 5000 AND department_id IN (60,100)
Question 52
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Through debriefing individuals realize that experiencing severe stress during a critical incident is
a normal reaction.
Select one:
a. True
b. False
Feedback
The correct answer is: True
Question 53
Not answered
Marked out of 1.00
Flag question
Question text
Write A if the following statement is an objective of CISD, B if not.
Formulate and discuss contingency plans.
Answer:
Feedback
The correct answer is: A
Question 54
Correct
Mark 1.00 out of 1.00
Flag question
Question text
TRUE OR FALSE.
A FOREIGN KEY is a field in one table that refers to the PRIMARY KEY in another table.
Select one:
True
False
Feedback
The correct answer is 'True'.
Question 55
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following DOES NOT describes the state of the data after the COMMIT command
Select one:
a. The previous state of the data is overwritten.
b. All savepoints are erased.
c. All users can view the results.
d. Locks on the affected rows are released; those rows are available for other users to
manipulate.
e. None of the choices
f. Data changes are saved in the database.
Feedback
The correct answer is: None of the choices
Question 56
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Weak REF CURSOR is very flexible.
Select one:
True
False
Feedback
The correct answer is 'True'.
Question 57
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following is the syntax to open a cursor varial
Select one:
a. SET cursor_variable_name
FOR select_statement;
b. GET cursor_variable_name
FOR select_statement;
c. OPEN cursor_variable_name
FOR select_statement;
d. LOAD cursor_variable_name
FOR select_statement;
Feedback
The correct answer is: OPEN cursor_variable_name
FOR select_statement;
Question 58
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following is the syntax to close a cursor?
Select one:
a. SET cursor_variable_nameCLOSE;
b. CLOSE cursor_variable_name;
c. QUIT cursor_variable_name;
d. EXIT cursor_variable_name;
Feedback
The correct answer is: CLOSE cursor_variable_name;
Question 59
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following is the syntax to define a REF CURSOR type?
Select one:
a. DEFINE ref_type_name AS REF CURSOR
[RETURN return_type];
b. DECLARE ref_type_name AS REF CURSOR
[RETURN return_type];
c. SET ref_type_name IS REF CURSOR
[RETURN return_type];
d. TYPE ref_type_name IS REF CURSOR
[RETURN return_type];
Feedback
The correct answer is: TYPE ref_type_name IS REF CURSOR
[RETURN return_type];
Question 60
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
What will be the output of the SQL command?
SELECT SUM(onhand) FROM PARTS where class = 'HW' OR class = 'AP' AND warehouse =
1;
Select one:
a. 178
b. 44
c. 85
d. 137
Feedback
The correct answer is: 137
Question 61
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Use column aliases in cursors for calculated columns fetched into records declared with
%COLUMNTYPE.
Select one:
True
False
Feedback
The correct answer is 'False'.
Question 62
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following describes weak REF CURSOR?
Select one:
a. Restrictive
b. All of the choices
c. Is not flexible
d. Associates with any query
Feedback
The correct answer is: Associates with any query
Question 63
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
Strong reactions if not discussed and understood can interfere with work and home life during
and after the event.
Select one:
a. True
b. False
Feedback
The correct answer is: True
Question 64
Correct
Mark 1.00 out of 1.00
Flag question
Question text
TRUE OR FALSE.
The INSERT statement can add multiple rows.
Select one:
True
False
Feedback
The correct answer is 'False'.
Question 65
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Using CREATE SQL Command, you can add new records in the table.
Select one:
True
False
Feedback
The correct answer is 'False'.
Question 66
Correct
Mark 1.00 out of 1.00
Flag question
Question text
It is an event, caused by natural or man-made and managing hazards that has the potential for
causing powerful reaction in the majority who are exposed to it.
Select one:
a. hidden victims
b. direct victims
c. critical incidents
d. indirect victims
e. Critical Incident Stress Debriefing (CISD)
Feedback
The correct answer is: critical incidents
Question 67
Correct
Mark 1.00 out of 1.00
Flag question
Question text
The General Manager request to the Database Administrator to generate the total number of parts
and total outstanding balance on hand of every class in warehouse number 1&2.
Which of the following SQL command will generate the required output.
Select one:
a. SELECT warehouse, class, count(partnum), sum(onhand) GROUP BY warehouse,class
HAVING warehouse = 1 or warehouse = 2 FROM parts;
b. SELECT warehouse, class, COUNT(partnum), SUM(onhand) FROM parts GROUP BY
warehouse,class HAVING warehouse = 1 OR warehouse = 2;
c. SELECT warehouse, class, count(partnum), sum(onhand) GROUP BY warehouse,class
WHERE warehouse = 1 or warehouse = 2 FROM parts;
d. SELECT warehouse, class, SUM(partnum), SUM(onhand) FROM parts GROUP BY
warehouse,class HAVING warehouse = 1 AND warehouse = 2;
Feedback
The correct answer is: SELECT warehouse, class, COUNT(partnum), SUM(onhand) FROM
parts GROUP BY warehouse,class HAVING warehouse = 1 OR warehouse = 2;
Question 68
Correct
Mark 1.00 out of 1.00
Flag question
Question text
SQL command to create a marker in the current transaction.
Select one:
a. SAVEPOINT
b. INDEX
c. SAVEMARKER
d. POINTER
e. SAVEMORE
Feedback
The correct answer is: SAVEPOINT
Question 69
Incorrect
Mark 0.00 out of 1.00
Flag question
Question text
A join between two tables that returns the results of an INNER join as well as the results of a left
and right join is a _____________.
Select one:
a. INNER JOIN
b. NATURAL JOIN
c. OUTER JOIN
d. FULL OUTER JOIN
Feedback
The correct answer is: FULL OUTER JOIN
Question 70
Correct
Mark 1.00 out of 1.00
Flag question
Question text
A join between two tables that returns the results of the INNER join as well as
the_______________ rows from the left (or right) table is called a left (or right) OUTER join.
Select one:
a. Unmatched
b. Matched
c. Missing
d. Intersect
Feedback
The correct answer is: Unmatched
Question 71
Correct
Mark 1.00 out of 1.00
Flag question
Question text
INDEX is an example of _____________________ privilege.
Select one:
a. Data
b. Object
c. None of the choices
d. System
Feedback
The correct answer is: Object
Question 72
Correct
Mark 1.00 out of 1.00
Flag question
Question text
A Cartesian product is formed when:
Select one:
a. All rows in the first table are joined to all rows in the second table
b. A join condition is invalid
c. All of the choices
d. A join condition is omitted
Feedback
The correct answer is: All of the choices
Question 73
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following SQL command will display the summary table showing the total quantity
on hand per class.
Select one:
a. SELECT class, sum(onhand) AS "QTY ON HAND" FROM parts GROUP BY class
b. SELECT class, onhand AS "QTY ON HAND" FROM parts GROUP BY sum(onhand)
c. SELECT class, TOTAL(onhand) AS "QTY ON HAND" FROM parts GROUP BY class,
onhand
d. SELECT class, sum(onhand) AS "QTY ON HAND" FROM parts GROUP BY onhand
Feedback
The correct answer is: SELECT class, sum(onhand) AS "QTY ON HAND" FROM parts
GROUP BY class
Question 74
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Write A if the following statement is an objective of CISD, B if not.
Learn and identify current and anticipated stress responses.
A
Answer:
Feedback
The correct answer is: A
Question 75
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following command will delete all records in the table employees
Select one:
a. DELETE ALL FROM employees
b. DELETE employees WHERE ORASYS_REC > 0
c. DELETE ALL RECORDS employees
d. DELETE FROM employees
Feedback
The correct answer is: DELETE FROM employees
Question 76
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Aldrin wants to know the outstanding total balance on hand on every class per warehouse.
Select one:
a. SELECT TOTAL(warehouse), TOTAL(class), TOTAL(onhand) FROM parts GROUP
BY warehouse, class
b. SELECT warehouse, class, sum(onhand) FROM parts GROUP BY warehouse, class
c. SELECT warehouse, class, onhand FROM parts GROUP BYsum(warehouse), sum(class);
d. SELECT warehouse, class, onhand FROM parts GROUP BY warehouse, class
Feedback
The correct answer is: SELECT warehouse, class, sum(onhand) FROM parts GROUP BY
warehouse, class
Question 77
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Each row of data in a table can be uniquely identified by a
Select one:
a. foreign key
b. relational key
c. local key
d. primary key
e. index key
Feedback
The correct answer is: primary key
Question 78
Correct
Mark 1.00 out of 1.00
Flag question
Question text
INSERT, DELETE, UPDATE are ________________ commands
Select one:
a. DDL
b. DML
c. All of the choices
d. DCL
Feedback
The correct answer is: DML
Question 79
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Command use to display table structure
Select one:
a. DISPLAY TABLE
b. DISPLAY
c. DESCRIBE
d. DISPLAY STRUCTURE
Feedback
The correct answer is: DESCRIBE
Question 80
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Write A if the following statement is an objective of CISD, B if not.
Provide education about current and anticipated stress response.
B
Answer:
Feedback
The correct answer is: B
