1z1-909 試験問題を無料オンラインアクセス

Examine these lines of Python code:

You must add a line of code to complete the code to return data to the variable d. Which line will do this?

• A.d = cursor.execute(query, (hire_start, hire_end) )
• B.d = cursor . f etchall (query)
• C.d = cursor.fetchall(query, (hire_start, hire_end))
• D.d = cursor.fetch(query % (hire_start, hire_end))
• E.d = cursor.fetch(query, (hire_start, hire_end))
• F.d = cursor.execute(query)

Examine these MySQL Shell statements:

What is the true about the attempts to add document to the collection?

• A.First three documents are added, then different number of fields cause an error.
• B.First two documents are added, then mismatched field names cause an error.
• C.All documents are added without any error or warning.
• D.All documents are added and cause a warning.
• E.First two documents are added, then mismatched field names cause a warning.

Which two statements are true about aggregate functions?

• A.SUM () returns o if there are no rows to aggregate.
• B.COUNT (distinct) returns a count of the number of rows with different values including Null.
• C.MIN () cannot use distinct when it executes as a Windows function.
• D.MAX () returns null if there are no rows to aggregate.
• E.AVG () does not allow use of the distinct option.

Examine these statements which execute successfully:

Which two changes will improve this query performance?

• A.CREATE INDEX 1X3 ON locations <loc_site_id) ;
• B.CREATE INDEX 1X4 ON Locations (site_id, loc_shared);
• C.CREATE INDEX 1X2 ON locations (loc_mapping) USING HASH; fH
• D.CREATE INDEX 1X6 ON users (user_name);
• E.CREATE INDEX 1X7 ON users (user_name) USING HASH;
• F.CREATE INDEX IX1 ON locations (loc_shareci) ;
• G.CREATE INDEX 1X5 ON users (loc_id);

Examine these statements which execute successfully:

The statements executed without exception. Which two are true?

• A.The transaction is rolled back to the savepoint.
• B.No transaction commits.
• C.No row is inserted into band.
• D.One row is inserted into band.
• E.Two transactions commit.