1Z0-082 practice questions 151–160

1. Question 151 · 167 in bank

   Select 2

   Which two tasks can you perform using DBCA for databases? (Choose two.)

   • AConfigure a nonstandard block size for a new database
   • BRegister a new database with an available Enterprise Manager Management server
   • CChange the standard block size of an existing database
   • DConfigure incremental backups for a new database
   • EEnable flashback database for an existing database

   Show answer

   Answer: AB

   Explanation

   Reference: https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm

   Next question

2. Question 152 · 167 in bank

   You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr') What is the result?

   • AIt executes successfully but does not return any result
   • BIt returns the date for the first Monday of the next month
   • CIt generates an error
   • DIt returns the date for the last Monday of the current month

   Show answer

   Answer: B

   Explanation

   the correct query is SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') FROM DUAL; I had this question also on the 1Z0-071 exam.

   Source: Adapted from community discussion — zouve

   Next question

3. Question 153 · 167 in bank

   Select 2

   Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE 'undotbs_01.dbf' SIZE 100M - AUTOEXTEND ON; Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

   • AAdd the SEGMENT SPACE MANAGEMENT AUTO clause
   • BSet UNDO_TABLESPACE to UNDOTBS01
   • CAdd the NOLOGGING clause
   • DMake certain that the database operates in automatic undo management mode
   • EAdd the ONLINE clause

   Show answer

   Answer: BD

   Explanation

   Also vote for B & D. SQL>alter system set undo_management=manual scope=spfile; Bounce instance. SQL> show parameter undo NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ temp_undo_enabled boolean FALSE undo_management string MANUAL undo_retention integer 900 undo_tablespace string UNDOTBS1 SQL> alter system set undo_tablespace='UNDOTBS2'; alter system set undo_tablespace='UNDOTBS2' * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-30014: operation only supported in Automatic Undo Management mode

   Source: Adapted from community discussion — Asmodeus

   References

   • Oracle documentation

   Next question

4. Question 154 · 167 in bank

   Select 3

   Which three statements are true about Data Manipulation Language (DML)? (Choose three.)

   • AINSERT statements can insert NULLS explicitly into a column.
   • BINSERT INTO...SELECT...FROM statements automatically commit.
   • CDML statements require a primary key be defined on a table.
   • DDELETE statements can remove multiple rows based on multiple conditions.
   • EUPDATE statements can have different subqueries to specify the values for each updated column.

   Show answer

   Answer: ADE

   Next question

5. Question 155 · 167 in bank

   Select 2

   You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf SIZE 5G - SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace? (Choose two.)

   • AIt must be smaller than the smallest BIGFILE tablespace
   • BFree space is managed using freelists
   • CAny data files added to the tablespace must have a size of 5 gigabytes
   • DIt uses the database default blocksize
   • EIt is a locally managed tablespace

   Show answer

   Answer: DE

   Explanation

   Incorrect segment management clause It lets you specify whether Oracle Database should track the used and free space in the segments in the tablespace using free lists or bitmaps. This clause is not valid for a temporary tablespace. AUTO :Specify AUTO if you want the database to manage the free space of segments in the tablespace using a bitmap. MANUAL :Specify MANUAL if you want the database to manage the free space of segments in the tablespace using free lists E - Correct https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11360 Create a locally managed tablespace by specifying LOCAL in the EXTENT MANAGEMENT clause of the CREATE TABLESPACE statement. This is the default for new permanent tablespaces, D - Correct https://docs.oracle.com/cd/B28359_01/server.111/b28310/create005.htm#ADMIN11105 The most commonly used block size should be picked as the standard block size. In many cases, this is the only block size that you need to specify. Typically, DB_BLOCK_SIZE is set to either 4K or 8K. If you do not set a value for this parameter, the default data block size is operating system specific.

   Source: Adapted from community discussion — Mandar79

   References

   • Oracle documentation
   • Oracle documentation

   Next question

6. Question 156 · 167 in bank

   Select 2

   Which two statements are true regarding a SAVEPOINT? (Choose two.)

   • ARolling back to a SAVEPOINT can undo a CREATE INDEX statement
   • BRolling back to a SAVEPOINT can undo a TRUNCATE statement
   • COnly one SAVEPOINT may be issued in a transaction
   • DA SAVEPOINT does not issue a COMMIT
   • ERolling back to a SAVEPOINT can undo a DELETE statement

   Show answer

   Answer: DE

   References

   • Oracle documentation

   Next question

7. Question 157 · 167 in bank

   In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB); Which segment or segments, if any, are created as a result of executing the command?

   • AT1, an index segment for the primary key, a LOB segment, and a lobindex segment
   • Bno segments are created
   • CT1 only
   • DT1 and an index segment created for the primary key only
   • ET1, an index segment for the primary key, and a LOB segment only

   Show answer

   Answer: B

   Explanation

   SQL> alter session set deferred_segment_creation=TRUE; Session altered. SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB); Table created. SQL> select segment_name,segment_type,bytes from user_segments; no rows selected Answer is B

   Source: Adapted from community discussion — Chansi

   Next question

8. Question 158 · 167 in bank

   Select 3

   Which three activities are recorded in the database alert log? (Choose three.)

   • AData Definition Language (DDL) statements
   • Bnon-default database parameters
   • Cblock corruption errors
   • Ddeadlock errors
   • Esession logins and logouts

   Show answer

   Answer: BCD

   Explanation

   Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247

   Source: Adapted from community discussion — Mandar79

   References

   • Oracle documentation
   • Oracle documentation

   Next question

9. Question 159 · 167 in bank

   Select 2

   Which two statements are true about Enterprise Manager (EM) Express?

   • AYou can use a single instance of EM Express to manage multiple database running on the same server.
   • BEM Express uses a separate repository database to store target database metadata.
   • CBy default, EM express is available for a database after database creation using DBCA.
   • DYou can shut down a database instance using EM Express.
   • EYou cannot start up a database instance using EM Express.

   Show answer

   Answer: CE

   Next question

10. Question 160 · 167 in bank

    Select 3

    Examine this SQL statement: SELECT cust_id, cust_last_name `Last Name` FROM customers - WHERE country_id = 10 - UNION - SELECT cust_id CUST_NO, cust_last_name FROM customers - WHERE country_id = 30 - Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

    • AORDER BY ג€Last Nameג€
    • BORDER BY 2, 1
    • CORDER BY 2, cust_id
    • DORDER BY CUST_NO
    • EORDER BY ג€CUST_NOג€

    Show answer

    Answer: ABC

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

1Z0-082 practice, question 151. 167 questions available.