Question: 1
Table HR. employees contains a row where the employee_id is 109.
User ALICE has no privileges to access HR.employees.
User ALICE starts a session.
User HR starts a session and successfully executes these statements:
GRANT DELETE ON employees to ALICE;
UPDATE employees SET salary = 24000 WHERE employee_id 109;
In her existing session ALICE then executes:
DELETE FROM HR.employees WHERE employee_ID =109;
What Is the result?
Question: 2
Examine these statements:
CREATE TABLE alter_test (c1 VARCHAR2 (10) , c2 NUMBER (10);
INSERT INTO alter-test VALUES ('123', 123);
Which is true about modifying the columns in Alter_TEST?
Which is true about modifying the columns in ALTER_TEST?
Question: 3
Use HR has CREATE SESSION, CREATE ANY TABLE and UNLIMITED TABLESPACE privileges.
User SCOTT has CREAT SESSION, CREATE TABLE and UNLIMITED TABLESPACE Privileges
HR successfully executes this statement:
Which will execute successfully?
Question: 4
Examine this query:
SELECT SUBSTR (SYSDATE, 1, 5) ''Result '' FROM DUAL;
Which statement Is true?
Question: 5
The stores table has a column start__date of data type date, containing the date the row was Inserted.
You only want to display details of rows where start date is within the last 25 months."
Which where clause can be used?
