Category «1Z0-062»

How does the PCTFREE storage parameter influence data storage for this table?

You create a locally managed tablespace ORDERS_TBS with automatic segment management.You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;How does the PCTFREE storage parameter influence data storage for this table? A. It allows only 80% of space to be occupied in all data blocks …

Which method provides the fastest way of achieving this?

You want to distribute a set of structured data to your customers who can integrate this data into their existingdatabases irrespective of the platform.Which method provides the fastest way of achieving this? A. using the DBVERIFY utility B. using direct-path INSERT SQL statements C. using SQL*Loader D. using RMAN transportable tablespace operation Show Answer

What would be the effect on current sessions?

Your database is open in read/write mode and multiple users are connected to the database instance.You execute the following command:SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;What would be the effect on current sessions? A. They are not terminated but may only issue queries. B. They are not affected. C. They are terminated immediately. D. They are …

Which statement is true?

Examine the command:SQL> CREATE TABLESPACE test1DATAFILE ‘/u01/app/oracle/oradata/orc1/test01.dbf’ SIZE 5MAUTOEXTEND ON UNIFORM;Which statement is true? A. The data file, TEST01.DBF, can be auto extended to a maximum size of 5M. B. The tablespace, TEST1, can contain a maximum of one data file. C. Allocated and free extents are tracked using bitmaps. D. Segment free space is …

What do you recommend to minimize this?

An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations.What do you recommend to minimize this? A. Configure the nonstandard buffer cache with a buffer size greater than the size of the default buffer cache. B. Increase the size of the shared pool C. Configure the KEEP buffer cache and alter …

Which compression option should be used?

You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressedduring both direct-path INSERT and conventional DML. The table will also be used for queries.Which compression option should be used? A. ROW STORE COMPRESS B. COLUMN STORE COMPRESS FOR QUERY C. COLUMN STORE COMPRESS FOR ARCHIVE LOW D. ROW STORE …

(Choose three.)

Identify three situations in which messages are written to the alert log file. (Choose three.) A. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50)” B. Creating a table returns “ORA-00955: name is already in used by an existing object” …