PDF Download Free of 1Z0-909 Valid Practice Test Questions [Q14-Q29]

By adminOn January 10, 2023

Rate this post

PDF Download Free of 1Z0-909 Valid Practice Test Questions

1Z0-909 Test Engine files, 1Z0-909 Dumps PDF

Oracle 1Z0-909 Exam Syllabus Topics:

Topic	Details
Topic 1	Analyze queries for optimization Aggregate and summarize data Data-driven Applications
Topic 2	Resolve consistency problems with isolation levels Set SQL Modes to change MySQL behavior
Topic 3	Use MySQL Shell to access document stores Retrieve data from the database by using a connector
Topic 4	Rewrite queries for optimization Store and process string data
Topic 5	Demonstrate connector use, management and configuration Secure credentials and connections
Topic 6	Explain application development with NoSQL and XDevAPI Handle and interpret errors and warnings
Topic 7	Create and access a document store JSON and Document Store Store and process numeric data
Topic 8	Explain the programming constructs used in stored routines Choose between connectors for a given application
Topic 9	Store and process spatial data Design, create, and alter views
Topic 10	Schedule database operations Store and process temporal data
Topic 11	Create and execute stored routines MySQL Schema Objects and Data

NO.14 Examine the employee table structure:

Which set of statements immediately returns empname for a given emp_id by using a parameterized prepare statement?
A)

D)

Option A

Option B

Option C

Option D

NO.15 Examine this statement that execute successfully in an interactive session:

The user running this session now goes to lunch for an hour.
Now, examine these statements executed independently in separate sessions while Session 0 is still active:

How many of them will complete while Session 0 is still active?

NO.16 Examine this statement:
DECLARE not_found CONDITION FOR SQLSTATE ‘02000’;
In which two statements can not found be used?

in a leave statement to exit a loop

in an if statement

in a while loop

in a handler declaration

in a signal statement

NO.17 Examine these statements and output:

Now, examine this command:
Mysql> ROLLBACK;
What is true about the effect of the command?

It undoes the update command.

It returns an error because there is no active transaction.

It undoes the insert command.

It undoes both insert and update commands.

It has no effect.

NO.18 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

Change DATE () to DAY ().

Change “O’Hagen” to ‘o’Hagen’.

Change date () to CURRENT_TIMESTAMP () .

Change ” NULL ” to NULL.

Change ” NULL ” to ‘ NULL ‘ .

Change “O’Hagen” to “O’Hagen”.

NO.19 Examine the employee table structure:

Which set of statements immediately returns empname for a given emp_id by using a parameterized prepare statement?
A)

D)

Option A

Option B

Option C

Option D

NO.20 Examine these commands and output:

Which is true?

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

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

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

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

NO.21 Which two statements are true about AUTO_INCREMENT?

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.

NO.22 Examine the output:

Which explain command will obtain the output?

EXPLAIN ANALYZE

EXPLAIN PARTITIONS

EXPLAIN FORMAT=TREE

EXPLAIN PORMAT^TRADITIONAL

EXPLAIN PORMAT=JSON

NO.23 You must write a statement that combines the first_name and last_name columns from the employees table as “last_name, first_name.” Which two statements will do this?

SELECT last_name + ‘, ‘ + first_name FROM employees;

SELECT CONCAT_WS(‘, ‘,last_name,first_name) FROM employees;

SELECT GROUP_CONCAT(last_name, first_name) FROM employees;

SELECT last_name, ‘ , ‘,first_name FROM employees;

SELECT CONCAT(last name,’, ‘,first_name) FROM employees;

NO.24 Examine this statement and output:
CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(g) ) ; Query OK, 0 rows affected, 1 warning (0.01 sec) An attempt is made to add an SRID attribute to the column using the statement:
ALTER TABLE geom MODIFY COLUMN g geometry NOT NULL SRID 0;
Which is true?

An error is generated because srid o is an invalid identifier value.

Execution succeeds with a warning.

An error is generated because the index prevents changes to the column.

Execution succeeds and allows the use of the index by the optimizer.

NO.25 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)

B)

C)

D)