Skip to main content

1Z0-082 Real Exam Questions

Oracle Database Administration I

176 questions available · Page 1 of 18

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Multiple choice

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

  1. A

    A UNIQUE constraint can use a pre-existing index on the constrained column or columns

  2. B

    A FOREIGN KEY column can contain NULLs.

  3. C

    A PRIMARY KEY constraint can only be added to an empty table.

  4. D

    A column can have only one CHECK constraint.

  5. E

    A CHECK constraint can refer to values in other rows.

Show answer and explanation

Correct answers: A, B

Question 2 Multiple choice

The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8, 2).

Evaluate this SQL statement:

SELECT TO_CHAR(unit_price, '$9,999')
FROM product_information;

Which two statements are true about the output? (Choose two.)

  1. A

    A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #######.

  2. B

    A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.

  3. C

    A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.

  4. D

    A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.

  5. E

    A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.

Show answer and explanation

Correct answers: A, D

Question 3 Multiple choice

TBS1 is a permanent user-defined tablespace. Oracle Managed Files (OMF) is not used in this database.

Examine this command:

DROP TABLESPACE TBS1;

Which two actions will ensure that TBS1 is dropped and its data files are deleted from the file system? (Choose two.)

  1. A

    TBS1 must not contain any temp files.

  2. B

    There must be no uncommitted transactions involving segments stored in TBS1.

  3. C

    TBS1 must be READ WRITE.

  4. D

    The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.

  5. E

    TBS1 must be altered READ ONLY.

Show answer and explanation

Correct answers: B, D

Question 4 Multiple choice

Which two tasks can be performed in the NOMOUNT state? (Choose two.)

  1. A

    renaming data files

  2. B

    full database recovery

  3. C

    re-creating control files

  4. D

    creating a database

  5. E

    enabling online redo log archiving

Show answer and explanation

Correct answers: C, D

Question 5 Multiple choice

Which two statements are true about the COUNT function? (Choose two.)

  1. A

    COUNT (*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.

  2. B

    COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.

  3. C

    A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.

  4. D

    It can only be used for NUMBER data types.

  5. E

    COUNT (inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.

Show answer and explanation

Correct answers: A, B

Question 6 Multiple choice

Which three statements are true about an SPFILE? (Choose three.)

  1. A

    It must exist for a database instance to start.

  2. B

    It can be used to create a pfile.

  3. C

    It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

  4. D

    It can be created by SYS from an idle instance.

  5. E

    It contains only static initialization parameters.

Show answer and explanation

Correct answers: B, C, D

Question 7 Multiple choice

Which two statements are true regarding non-equijoins? (Choose two.)

  1. A

    Table aliases must be used.

  2. B

    The Oracle join syntax can be used.

  3. C

    The SQL1999 compliant ANSI join syntax must be used.

  4. D

    The USING clause can be used.

  5. E

    The ON clause can be used.

Show answer and explanation

Correct answers: B, E

Question 8 Multiple choice

Which two tasks can be performed in the NOMOUNT state? (Choose two.)

  1. A

    Renaming data files

  2. B

    Performing full database recovery

  3. C

    Re-creating control files

  4. D

    Creating a database

  5. E

    Enabling online redo log archiving

Show answer and explanation

Correct answers: C, D

Question 9 Multiple choice

Examine the structure of the two tables:

Which two queries execute successfully? (Choose two.)

  1. A

    SELECT * FROM products MINUS SELECT prod_id FROM new_products;

  2. B

    SELECT prod_id, prod_name FROM products INTERSECT SELECT 100, prod_name FROM
    new_products;

  3. C

    SELECT prod_id, exp_date FROM products UNION ALL SELECT prod_id, NULL FROM
    new_products;

  4. D

    SELECT * FROM products UNION SELECT * FROM new_products;

  5. E

    SELECT prod_id FROM products UNION ALL SELECT prod_id, prod_name FROM new_products;

Show answer and explanation

Correct answers: C, D

Question 10 Multiple choice

Which three are benefits of using temp UNDO when performing DML on global temporary tables? (Choose three.)

  1. A

    It reduces the amount of redo generated.

  2. B

    It permits DML on Global temporary tables even if the database is opened read only.

  3. C

    It reduces I/Os to the SYSAUX tablespace.

  4. D

    It reduces I/Os to the SYSTEM tablespace.

  5. E

    It reduces the amount of UNDO stored in the UNDO tablespace.

Show answer and explanation

Correct answers: A, D, E