View All 1z1-909 Actual Exam Questions Answers and Explanations for Free Oct-2022 [Q31-Q53] : Free Exams Dumps Materials : http://exams.dumpsmaterials.com

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

NO.32 You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?

Additional queries on the same session are blocked until the result set is released.

Results are sent from the server to the browser for buffering.

Buffered queries are enabled by default.

Buffered queries should be used on large tables when the result size is unknown.

Results are sent to the calling PHP process for buffering.

Buffered queries must be explicitly enabled using mysqliuseresult.

Large results can have a negative impact on performance.

NO.33 Examine these commands and output:

Which is true about the execution of the insert statement?

It returns an error.

It inserts a row in the view and base table.

It inserts a new row in the base table only.

It inserts a new row in the view only.

NO.34 Examine the statement which executes successfully:
SET sql_mode=’ NO_ENGINE_SUBSTITTJTION’ ;
You try to create a table with a storage engine that is not available. What will happen?

An error occurs and the create table statement fails.

The server will create the table but it will be unusable until the specified storage engine is available.

The server will create the table but report an error when the first attempt to insert a row is performed.

The server will create the table using the default storage engine.

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

NO.36 Your program which uses a MySQL connector receives this error:
Client does not support authentication protocol request by server
The account running the program uses caching_sha2_password.
Which two resolve this conflict?

Disable TLS/SSL authentication.

Place this in the root directory of your shell account:
[mysqld] require__secure_transport=OFF

Use blank RSA or SSL certificates.

Upgrade the connector to a version that supports caching_sha2_password.

Change the user account to use mysql_native_password.

NO.37 You must enforce data integrity for data Inserted in a JSON column.
Which statement successfully creates a constraint in a 3SON column?

CREATE TABLE fshop (product JSON CHECK (JSON_VALID(product) ) ) ;

CREATE TABLE fshop ( product JSON, f INT’ GENERATED ALWAYS AS (product->”S – id”) ) ;

CREATE TABLE fshop (id INT NOT NULL AUTOINCREMENT, product JSON, PRIMARY KEY (id)) ENGINE=InnoDB;

CREATE TABLE fshop (id INT NOT NULL AUTO_ INCREMENT, product JSON, CHECK (id>0) ) ENGXNE=InnoDB;

NO.38 Examine this SQL statement:

db.country. fields ( [ ‘Name ‘ , ‘Population* ] ) .where ( ‘Name LIKE “United%’,,) -select ()-limit(5)

db . country, select ( [ ‘ Name LIKE “united%” ‘ , ‘ Population>^0 ‘ ] ) – limit (5)

db . country. fields ( [ ‘ Name ‘ , ‘Population’]) . select (‘ limit=5 ‘ ) .where(‘Name LIKE “United%” ‘ )

db. country-select([‘Name’,’Population’]) .where(‘Name LIKE :param’) -bind (‘param’ , ‘United*’) -limit(5)

db . country. Select ([Name’ , ‘Population.’] ) -limit (5) .where(‘Name LIKE “United%”‘)

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

NO.40 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.41 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.42 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);

NO.43 Examine this statement which executes successfully:
CREATE TABLE ‘fshop’ (‘product’ JSON DEFAULT NULL ) ENGINE=InnoDB;
Now, examine a json value contained in the table:
{“name” : “orange”, “varieties” : [{“VarietyName”:”Clementine”, “Origin” : [“PA”, “BU”] }, {“VarietyName”: “tangerine”, “Origin” : [“CH”,”JP”]>]> Which will cause documents to be indexed over the ‘name’ key?

ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product-
>* S .varieties. VarietyName ‘ ) VIRTUAL, ADD KEY idx_name (name.) ;

ALTER TABLE fshop ADD COLUMN name VARCHAR(100) AS (product->’ S – varieties’ ) VIRTUAL, ADD KEY idx_name (name) ;

ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product->’ S – name’ ) VIRTUAL, ADD KEY idx_name (name) ;

ALTER TABLE fshop ADD COLUMN name VARCHAR(20), ADD KEY idx_name (name) ;

ALTER TABLE fshop ADD name VARCHAR(20) AS (JSON_ONQUOTE (product->”S.varieties.VarietyName”)), ADD INDEX (name);

NO.44 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.45 Examine the layout of the my_values table.

Examine the data in the my_value3 table.

Examine this statement:

A)

B)

D)

Option A

Option B

Option C

Option D

NO.46 The variables c and d are declared as integer types.
Examine these initialization statements with placeholder value <p1>, which execute successfully:
Now, examine this loop which executes successfully:

Which loop results in the same value of d for all valid values of <p1>?
A)

B)

C)

Option A

Option B

Option C

Option D

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

It inserts a row in the emp table.

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

It inserts a row in the view only.

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

NO.48 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.49 Examine this table definition:

The table must always remain a valid document store collection. What restriction does this impose on any added column?

The column must be a generated column referencing any attribute of doc.

The column must have a default value.

The column must be used in a unique constraint.

The column must be a generated column referencing only an existing attribute of doc.

The column must be indexed.

NO.50 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.51 Examine the Test.php script which is numbered for clarity, and its output:

PHP Fatal error: Uncaught Error: call to underined function mysqli_connect () in Test.php:2 Which action will fix this error?

Enable the mysqli extension in the php.ini file.

Replace line 2 with Slink = mysql.connect {“localhost: 3306n, “username”, “pas “schema”) ;

Replace line 2 With: Slink = mysql_xdevapigetSession
(“mysqlx://username:password@localhost:3306″,”schema”);

Install the PHP executable in the path used by the MySQL installation.

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

NO.53 Examine these statement which execute successfully:

Now, examine this desired output:

Which two queries will produce the out?
A)

B)

D)

E)

Option A

Option B

Option C

Option D

Option E

View All 1z1-909 Actual Exam Questions Answers and Explanations for Free Oct-2022 [Q31-Q53]

Oracle 1z1-909 Exam Syllabus Topics: