Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-061

Oracle 1z0-061 Exam Practice Questions (P. 2)

  • Full Access (339 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
Which three SQL statements would display the value 1890.55 as $1, 890.55?

  1. A
    Option A
  2. B
    Option B
  3. C
    Option C
  4. D
    Option D

Correct Answer:
AD

Question #12
You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table.
Which query will generate the required result?

  1. A
    Option A
  2. B
    Option B
  3. C
    Option C
  4. D
    Option D B

Correct Answer:
Explanation
FETCH can only be used with FIRST OR NEXT. The syntax is:
FETCH { FIRST | NEXT } [integer-literal | ? ] {ROW | ROWS} ONLY
OFFSET { integer-literal | ? } {ROW | ROWS}
Reference:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljoffsetfetch.html

Question #13
In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:

What would be the outcome?
  1. A
    Abigail PA
  2. B
    Abigail Pa
  3. C
    Abigail IS
  4. D
    An error message

Correct Answer:
B

Question #14
View the Exhibit and evaluate the structure and data in the CUST_STATUS table.

You issue the following SQL statement:

Which statement is true regarding the execution of the above query?
  1. A
    It produces an error because the AMT_SPENT column contains a null value.
  2. B
    It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.
  3. C
    It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null.
  4. D
    It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function.

Correct Answer:
C
The NULLIF Function -
The NULLIF function tests two terms for equality. If they are equal the function returns a null, else it returns the first of the two terms tested.
The NULLIF function takes two mandatory parameters of any data type. The syntax is NULLIF(ifunequal, comparison_term), where the parameters ifunequal and comparison_term are compared. If they are identical, then NULL is returned. If they differ, the ifunequal parameter is returned.

Question #15
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
  1. A
    First normal form
  2. B
    Second normal form
  3. C
    Third normal form
  4. D
    Fourth normal form

Correct Answer:
B
According to the Second Normal Form (2NF) there must be no partial dependencies on a concatenated key.

Question #16
Examine the types and examples of relationships that follow:
1. One-to-one a) Teacher to students
2. One-to-many b) Employees to Manager
3. Many-to-one c) Person to SSN
4. Many-to-many d) Customers to products
Which option indicates the correctly matched relationships?
  1. A
    1-a, 2-b, 3-c, and 4-d
  2. B
    1-c, 2-d, 3-a, and 4-b
  3. C
    1-c, 2-a, 3-b, and 4-d
  4. D
    1-d, 2-b, 3-a, and 4-c

Correct Answer:
C

Question #17
You execute the following commands:

For which substitution variables are you prompted for the input?
  1. A
    None, because no input required
  2. B
    Both the substitution variables 'hiredate' and 'mgr_id\
  3. C
    Only 'hiredate'
  4. D
    Only 'mgr_id'

Correct Answer:
D

Question #18
View the Exhibit and examine the structure of the customers table.

Using the customers table, you need to generate a report that shows the average credit limit for customers in Washington and NEW YORK.
Which SQL statement would produce the required result?

  1. A
    Option A
  2. B
    Option B
  3. C
    Option C
  4. D
    Option D

Correct Answer:
C

Question #19
View the Exhibit and examine the data in the employees table:

You want to display all the employee names and their corresponding manager names.
Evaluate the following query:

Which join option can be used in the blank in the above query to get the required output?
  1. A
    INNER JOIN
  2. B
    FULL OUTER JOIN
  3. C
    LEFT OUTER JOIN
  4. D
    RIGHT OUTER JOIN

Correct Answer:
C

Question #20
Evaluate the following query:

What would be the outcome of the above query?
  1. A
    It produces an error because flower braces have been used.
  2. B
    It produces an error because the data types are not matching.
  3. C
    It executes successfully and introduces an 's at the end of each PROMO_NAME in the output.
  4. D
    It executes successfully and displays the literal "{'s start date was \} * for each row in the output.

Correct Answer:
C
So, how are words that contain single quotation marks dealt with? There are essentially two mechanisms available. The most popular of these is to add an additional single quotation mark next to each naturally occurring single quotation mark in the character string
Oracle offers a neat way to deal with this type of character literal in the form of the alternative quote (q) operator. Notice that the problem is that Oracle chose the single quote characters as the special pair of symbols that enclose or wrap any other character literal. These character-enclosing symbols could have been anything other than single quotation marks.
Bearing this in mind, consider the alternative quote (q) operator. The q operator enables you to choose from a set of possible pairs of wrapping symbols for character literals as alternatives to the single quote symbols. The options are any single-byte or multibyte character or the four brackets: (round brackets), {curly braces}, [squarebrackets], or <angle brackets>. Using the q operator, the character delimiter can effectively be changed from a single quotation mark to any other character
The syntax of the alternative quote operator is as follows:
q'delimiter'character literal which may include the single quotes delimiter' where delimiter can be any character or bracket.

Alternative Quote (q) Operator -
Specify your own quotation mark delimiter.
Select any delimiter.
Increase readability and usability.
SELECT department_name || q'[ Department's Manager Id: ]'
|| manager_id
AS "Department and Manager"
FROM departments;

Alternative Quote (q) Operator -
Many SQL statements use character literals in expressions or conditions. If the literal itself contains a single quotation mark, you can use the quote (q) operator and select your own quotation mark delimiter.
You can choose any convenient delimiter, single-byte or multi byte, or any of the following character pairs: [ ], { }, ( ), or < >.
In the example shown, the string contains a single quotation mark, which is normally interpreted as a delimiter of a character string. By using the q operator, however, brackets [] are used as the quotation mark delimiters. The string between the brackets delimiters is interpreted as a literal character string.

Previous Questions Next Questions

All Pages