1Z0-055 | how many questions of 1Z0-055 braindumps?


Q51. View the Exhibit and examine the Data Pump architecture. 

Identify the numbered components. 

A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API 

B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader 

C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump 

D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump 

Answer:

Q52. You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.) 

A. The KEEP option overrides the configured retention policy. 

B. The KEEP option is an attribute of an individual backup piece. 

C. The backup contains only data files and archived redo log files. 

D. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled. 

Answer: A,D 

Q53. Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: 

ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command? 

A. It produces an error because data already exists in the table. 

B. It produces an error because compression can be enabled at table creation only. 

C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately. 

D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data. 

Answer:

Q54. Which dependent object will get invalidated even if it is not affected by the table redefinition? 

A. views 

B. triggers 

C. packages 

D. synonyms 

Answer:

Q55. View the Exhibit that sets the threshold for the Current Open Cursors Count metric. 

Why is the Significance Level threshold type not available in the threshold setting? 

A. because AWR baseline is not enabled 

B. because Current Open Cursors Count is not a basic metric 

C. because the STATISTICS_LEVEL parameter is set to BASIC 

D. because the AWR baseline is a system-defined moving window baseline 

Answer:

Q56. Evaluate the following command and its output: 

SQL>SELECT * FROM dba_temp_free_space; 

TABLESPACE_NAME      TABLESPACE_SIZE     ALLOCATED_SPACE    FREE_SPACE 

LMTEMP                     250609664            101048576             149561088 

Which two statements correctly interpret the output? (Choose two.) 

A. FREE_SPACE indicates only the space that is currently unallocated. 

B. ALLOCATED_SPACE indicates only the space currently allocated and in use. 

C. FREE_SPACE indicates only the space that is currently allocated and available for reuse. 

D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse. 

E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated. 

Answer: D,E 

Q57. To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:

 SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10; 

What is the significance of this setting? 

A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance. 

B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again. 

C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance. 

D. It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes. 

Answer:

Q58. You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task? 

A. Enable Flashback Data Archive for the tables. 

B. Enable supplemental logging for the database. 

C. Specify undo retention guarantee for the database. 

D. Create Flashback Data Archive on the tablespace on which the tables are stored. 

E. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size. 

Answer:

Q59. Evaluate the following SQL statement used to create the PRODUCTS table: 

CREATE TABLE products 

(product_id NUMBER(3) PRIMARY KEY, 

product_desc VARCHAR2(25), 

qty NUMBER(8,2), 

rate NUMBER(10,2), 

total_value AS ( qty * rate)) 

PARTITION BY RANGE (total_value) 

(PARTITION p1 VALUES LESS THAN (100000), 

PARTITION p2 VALUES LESS THAN (150000), 

PARTITION p3 VALUES LESS THAN (MAXVALUE)) 

COMPRESS FOR ALL OPERATIONS; 

Which statement is true regarding this command? 

A. It executes successfully but partition pruning cannot happen for this partition key. 

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key. 

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions. 

Answer:

Q60. You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : 

SQL> shutdown immediate; 

What is the result of executing this command? 

A. The ASM instance is shut down, but the other instances are still running. 

B. It results in an error because other database instances are connected to it. 

C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. 

D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode. 

Answer: