Free Access Oracle.1Z0-909.v2023-04-12.q27 Practice Test (Page 4)

Question 11

Examine the statement which executes successfully:
SET sql_mode=' NO_ENGINE_SUBSTITTJTION' ;
You try to create a table with a storage engine that is not available. What will happen?

A.The server will create the table using the default storage engine.

B.An error occurs and the create table statement fails.

C.The server will create the table but report an error when the first attempt to insert a row is performed.

D.The server will create the table but it will be unusable until the specified storage engine is available.

Question 12

The meeting table stores meeting schedules with participants from five continents. The participants' details are stored in another table.

You need to adjust the start_time and duration columns for optimal storage. What datatype changes would achieve this?

A.start_time TIMESTAMP duration TIMESTAMP

B.start_time TIMESTAMP duration TIME

C.start_time TIME duration TIME

D.start__time DATETIME duration TIME

E.start_time DATETIME duration DATETIME

Question 13

Examine these statements which execute successfully:

Which two changes will improve this query performance?

A.CREATE INDEX IX1 ON locations (loc_shareci) ;

B.CREATE INDEX 1X6 ON users (user_name);

C.CREATE INDEX 1X4 ON Locations (site_id, loc_shared);

D.CREATE INDEX 1X3 ON locations <loc_site_id) ;

E.CREATE INDEX 1X2 ON locations (loc_mapping) USING HASH; fH

F.CREATE INDEX 1X7 ON users (user_name) USING HASH;

G.CREATE INDEX 1X5 ON users (loc_id);

Question 14

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)