[Free] 2018(Jan) Dumps4cert Pass4sure Oracle 1z0-034 Dumps with VCE and PDF 81-90

2018 Jan Oracle Official New Released 1z0-034
100% Free Download! 100% Pass Guaranteed!

Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

Question No: 81

Note the output of the following query:

SQLgt; SELECTflashback_archive_name,status FROM dba_flashback_archive; FLASHBACK_ARCHIVE_NAMESTATUS

——————————- FLA1

You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:

ALTERTABLEexchange_rateFLASHBACK ARCHIVE; What is the outcome of this command?

  1. The table uses the default Flashback Data Archive.

  2. The Flashback Data Archive is created in the SYSAUX tablespace.

  3. The Flashback Data Archive is created in the same tablespace where the tables are stored.

  4. The command generates an error because no Flashback Data Archive name is specified and there is no default Flashback Data Archive.

    Answer: A

    Question No: 82

    Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.

    1. CREATE TABLE employee_ext

    2. (employee_id, first_name, department_name)




  3. LOCATION (#39;emp1.dmp#39;) 8. )


  2. AS

  3. SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name

  4. FROM employees e, departments d;

Which line of the command would cause an error?

  1. line 2, because the column names have been specified

  2. line 7, because file name must have a .dat extension

  3. line 3, because ORGANIZATION EXTERNAL has been specified

  4. line 9, because the PARALLEL option cannot be specified with one file name

  5. line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS table

  6. line 5, because ORACLE_LOADER is not a valid structure for external table creation with the SELECT statement

    Answer: F

    Explanation: External tables are created using the SQL CREATE TABLE…ORGANIZATION EXTERNAL statement. When you create an external table, you specify the followingattributes:

    1. TYPE – specifies the type of external table. The two available types are the ORACLE_LOADER type and the ORACLE_DATAPUMP type. Each type of external table is supported by its own access driver.

  • The ORACLE_LOADER access driver is the default. It can perform only data loads, and the data must comefrom text datafiles. Loads from external tables to internal tables are done by reading from the external tables#39; text-only datafiles .

  • The ORACLE_DATAPUMP access driver can perform both loads and unloads. The data must come from binary dump files. Loads to internal tables from external tables are done by fetching from the binary dump files. Unloads from internal tables to external tables are done by populating the external tables#39; binary dump files.

      1. DEFAULT DIRECTORY – specifies the default location of files that are read or written by external tables. The location is specified with a directory object, not a directory path.

      2. ACCESS PARAMETERS – describe the external data source and implements the type of external table that was specified. Each type of external table has its own access driver that provides access parameters unique to that type of external table.

      3. LOCATION – specifies the location of the external data. The location is specified as a list of directory objects and filenames. If the directory object is not specified, then the default directory object is used as the file location.

        REF.: Oracle(r) Database 10g Utilities, 12-2

        Question No: 83

        Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?

        1. the SYSTEM tablespace

        2. the default permanent tablespace for the non-SYSTEM users

        3. an offline tablespace

        4. a temporary tablespace

        5. a read-only tablespace

        6. an undo tablespace

    Answer: B,D,E,F

    Question No: 84

    View the Exhibits exhibit1 and exhibit2.

    Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2.

    What is the reason for this? lightweight-job-1 (exhibit):

    Dumps4Cert 2018 PDF and VCE

    lightweight-job-2 (exhibit):

    Dumps4Cert 2018 PDF and VCE

    1. It updates several tables in the SYSTEM tablespace instead of creating new tables.

    2. It creates jobs temporarily in memory only.

    3. It creates less metadata for the jobs.

    4. It writes the job metadata to disk in compressed format.

    Answer: C Explanation:

    The difference between two blocks of code is the quot;JOB_STYLEquot;. The lightweight job creates less metadata for the jobs.

    Question No: 85

    Which two statements are correct about database transportation? (Choose two.)

    1. The source and target platforms must be the same

    2. Redo logs, control files and temp files are also transported

    3. The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    4. The COMPATIBLE parameter must be set to or higher and the database must be opened in readonly mode before being transported

    5. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

    Answer: D,E

    Question No: 86

    Evaluate the following statements:

    CREATE TABLE purchase_orders ( po_id NUMBER(4),

    po_date TIMESTAMP, supplier_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(#39;1-apr-2007#39;,#39;d-mon-yyyy#39;), PARTITION Q2 VALUES LESS THAN (TO_DATE(#39;1-jul-2007#39;,#39;d-mon-yyyy#39;),

    PARTITION Q3 VALUES LESS THAN (TO_DATE(#39;1-oct-2007#39;,#39;d-mon-yyyy#39;), PARTITION Q4 VALUES LESS THAN (TO_DATE(#39;1-jan-2008#39;,#39;d-mon-yyyy#39;));

    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.)

    1. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

    2. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

    3. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

    4. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

    5. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

    Answer: B,C

    Question No: 87

    You execute these RMAN commands:


    What will these commands do?

    1. create a backup of the database and recover all corrupted blocks found in the backup

    2. perform a backup validation and list all logically and physically corrupt blocks in the database

    3. perform a backup validation and populate the memory structure used by the vscopy_corruption view with details of any corrupt blocks found

    4. perform a backup validation and populate the memory structure used by the vsDATABASE_BLOCK_CORRUPTION view, then recover any corrupt blocks

    5. create an image copy of the database and recover all corrupted blocks found in the image copy

    Answer: D

    Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta010.htm

    Question No: 88

    Your database is in NOARCHIVELOG mode.

    One of the two data files belonging to the SYSTEM tablespace is corrupt.

    You discover that all online redo logs have been overwritten since the last backup. Which method would you use to recover the data file using RMAN?

    1. Shut down the instance if not already shut down, restart in MOUNT state, restore both data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.

    2. Shut down the instance if not already shut down, restart in mount state, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.

    3. Shut down the instance if not already shut down, restart in mount state, restore all data files for the entire database from the last backup, and restart the instance.

    4. Shut down the instance if not already shut down, restart In MOUNT state, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.

    5. Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data files for the entire database from the last backup, and restart the instance.

    Answer: E

    Reference: http://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmrecov.htm (restoring the server parameter file)

    Question No: 89

    ENCRYPT_TS is an encrypted tablespace that contains tables with data.

    Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

    1. The data is decrypted during SORT and JOIN operations.

    2. The data remains encrypted when it is read into memory.

    3. The data remains encrypted when it is stored in the redo logs.

    4. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

    Answer: C

    Question No: 90

    Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.

    Which two actions will permit the TSPITR to work? (Choose two.)

    1. Taking the MASTERTBS tablespace offline

    2. Dropping the relationship between the tables

    3. Adding the MASTERTBS tablespace to the recovery set

    4. Putting the MASTERTBS tablespace in read-only mode

    Answer: B,C

    100% Free Download!
    Download Free Demo:1z0-034 Demo PDF
    100% Pass Guaranteed!
    Download 2018 Dumps4cert 1z0-034 Full Exam PDF and VCE

    Dumps4cert ExamCollection Testking
    Lowest Price Guarantee Yes No No
    Up-to-Dated Yes No No
    Real Questions Yes No No
    Explanation Yes No No
    PDF VCE Yes No No
    Free VCE Simulator Yes No No
    Instant Download Yes No No

    2018 Dumps4cert IT Certification PDF and VCE

    Leave a Comment


    Your email address will not be published. Required fields are marked *