Prepare 1z1-909 Question Answers Free Update With 100% Exam Passing Guarantee [Q35-Q56]

5/5 - (1 vote)

Prepare 1z1-909 Question Answers Free Update With 100% Exam Passing Guarantee [2022]

Dumps Real Oracle 1z1-909 Exam Questions [Updated 2022]

Oracle 1z1-909 Exam Syllabus Topics:

Topic	Details
Topic 1	Understand locking mechanisms within MySQL Control transactions in applications
Topic 2	Create and execute stored routines MySQL Schema Objects and Data
Topic 3	Explain application development with NoSQL and XDevAPI Handle and interpret errors and warnings
Topic 4	Use MySQL Shell to access document stores Retrieve data from the database by using a connector
Topic 5	Analyze queries for optimization Aggregate and summarize data Data-driven Applications
Topic 6	Explain the programming constructs used in stored routines Choose between connectors for a given application

Q35. 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.

Q36. Which statement is true about the show errors command?

It displays the total number of errors, warnings, and notes since the beginning of the current session.

It displays the total number of errors, warnings, and notes since the server last restarted.

It cannot display information for more than max_errot_count server system variable setting.

It displays errors messages only, since the start time of the current session.

It displays errors messages only, since the server last restarted.

It displays similar diagnostics results as get diagnostics.

Q37. Examine this event’s metadata:

Now examine this command:
DROP USER ‘userl’e’localhost’;
Which effect will the command have on the event?

The event is scheduled and executed but fails. The system will log an error.

The event is scheduled but will no longer execute. The system will log an error.

The event will be dropped without an error or warning.

The event is not scheduled and will no longer execute. The system will log an error.

Q38. Examine this statement and output:

Which is true?

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.

Q39. Which two statements are true about aggregate functions?

SUM () returns o if there are no rows to aggregate.

MAX () returns null if there are no rows to aggregate.

COUNT (distinct) returns a count of the number of rows with different values including Null.

MIN () cannot use distinct when it executes as a Windows function.

AVG () does not allow use of the distinct option.

Q40. 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.

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

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.

Q42. 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?

Q43. Examine these statements which execute successfully:

Which two changes will improve this query performance?

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

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

CREATE INDEX IX1 ON locations (loc_shareci) ;

CREATE INDEX 1X6 ON users (user_name);

CREATE INDEX 1X3 ON locations <loc_site_id) ;

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

CREATE INDEX 1X5 ON users (loc_id);

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

Now, examine this statement that execute successfully in s1:
S1> SELECT * FROM emp;
Which is true about the result of the select statement?

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.

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

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.

Q46. 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”.

Q47. Examine this statement which has executed successfully:

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

The statement takes advantage of index description_idx.

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

No index will improve statement performance.

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

Q48. 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.

Q49. Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

log_queries_not_using_indexes

log__slow_admin_statements=1

log_queries_not_using_indexes=ON

log_throttle_queries_not_using_indexes=100

Q50. A server hosts MySQL Server and Apache Webserver supporting a PHP/PDO based application.
The application must be migrated from PHP to their Java application server on another host. The MySQL instance remains on the original host.
Examine the PDO connection string used in the existing application:
Mysql:host-localhost;dbname=sales;unix_socket=/var/run/mysql.sock
Which two prevent Java from using the Unix socket?

The X Dev API protocol must be enabled to use sockets in Connector/J driver.

The socket is not implemented in Connector/J driver.

The socket can only be accessed from the local host.

socket is a reserved word in Java.

Java treats the socket file as insecure.

Q51. Examine this statement and output:

Now, examine these desired output values:

Which statement updates the table data as require

UPDATE exam_result SET score=TRUNCATE

UPDATE examresult SET score=ROUND(CEIL(score

UPDATE exam_result SET score=CEIL(TRUNCATE(sco

UPDATE exam_result SET score=CEIL(ROUND(score,1));

UPDATE exam_result SET score=ROUND(score,1);

UPDATE exam_result SET score=TRUNCATE(score,1);

Q52. 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;

Q53. 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.

Q54. Which two are true about indexes?

Secondary index access will always be faster than a table scan.

Indexing all of a table’s columns improves performance.

Indexes contain rows sorted by key values.

Indexes reduce disk space used.

Indexes are used to enforce unique constraints.

Q55. Examine this statement and output:

Which will provide the same level of detail when the error is encountered within a stored routine?
A)

B)

C)

D)