Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 381:

  Which two statements are true about extents? (Choose two.)

  A. Blocks belonging to an extent can be spread across multiple data files.
  B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
  C. The blocks of a newly allocated extent, although free, may have been used before.
  D. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.
  B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
  C. The blocks of a newly allocated extent, although free, may have been used before.

• Question 382:

  After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

  

  After changing the value, you notice that FULL redaction continues to redact numeric data with zero. What must you do to activate the new default value for numeric full redaction?

  A. Re-enable redaction policies that use FULL data redaction.
  B. Re-create redaction policies that use FULL data redaction.
  C. Re-connect the sessions that access objects with redaction policies defined on them.
  D. Flush the shared pool.
  E. Restart the database instance.
  E. Restart the database instance.

  ---

  About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.

  Note:

  *

  The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.

  *

  UPDATE_FULL_REDACTION_VALUES Procedure

  This procedure modifies the default displayed values for a Data Redaction policy for full redaction.

  *

  After you create the Data Redaction policy, it is automatically enabled and ready to redact data.

  *

  Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods:

  / Full redaction. / Partial redaction. / Regular expressions. / Random redaction. / No redaction.

• Question 383:

  SALES is a valid TNS entry referring to: Hostname: HOST01

  Port: 1521 Service_name: SALES_SRV You issue this command: $ tnsping SALES Which two are true? (Choose two.)

  A. It validates that there is a listener on HOST01 port 1521.
  B. It validates that SALES is a valid TNSNAMES entry reachable by the configured name resolution method.
  C. It validates that SALES_SRV service is active in any database instance on HOST01.
  D. It validates that a SALES_SRV database on HOST01 is open.
  E. It validates that SALES_SRV service is active in a specific database instance on HOST01.
  A. It validates that there is a listener on HOST01 port 1521.
  D. It validates that a SALES_SRV database on HOST01 is open.

• Question 384:

  Which users are created and can be used for database and host management of your DBaaS database servers?

  A. opc and oracle users
  B. root, oracle and cloud users
  C. root and oracle users
  D. root, opc and oracle users
  E. cloud and oracle users
  A. opc and oracle users

• Question 385:

  Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

  A. Merge partitions of a list partitioned table
  B. Drop partitions of a list partitioned table
  C. Coalesce partitions of a hash-partitioned global index.
  D. Move partitions of a range-partitioned table
  E. Rename partitions of a range partitioned table
  F. Merge partitions of a reference partitioned index
  A. Merge partitions of a list partitioned table
  B. Drop partitions of a list partitioned table
  F. Merge partitions of a reference partitioned index

  ---

  Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.

  A: Merge Multiple Partitions:

  The new "ALTER TABLE ... MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.

  B: Drop Multiple Partitions:

  The new "ALTER TABLE ... DROP PARTITIONS " help drop multiple partitions or subpartitions with a single statement.

  Example:

  view plaincopy to clipboardprint?

  SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;

  Table altered SQL> Restrictions :

  -You can't drop all partitions of the table.

  - If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.

• Question 386:

  The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.

  Which statement is true?

  A. The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.
  B. The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.
  C. The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.
  D. Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.
  C. The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.

• Question 387:

  You install "Oracle Grid Infrastructure for a standalone server" on a host on which the ORCL1 and ORCL2 databases both have their instances running.

  Which two statements are true? (Choose two.)

  A. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
  B. The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.
  C. Both ORCL1 and ORCL2 are automatically added to the Oracle Restart configuration.
  D. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
  E. The crsctl start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
  B. The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.
  D. All database listeners running from the database home are automatically added to the Oracle Restart configuration.

• Question 388:

  You install Oracle Grid Infrastructure standalone server and issue the following command:

  crsctl start has

  Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)

  A. Oracle CSSD services
  B. the database whose instance is running
  C. Oracle Notification services
  D. Oracle Healthcheck services
  E. Oracle Net Listener
  A. Oracle CSSD services
  C. Oracle Notification services

• Question 389:

  Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

  A. You can detach from a data pump export job and reattach later.
  B. Data pump uses parallel execution server processes to implement parallel import.
  C. Data pump import requires the import file to be in a directory owned by the oracle owner.
  D. The master table is the last object to be exported by the data pump.
  E. You can detach from a data pump import job and reattach later.
  A. You can detach from a data pump export job and reattach later.
  B. Data pump uses parallel execution server processes to implement parallel import.

  ---

  B: Data Pump can employ multiple worker processes, running in parallel, to increase job performance.

  D: For export jobs, the master table records the location of database objects within a dump file set. / Export builds and maintains the master table for the duration of the job. At the end of an export job, the content of the master table is written

  to a file in the dump file set.

  / For import jobs, the master table is loaded from the dump file set and is used to control the sequence of operations for locating objects that need to be imported into the target database.

• Question 390:

  Examine the parameters for a database instance:

  

  Which two statements are true? (Choose two.)

  A. Undo records for temporary tables are stored in a temporary tablespace.
  B. Undo records for temporary tables are stored in the undo tablespace and logged in the redo.
  C. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.
  D. No redo is generated for the undo records belonging to temporary tables.
  E. No redo and undo records are generated for temporary tables.
  A. Undo records for temporary tables are stored in a temporary tablespace.
  E. No redo and undo records are generated for temporary tables.