1Z0-082 practice questions 41–50

1. Question 41 · 167 in bank

   Select 2

   Examine the description of the PRODUCT_DETAILS table:

   

   Which two statements are true? (Choose two.)

   • APRODUCT_ID can be assigned the PRIMARY KEY constraint.
   • BEXPIRY_DATE cannot be used in arithmetic expressions.
   • CPRODUCT_NAME cannot contain duplicate values.
   • DEXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.
   • EPRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.
   • FPRODUCT_PRICE contains the value zero by default if no value is assigned to it.

   Show answer

   Answer: AE

   Next question

2. Question 42 · 167 in bank

   Select 2

   Which two statements are true about INTERVAL data types? (Choose two.)

   • AINTERVAL DAY TO SECOND columns support fractions of seconds.
   • BThe YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.
   • CThe value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.
   • DINTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.
   • EINTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.
   • FINTERVAL YEAR TO MONTH support yearly intervals.

   Show answer

   Answer: AF

   Next question

3. Question 43 · 167 in bank

   Examine the description of the EMPLOYEES table:

   

   NLS_DATE_FORMAT is set to DD-MON-YY. Which query requires explicit data type conversion?

   • ASELECT join_date FROM employees WHERE join_date > '10-02-2018';
   • BSELECT join_date + '20' FROM employees;
   • CSELECT salary + '120.50' FROM employees;
   • DSELECT SUBSTR(join_date, 1, 2) - 10 FROM employees;
   • ESELECT join_date || ' ' || salary FROM employees;

   Show answer

   Answer: A

   Explanation

   what about Option D?: SELECT SUBSTR(join_date, 1, 2) - 10 FROM employees; This query is attempting to perform a substring operation on a DATE type, which is not valid without first converting the date to a string. Oracle does not support taking substrings directly from DATE data types. The date must be converted to a string using TO_CHAR before SUBSTR can be used. Furthermore, subtracting 10 from a substring of a date does not make sense unless the substring represents a number, which is not the case here since join_date is a date and not a string of numbers. Therefore, explicit conversion is necessary, and the query itself is somewhat nonsensical without additional context or correction. This makes Option D the most clearly incorrect and the one that certainly requires explicit data type conversion to even make sense as a SQL statement.

   Source: Adapted from community discussion — psycrotic5

   Next question

4. Question 44 · 167 in bank

   Select 2

   You start your database instance in NOMOUNT state. Which two actions are performed? (Choose two.)

   • ASYS can access the database.
   • BThe consistency of the database is checked.
   • CThe control files are opened.
   • DAll required background processes are started.
   • EMemory is allocated for the SGA.

   Show answer

   Answer: DE

   Next question

5. Question 45 · 167 in bank

   Examine the description of the CUSTOMERS table:

   

   You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Which query can be used?

   • ASELECT * FROM customers WHERE city LIKE 'D_%';
   • BSELECT * FROM customers WHERE city = '%D_';
   • CSELECT * FROM customers WHERE city LIKE 'D_';
   • DSELECT * FROM customers WHERE city = 'D_%';

   Show answer

   Answer: A

   Explanation

   there is no valid answer here correct would be (followed by at least two characters): SELECT * FROM EMPLOYEES WHERE FIRST_NAME LIKE 'D__%'; but A is the most correct

   Source: Adapted from community discussion — NowOrNever

   Next question

6. Question 46 · 167 in bank

   Select 2

   Which two statements are true about the PMON background process? (Choose two.)

   • AIt registers database services with all local and remote listeners known to the database instance.
   • BIt frees unused temporary segments.
   • CIt rolls back transactions when a process fails.
   • DIt records checkpoint information in the control file.
   • EIt frees resources held by abnormally terminated processes.

   Show answer

   Answer: CE

   Explanation

   A incorrect cuz: In releases before Oracle Database 12c, PMON was responsible for listener registration, but this task is now the responsibility of the Listener Registration Process (LREG)

   Source: Adapted from community discussion — psycrotic5

   Next question

7. Question 47 · 167 in bank

   Select 2

   Which two statements are true about the Oracle join and ANSI join syntax? (Choose two.)

   • AThe Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
   • BThe Oracle join syntax lacks the ability to do outer joins.
   • CThe SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
   • DThe Oracle join syntax supports creation of a Cartesian product of two tables.
   • EThe Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

   Show answer

   Answer: CD

   Next question

8. Question 48 · 167 in bank

   Select 2

   Which two statements are true about single row functions? (Choose two.)

   • ACEIL : can be used for positive and negative numbers.
   • BMOD : returns the remainder of a division operation.
   • CCONCAT : can be used to combine any number of values.
   • DFLOOR : returns the smallest integer greater than or equal to a specified number.
   • ETRUNC : can be used only with NUMBER data types.

   Show answer

   Answer: AB

   Explanation

   C – false, max 2 arguments D – false, returns biggest integer smaller than specified number E – false, can be also used with DATE datatype

   Source: Adapted from community discussion — nautil2

   Next question

9. Question 49 · 167 in bank

   What is true about non-equijoin statement performance?

   • AThe BETWEEN condition used with a non-equijoin always performs better than when using the >= and <= conditions.
   • BThe BETWEEN condition used with a non-equijoin sometimes performs better than using the >= and <= conditions.
   • CThe Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
   • DThe Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
   • EThe join syntax used makes no difference to performance.

   Show answer

   Answer: E

   Next question

10. Question 50 · 167 in bank

    Select 2

    Which two statements are true about substitution variables? (Choose two.)

    • AA substitution variable can be used with any clause in a SELECT statement.
    • BA substitution variable used to prompt for a column name must be enclosed in double quotation marks.
    • CA substitution variable used to prompt for a column name must be enclosed in single quotation marks.
    • DA substitution variable prefixed with & always prompts only once for a value in a session.
    • EA substitution variable can be used only in a SELECT statement.
    • FA substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session.

    Show answer

    Answer: AF

    Next question

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

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