1Z0-909 Study Guide Brilliant 1Z0-909 Exam Dumps PDF [Q35-Q54]

5/5 - (1 vote)

1Z0-909 Study Guide Brilliant 1Z0-909 Exam Dumps PDF

View 1Z0-909 Exam Question Dumps With Latest Demo

Oracle 1Z0-909 Exam Syllabus Topics:

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

NO.35 Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice’, UCASE (‘Alice* )) ;
What is displayed?

ERROR: 1267 (HYOOO): Illegal mix of collations

-1

NULL

NO.36 Which two are true about MySQL Document Store?

It helps to store data items in a schema-less key-value store.

It can store documents greater than 4 GB.

It depends heavily on strictly typed data.

It allows one to bypass the SQL layer of the server.

There is no access to relational tables.

NO.37 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.38 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.

NO.39 Examine these statements which execute successfully:

Now, examine this query:

What is the result?

It inserts a row with a warning.

It inserts a row with no error or warning.

It inserts a row with an error.

It fails with an error.

It fails with a warning.

NO.40 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.41 Examine the output:

Which explain command will obtain the output?

EXPLAIN ANALYZE

EXPLAIN PARTITIONS

EXPLAIN FORMAT=TREE

EXPLAIN PORMAT^TRADITIONAL

EXPLAIN PORMAT=JSON

NO.42 Examine the content of the employee table:

Now examine this PHP script:

Finally examine this desired output:

$options = [PDO:: ATTR_DEFAULT_FETCH__MODE => PDO: : FETCH_ASSOC] ;

$options = [PDO:: ATTR_DEFAUXT_FETCH__MODE => PDO: : PDO: :FETCH_OBJ] ;

$options = [PDO:: ATTR_DEFAOLT_FETCH__MODE => PDO : : FETCH_BOTH] ;

$options = [PDO:: ATTR__DEFAULT_FETCH MODE => PDO: :FETCH_CLASS] ;

NO.43 Examine these statements issued from Session 1 which execute successfully:

Now, examine these statements issued from Session 2 which execute successfully:
Session 2>
BEGIN;
UPDATE band SET song=CONCAT (“Here Comes the “, song) WHERE song LIKE ‘ %Sun ; Which two are true?

Session 1 takes a shared lock on all the rows in the band table.

Session 1 must commit before the update in Session 2 can complete.

Session 1 does not block Session 2.

Statements in Session 2 are committed.

Session 2 takes an exclusive lock on all the rows in the band table.

Session 2 does not start a transaction.

NO.44 Examine this statement which executes successfully:

The table is populated with a range of values including jobs for Robert, John, and Katie. Now, examine this statement and output:

Why is an empty result set returned?

The select requires json_unquoteo in the where clause.

The virtual values in the name column must be accessed using functions.

The JSON datatype cannot be used in virtual columns.

The json_extract() function requires a length value that matches the field length in the schema.

Table statistics must be updated to generate values for the name column.

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

NO.46 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.47 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

NO.48 Examine these statements which execute successfully:

The statements executed without exception. Which two are true?

No transaction commits.

One row is inserted into band.

Two transactions commit.

No row is inserted into band.

The transaction is rolled back to the savepoint.

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

NO.50 Examine the output:

Which explain command will obtain the output?

EXPLAIN ANALYZE

EXPLAIN PARTITIONS

EXPLAIN FORMAT=TREE

EXPLAIN PORMAT^TRADITIONAL

EXPLAIN PORMAT=JSON

NO.51 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.52 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.

NO.53 The meeting table stores meeting schedules with participants from five continents. The participants’ details are stored in another table.

You need to adjust the start_time and duration columns for optimal storage. What datatype changes would achieve this?