Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 131:

  SQL> CREATE BIGFILE TABLESPACE MRKT

  2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING

  3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

  Tablespace created.

  SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;

  Database altered.

  Which two statements are true regarding the MRKT tablespace? (Choose two.)

  A. No more data files can be added to the tablespace.
  B. Segment space is managed by free lists in the tablespace.
  C. A user created without being assigned a default tablespace uses this tablespace.
  D. The tablespace can be dropped with the current setting with segments present in it.
  A. No more data files can be added to the tablespace.
  C. A user created without being assigned a default tablespace uses this tablespace.

• Question 132:

  You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode. Given below are the steps to accomplish the task in random order:

  1.

  Shut down the instance.

  2.

  Execute the ALTER DATABASE ARCHIVELOG command.

  3.

  Start up the instance and mount the database.

  4.

  Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.

  5.

  Open the database.

  Which is the correct sequence of steps for accomplishing the task?

  A. 4, 1, 3, 2, 5
  B. 1, 3, 4, 5, 2
  C. 1, 3, 2, 5; 4 not required
  D. 4, 1, 5, 2; 3 not required
  E. 1, 3, 4, 5; 2 not required
  C. 1, 3, 2, 5; 4 not required

• Question 133:

  You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this. Which data types would you use for the new column?

  A. CLOB
  B. BLOB
  C. BFILE
  D. LONG RAW
  C. BFILE

• Question 134:

  View the Exhibit to examine the error that occurred during the database startup.

  

  You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:

  RMAN> REPAIR FAILURE;

  Which statement describes the consequence of this command?

  A. The command performs the recovery and closes the failure
  B. The command only displays the advice and the RMAN script required for recovery
  C. The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR)
  D. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command
  D. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command

• Question 135:

  You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape: Which two statements are true about differential incremental backups? (Choose two.)

  A. The backup performed on Sundays contains all the blocks that have ever been used in the database
  B. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup
  C. The backup performed on each working day contains all the blocks that have changed since the last level 0 backup
  D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup
  A. The backup performed on Sundays contains all the blocks that have ever been used in the database
  D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup

• Question 136:

  You have to create a table, STUDENTS, with the columns: STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID. The following constraints have to be enforced on this table:

  1) Each student must be uniquely identifiable by the STUDENT_ID.

  2) STUDENT_ID column should not be left blank.

  3) The student should not be less than 15 years of age.

  4) The student can only take a course that is specified in the COURSE table in the database.

  Which three constrains must be explicitly enforced on this table? (Choose three.)

  A. check constraint on the COURSE_ID column
  B. foreign key constraint on the COURSE_ID column
  C. check constraint on the DATE_OF_BIRTH column
  D. unique key constraint on the STUDENT_ID column
  E. not null constraint on the DATE_OF_BIRTH column
  F. primary key constraint on the COURSE_ID column
  B. foreign key constraint on the COURSE_ID column
  C. check constraint on the DATE_OF_BIRTH column
  F. primary key constraint on the COURSE_ID column

• Question 137:

  Which two can be exported by a non-administrative account by using Data Pump? (Choose two.)

  A. database
  B. tables
  C. tablespaces
  D. directory objects
  E. schemas
  B. tables
  E. schemas

• Question 138:

  In which three situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose three.)

  A. If a table is not in a cluster
  B. If a table has an active trigger
  C. If a table has an encrypted column
  D. If a table has a VARCHAR2 column in it
  E. If a table has a referential integrity constraint defined on it
  B. If a table has an active trigger
  C. If a table has an encrypted column
  E. If a table has a referential integrity constraint defined on it

• Question 139:

  A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command? (Choose two.)

  A. It fails if any existing row violates the constraint.
  B. It does not validate the existing data in the table.
  C. It enables the constraint to be enforced at the end of each transaction.
  D. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
  A. It fails if any existing row violates the constraint.
  D. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

• Question 140:

  You plan to configure the new Oracle Database 11g installation by performing these tasks:

  -Use Automatic Storage Management (ASM) as the storage option.

  -

  Use Oracle Enterprise Manager Database Control to manage the database.

  -

  Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during the installation.

  -Configure the database to send email notifications. Some tools available to you for installation are:

  1: Oracle Universal Installer (OUI)

  2: Database Configuration Assistant (DBCA)

  3: Database Upgrade Assistant (DBUA)

  4:

  Oracle Net Configuration Assistant Which tools would you use for this installation?

  A. 2
  B. 3
  C. 1 and 2
  D. 3 and 4
  E. 1,2 and 4
  E. 1,2 and 4