Scribd
Upload
272 views4 pages

1Z0 909 Questions

The document contains a series of questions and answers related to the Oracle 1Z0-909 MySQL 8.0 Database Developer exam. Each question is followed by multiple-choice answers and an explanation of the correct answer. The content focuses on various SQL statements and their outcomes, along with concepts related to database views and indexing.

Uploaded by

Reddy dba
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
272 views4 pages

1Z0 909 Questions

The document contains a series of questions and answers related to the Oracle 1Z0-909 MySQL 8.0 Database Developer exam. Each question is followed by multiple-choice answers and an explanation of the correct answer. The content focuses on various SQL statements and their outcomes, along with concepts related to database views and indexing.

Uploaded by

Reddy dba
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Oracle

1Z0-909 Exam
MySQL 8.0 Database Developer
Questions & Answers
Demo
Questions & Answers PDF Page 2

Version: 4.1

Question: 1

Examine these statements:


SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice', UCASE ('Alice* )) ;
What is displayed?

A. 0
B. ERROR: 1267 (HYOOO): Illegal mix of collations
C. -1
D. NULL
E. 1

Answer: C
Explanation:

Question: 2

Examine these commands and output:

Which is true?
Questions & Answers PDF Page 3

A. Existing emp_vuL is dropped and a new emp_vu1 created with the new definition.
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 CREATE TABLE statement automatically recreated the view.
D. It returns an error because the DROP TABLE statement did not drop the view.

Answer: D
Explanation:

Question: 3

Which select statement returns true?

A. SELECT NULL <> NULL;


B. SELECT NULL <=> NULL;
C. SELECT NULL = NULL;
D. SELECT NULL := NULL;

Answer: B
Explanation:

Question: 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?

A. It inserts a row in the emp table.


B. It returns an error because an insert operation is not allowed on views.
C. It inserts a row in the view only.
D. It returns an error because the PRIMARY ACCOUNT column is not selected for the view definition.

Answer: A
Explanation:
Questions & Answers PDF Page 4

Question: 5

Examine this statement which has executed successfully:

A. Execution performance can be improved by using like instead of RLIKE.


B. The statement takes advantage of index description_idx.
C. Execution performance can be improved by, using a composite index with column description as the
leftmost prefix column description.
D. No index will improve statement performance.
E. Execution performance can be improved by adding an index on column description.

Answer: A

You might also like