Free Access Oracle.1Z0-909.v2023-05-22.q30 Practice Test (Page 3)

Question 6

Examine these commands which execute successfully in the sequence shown in Sessions S1 and S2:

Now, examine this statement that execute successfully in s1:
S1> SELECT * FROM emp;
Which is true about the result of the select statement?

A.The inserted row is not returned because the transaction still active in s2.

B.The inserted row is not returned because the isolation level is READ COMMITTED in S2.

C.The inserted row is returned because the transaction is auto committed in S2.

D.The inserted row is returned because the isolation level is RPEATABLE READ in S1.

Question 7

Examine these commands and output:

Which is true?

A.It returns an error because the CREATE TABLE statement automatically recreated the view.

B.A new view is created because the previous was dropped on execution of the drop table statement.

C.It returns an error because the DROP TABLE statement did not drop the view.

D.Existing emp_vuL is dropped and a new emp_vu1 created with the new definition.

Question 8

Your session has sqi_mode set to default.
Examine this statement which executes successfully:

Now examine this statement:

Which two changes are required to the insert statement so that it inserts the correct data?
* std_id = 10301
* firstname = Mary
* lastname = O'Hagen
* birthdate = November 26, 1997
* reg_date = the current date

A.Change "O'Hagen" to "O\'Hagen".

B.Change DATE () to DAY ().

C.Change " NULL " to NULL.

D.Change date () to CURRENT_TIMESTAMP () .

E.Change "O'Hagen" to 'o\'Hagen'.

F.Change " NULL " to ' NULL ' .

Question 9

Which select statement returns true?

A.SELECT NULL := NULL;

B.SELECT NULL <> NULL;

C.SELECT NULL <=> NULL;

D.SELECT NULL = NULL;

Question 10

The employee table includes these columns:
e_id INT, e_name VARCHAR (45), dept_id INT salart INT
You must create a stored function, getMaxSalary(), which returns the maximum salary paid for a given department id.
Which statement will create the function?
A)