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

Which two statements are true about the B-tree Index?

• A.The leaf blocks in the index are doubly linked.
• B.The leaf node stores a bitmap for each key value.
• C.The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.
• D.Rows with a NULL value in key columns also have entries in the Index.

Which two statements about ADDM are true?

• A.Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
• B.Regular ADDM uses AWR snapshots that are not yet purged.
• C.Real-Time ADDM uses AWR snapshots of the last 10 minutes.
• D.Real-Time ADDM uses ASH recent activity from SGA data.

Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?

• A.opatchlsinventory -xml
• B.select xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual
• C.select patch from vSoption where opatch_data=' 333333' ;
• D.select opatch from vSpatchsets where opatch_number = '333333';

In Oracle Database 12c, when does a transaction begin?

• A.when the first executable SQL statement is encountered
• B.when a transaction is assigned to an available undo data segment to record undo entries for the new transaction
• C.when a transaction ID is allocated for it.
• D.when a user explicitly issues a "begin" statement

In this SQL statement, what is the partitioning criteria?
CREATE TABLE books_part
PARTITION BY RANGE (cell_id) ( PARTITION p0l VALUES LESS THAN (2),
PARTITION p02 VALUES LESS THAN (3) ,
. . .
PARTITION pl4 VALUES LESS THAN (15),
PARTITION pl5 VALUES LESS THAN (16),
PARTITION pl6 VALUES LESS THAN (MAXVALUE)
)
AS SELECT * FROM books;

• A.There is no partitioning criteria.
• B.pxx
• C.cell_id
• D.books
• E.MAXVALUE