Online Access Free 1Z1-050 Exam Questions

You are managing an Oracle Database 11 g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMD> lsdsk-l -d DATA
Which statement is true regarding the outcome of this command?

• A.The command succeeds and retrieves information by scanning the disk headers based on an ASMJDISKSTRING value.
• B.The command produces an error because the ASM instance is down.
• C.The command succeeds but it shows only the status of the ASM instance.
• D.The command succeeds but it retrieves only the disk names.

View the Exhibit to examine the parameter values.

You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?

• A.272 MB
• B.362 MB
• C.1440 MB
• D.90 MB

Evaluate the following statements:
CREATE TABLE purchase_orders
(pojd NUMBER(4),
po_date TIMESTAMP,
supplie_id NUMBER(6),
po_total NUMBER(8,2),
CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date)
(PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?),
PARTITION Q2 VALUES LESS THAN (TO_DATE(?1-jul-2007?d-mon-yyyy?),
PARTITION Q3 VALUES LESS THAN (TO_DATE(?1-oct-2007?d-mon-yyyy?),
PARTITION Q4 VALUES LESS THAN (TO_DATE(?1-jan-2008?d-mon-yyyy?));
CREATE TABLE purchase_order_items
(po_id NUMBER(4) NOT NULL, product_id NUMBER(6) NOT NULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_fk
FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
What are the two consequences of the above statements? (Choose two.)

• A.Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the partitions of the PURCHASEJDRDERS table.
• B.Both PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four partitions each.
• C.The PURCHASEJDRDERJTEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
• D.Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
• E.Partition maintenance operations performed on the PURCHASEJDRDERJTEMS table are automatically reflected in the PURCHASEjDRDERS table.

Which statements are true regarding SecureFile LOBs? (Choose all that apply.)

• A.SecureFile LOBs can be used only for nonpartitioned tables.
• B.SecureFile encryption allows for random reads and writes of the encrypted data.
• C.Fragmentation is minimized by using variable-sized chunks dynamically.
• D.It automatically detects duplicate LOB data and conserves space by storing only one copy.
• E.The amount of undo retained is user controlled.

View the Exhibit for the object interdependency diagram.

The PRODUCTS table is used to create the PRODCAT_VW view.
PRODCAT_VW is used in the GET_DATA procedure.
GET_DATA is called in the CHECK_DATA function.
A new column PROD_QTY is added to the PRODUCTS table.
How does this impact the status of the dependent objects?

• A.Only the procedure and function become invalid and must be recompiled.
• B.Only the procedure and function become invalid and get automatically revalidated the next time they are called.
• C.All dependent objects remain valid.
• D.Only the view becomes invalid and gets automatically revalidated the next time it is used.