1Z0-071 practice questions 121–130

1. Question 121 · 238 in bank

   Select 3

   Examine this description of the PRODUCTS table:

   

   Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode. Which three commands execute successfully on PRODUCTS? (Choose three.)

   • ACREATE INDEX price_idx ON products (price);
   • BALTER TABLE products SET UNUSED (expiry_date);
   • CDROP TABLE products;
   • DALTER TABLE products DROP COLUMN expiry_date;
   • ETRUNCATE TABLE products;
   • FALTER TABLE products DROP UNUSED COLUMNS;

   Show answer

   Answer: ACF

   Next question

2. Question 122 · 238 in bank

   Examine the description of the EMPLOYEES table:

   

   You write this failing statement:

   

   Which clause causes the error?

   • ASELECT
   • BGROUP BY
   • CWHERE
   • DORDER BY

   Show answer

   Answer: B

   Next question

3. Question 123 · 238 in bank

   Select 2

   Which two are true about the precedence of operators and conditions? (Choose two.)

   • A|| has a higher order of precedence than + (addition).
   • B+ (addition) has a higher order of precedence than * (multiplication).
   • CNOT has a higher order of precedence than AND and OR in a condition.
   • DAND and OR have the same order of precedence in a condition.
   • EOperators are evaluated before conditions.

   Show answer

   Answer: CE

   Explanation

   The rules are listed in descending order: Parentheses (as well as brackets in lookup expressions and IN expressions). Note that you can freely add parentheses any time you want to impose an alternative precedence or to make precedence clearer. * / + - = <> = IS (IS NULL, IS NOT NULL, IS EMPTY, IS NOT EMPTY) BETWEEN NOT AND OR

   Source: Adapted from community discussion — CyberP

   References

   • Oracle documentation
   • Oracle documentation

   Next question

4. Question 124 · 238 in bank

   Select 2

   Evaluate these commands which execute successfully:

   

   Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

   • ASequence ORD_SEQ is guaranteed not to generate duplicate numbers.
   • BSequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times.
   • CColumn ORD_NO gets the next number from sequence and ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.
   • DIf sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.
   • EAny user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

   Show answer

   Answer: CE

   Next question

5. Question 125 · 238 in bank

   Select 3

   Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

   • AA TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row.
   • BThe SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
   • CThe DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
   • DThe CURRENT_TIMESTAMP function returns data without time zone information.
   • EA TIMESTAMP data type column contains information about year, month, and day.

   Show answer

   Answer: BCE

   Next question

6. Question 126 · 238 in bank

   Select 2

   Which two statements about INVISIBLE indexes are true? (Choose two.)

   • AYou use ALTER INDEX to make an INVISIBLE index VISIBLE.
   • BAn INVISIBLE index consumes no storage.
   • CThe query optimizer never considers INVISIBLE indexes when determining execution plans.
   • DYou can only create one INVISIBLE index on the same column list.
   • EAll INSERT, UPDATE, and DELETE statements maintain entries in the index.

   Show answer

   Answer: AE

   Explanation

   A, C are correct. E. The maintenance of entries in the index during data manipulation operations (INSERT, UPDATE, DELETE) is not impacted by the visibility of the index. Both VISIBLE and INVISIBLE indexes are updated accordingly to maintain data integrity and facilitate efficient data retrieval using indexes.

   Source: Adapted from community discussion — Alex72

   Next question

7. Question 127 · 238 in bank

   Select 3

   Which three are true about subqueries? (Choose three.)

   • AA subquery cannot be used in the select list.
   • B< ANY returns true if the argument is less than the highest value returned by the subquery.
   • C< ANY returns true if the argument is less than the lowest value returned by the subquery.
   • DA subquery can be used in a HAVING clause.
   • EA subquery cannot be used in a FROM clause.
   • FA subquery can be used in a WHERE clause.
   • G= ANY can only evaluate the argument against a subquery if it returns two or more values.

   Show answer

   Answer: BDF

   Next question

8. Question 128 · 238 in bank

   Select 2

   Which two statements are true about Entity Relationships? (Choose two.)

   • AA one-to-one relationship is always a self-referencing relationship.
   • BA relationship can be mandatory for both entities.
   • CA many-to-many relationship can be implemented only by using foreign keys.
   • DA one-to-many relationship in one direction is a one-to-one relationship in the other direction.
   • EA table name can be specified just once when selecting data from a table having a self-referencing relationship.

   Show answer

   Answer: BD

   Next question

9. Question 129 · 238 in bank

   Select 2

   Which two are true about self joins? (Choose two.)

   • AThey can use INNER JOIN and LEFT JOIN.
   • BThey require the EXISTS operator in the join condition.
   • CThey require the NOT EXISTS operator in the join condition.
   • DThey require table aliases.
   • EThey have no join condition.
   • FThey are always equijoins.

   Show answer

   Answer: AD

   Next question

10. Question 130 · 238 in bank

    Examine these statements and results:

    

    How many rows are retrieved by the last query?

    • A42
    • B0
    • C14
    • D28

    Show answer

    Answer: C

    Explanation

    If you haven't mentioned on commit preserve / Delete, the default behavior of system is to delete all the rows of GTT. So, once commit is complete, rows are deleted. Again, Insert command will copy all the rows from EMP which is 14 C is correct. Tested as well

    Source: Adapted from community discussion — ArslanAltaf

    Next question

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

1Z0-071 practice, question 121. 238 questions available.