Oracle 1z0-909 Exam Questions Free Practice Test

Viewing page 2 out of 2 pages

Viewing questions 11-20 out of questions

Questions # 11:

Examine this statement and output:

Question # 11

What causes the error?

Options:

The engine is disabled.

The set local_infile option has not been enabled.

The database user does not have sufficient privilege.

The database server process does not have sufficient privilege.

The database client process does not have sufficient privilege.

The database server is running in read-only mode.

Expert Solution

Questions # 12:

Which two differences exist between the timestamp and date time data types?

Options:

timestamp has larger range of values.

timestamp uses less storage space.

timestamp stores more decimal points in seconds

timestamp converts the value based on the session time zone.

timestamp stores the interval between two dates.

Expert Solution

Questions # 13:

Examine this statement:

DECLARE not_found CONDITION FOR SQLSTATE '02000';

In which two statements can not found be used?

Options:

in a leave statement to exit a loop

in an if statement

in a while loop

in a handler declaration

in a signal statement

Expert Solution

Questions # 14:

Examine the structure of the emp table:

Question # 14

Examine the structure of the emp_vu1 view based on the emp table:

Question # 14

Now, examine this statement:

mysq1> INSERT INTO emp_vul VALUES ('Alice',20000) ;

What is true about executing the statement?

Options:

It inserts a row in the emp table.

It returns an error because an insert operation is not allowed on views.

It inserts a row in the view only.

It returns an error because the PRIMARY ACCOUNT column is not selected for the view definition.

Expert Solution

Questions # 15:

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

Question # 15

Now, examine this statement that execute successfully in s1:

S1> SELECT * FROM emp;

Which is true about the result of the select statement?

Options:

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

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

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

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

Expert Solution

Questions # 16:

Examine these lines of Python code:

Question # 16

You must add a line of code to complete the code to return data to the variable d. Which line will do this?

Options:

d = cursor.execute(query)

d = cursor.execute(query, (hire_start, hire_end) )

d = cursor.fetch(query % (hire_start, hire_end))

d = cursor.fetch(query, (hire_start, hire_end))

d = cursor . f etchall (query)

d = cursor.fetchall(query, (hire_start, hire_end))

Expert Solution

Questions # 17:

Which two statements are true about AUTO_INCREMENT?

Options:

AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.

A table can have multiple AUTO_INCREMENT columns.

A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.

The decimal data type supports AUTO_INCREMENT.

An AUTO_INCREMENT column must be indexed.

Expert Solution

Questions # 18:

Examine this statement and output:

Question # 18

You execute this statement:

SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;

What is the output?

Options:

product->''$.varieties [4]. origin[1];;

''$.varieties[4]. origin[1]''

product->varieties[3]. origin[0]''

''$.varieties [3]. origin[0]''

Expert Solution

Questions # 19:

Examine this statement and output:

Question # 19

Which is true?

Options:

The underlying table's index on the Name column is not chosen because of low selectivity.

myview cannot be automatically indexed.

myview was defined with the temptable processing algorithm.

Column Name in myview can be indexed if the is_updatable attribute is true.

Expert Solution

Viewing page 2 out of 2 pages

Viewing questions 11-20 out of questions

Pass the Oracle MySQL Developer 1z0-909 Questions and answers with CertsForce