Question No. 1

Examine these statements:

SET collation_connection=utf8mb4_0900_as_cs;

SELECT STRCMPCAlice', UCASE ('Alice* )) ;

What is displayed?

A0

BERROR: 1267 (HYOOO): Illegal mix of collations

C-1

DNULL

E1

Show Answer

Correct Answer: C

Question No. 2

Examine these commands and output:

Which is true?

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

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

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

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

Show Answer

Correct Answer: D

Question No. 3

Which select statement returns true?

ASELECT NULL <> NULL;

BSELECT NULL <=> NULL;

CSELECT NULL = NULL;

DSELECT NULL := NULL;

Show Answer

Correct Answer: B

Question No. 4

Examine the structure of the emp table:

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

Now, examine this statement:

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

What is true about executing the statement?

AIt inserts a row in the emp table.

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

CIt inserts a row in the view only.

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

Show Answer

Correct Answer: A

Question No. 5

Examine this statement which has executed successfully:

AExecution performance can be improved by using like instead of RLIKE.

BThe statement takes advantage of index description_idx.

CExecution performance can be improved by, using a composite index with column description as the leftmost prefix column description.

DNo index will improve statement performance.

EExecution performance can be improved by adding an index on column description.

Show Answer

Correct Answer: A

Free Oracle 1Z0-909 Exam Actual Questions

The questions for 1Z0-909 were last updated On May 4, 2024