1z1-909 무료 덤프문제 온라인 액세스

Which two statements are true about AUTO_INCREMENT?

• A.A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.
• B.The decimal data type supports AUTO_INCREMENT.
• C.An AUTO_INCREMENT column must be indexed.
• D.A table can have multiple AUTO_INCREMENT columns.
• E.AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.

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?

• A.The select requires json_unquoteo in the where clause.
• B.The virtual values in the name column must be accessed using functions.
• C.Table statistics must be updated to generate values for the name column.
• D.The json_extract() function requires a length value that matches the field length in the schema.
• E.The JSON datatype cannot be used in virtual columns.

Examine these statements issued from Session 1 which execute successfully:

Now, examine this statement issued from Session 2:

What is the outcome of the update statement in Session 2?

• A.The statement will wait for the transaction in Session 1 to finish.
• B.A deadlock will occur.
• C.The row will be updated immediately.
• D.The transaction in Session 1 will be rolled back automatically.

Examine these commands and output:

Which is true?

• A.It returns an error because the DROP TABLE statement did not drop the view.
• B.It returns an error because the CREATE TABLE statement automatically recreated the view.
• C.A new view is created because the previous was dropped on execution of the drop table statement.
• D.Existing emp_vuL is dropped and a new emp_vu1 created with the new definition.

Examine the contents of these tables:

Now examine the expected results for a user with privileges to access the table:

Which query returns the expected results?
A)

B)

C)

D)

• A.Option D
• B.Option A
• C.Option B
• D.Option C