MultipleChoice
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?
OptionsMultipleChoice
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?
OptionsMultipleChoice
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?
OptionsMultipleChoice
Examine this query:
SELECT SUBSTR (SYSDATE, 1, 5) ''Result '' FROM DUAL;
Which statement Is true?
OptionsMultipleChoice
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?
OptionsMultipleChoice
Which three statements execute successfully?
A)
B)
C)
D)
E)
F)
G)
MultipleChoice
Examine this statement which returns the name of each employee and their manager:
You want to extend the query to include managers with no employees. What must you add before join to do this?
OptionsMultipleChoice
In your session , the NLS_DATE_FORMAT is DD_MM_YYYY.
There are 86400 seconds in a day.
Examine this result:
Which statement returns this?
OptionsMultipleChoice
Which two statements are true about dropping views?
OptionsMultipleChoice
Examine this statement:
SELECT cust_id, cust^last_ndma "Last Name"
FROM customers
WHERE country_id --- 10 UNION
SELECT cust_ID_CUST_NO, cust_last_name
PROM customers
WHERE country__id = 30
Identify three order by clauses, any one of which will complete the query successfully.
Options