×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which code can you use to ensure that the salary is not increased by more than 10% at a time nor is it ever
decreased?
decreased?
2.
If you want to run the above function from the SQL *Plus prompt, which statement is true?
Given a function CALCTAX:
CREATE OR REPLACE FUNCTION calctax (sal NUMBER) RETURN NUMBER
IS
BEGIN
RETURN (sal * 0.05);
END;
CREATE OR REPLACE FUNCTION calctax (sal NUMBER) RETURN NUMBER
IS
BEGIN
RETURN (sal * 0.05);
END;
If you want to run the above function from the SQL *Plus prompt, which statement is true?
3.
What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
4.
There is a CUSTOMER table in a schema that has a public synonym CUSTOMER and you are granted all
object privileges on it. You have a procedure PROCESS_CUSTOMER that processes customer information
that is in the public synonym CUSTOMER table. You have just created a new table called CUSTOMER within
your schema. Which statement is true?
object privileges on it. You have a procedure PROCESS_CUSTOMER that processes customer information
that is in the public synonym CUSTOMER table. You have just created a new table called CUSTOMER within
your schema. Which statement is true?
5.
You create a DML trigger. For the timing information, which is valid with a DML trigger?
6.
Examine this code:
CREATE OR REPLACE PROCEDURE add_dept
( p_name departments.department_name%TYPE DEFAULT
'unknown',
p_loc departments.location_id%TYPE DEFAULT 1700)
IS
BEGIN
INSERT INTO departments(department_id, department_name, loclation_id)
VALUES(dept_seq.NEXTVAL,p_name, p_loc);
END add_dept;
/
You created the add_dept procedure above, and you now invoke the procedure in SQL *Plus.
Which four are valid invocations? (Choose four)
7.
Examine this code:
CREATE OR REPLACE FUNCTION gen_email_name
(p_first_name VARCHAR2, p_last_name VARCHAR2, p_id NUMBER) RETURN VARCHAR2
IS
v_email_name VARCHAR2(19=;
BEGIN
v_email_name := SUBSTR(p_first_name, 1, 1) ||
SUBSTR(p_last_name, 1, 7) ||
'@Oracle.com';
UPDATE employees
SET email = v_email_name
WHERE employee_id = p_id;
RETURN v_email_name;
END;
Which statement removes the function?
CREATE OR REPLACE FUNCTION gen_email_name
(p_first_name VARCHAR2, p_last_name VARCHAR2, p_id NUMBER) RETURN VARCHAR2
IS
v_email_name VARCHAR2(19=;
BEGIN
v_email_name := SUBSTR(p_first_name, 1, 1) ||
SUBSTR(p_last_name, 1, 7) ||
'@Oracle.com';
UPDATE employees
SET email = v_email_name
WHERE employee_id = p_id;
RETURN v_email_name;
END;
Which statement removes the function?
8.
This statement fails when executed:
CREATE OR REPLACE TRIGGER CALC_TEAM_AVG
AFTER INSERT ON PLAYER
BEGIN
INSERT INTO PLAYER_BATSTAT (PLAYER_ID,
SEASON_YEAR,AT_BATS,HITS)
VALUES (:NEW.ID, 1997, 0,0);
END;
To which type must you convert the trigger to correct the error?
CREATE OR REPLACE TRIGGER CALC_TEAM_AVG
AFTER INSERT ON PLAYER
BEGIN
INSERT INTO PLAYER_BATSTAT (PLAYER_ID,
SEASON_YEAR,AT_BATS,HITS)
VALUES (:NEW.ID, 1997, 0,0);
END;
To which type must you convert the trigger to correct the error?
9.
The add_player procedure inserts rows into the PLAYER table. Which command will show this directory
dependency?
dependency?
10.
You want to create procedures, functions and packages Which privilege do you need?