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-051

Oracle 1z0-051 Exam Practice Questions (P. 3)

  • Full Access (290 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 statement correctly describes SQL and /SQL*Plus?
  1. A
    Both SQL and /SQL*plus allow manipulation of values in the database.
  2. B
    /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
  3. C
    /SQL*Plus is a language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
  4. D
    SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database.

Correct Answer:
A

Question #12
Which four are types of functions available in SQL? (Choose 4)
  1. A
    string
  2. B
    character
  3. C
    integer
  4. D
    calendar
  5. E
    numeric
  6. F
    translation
  7. G
    date
  8. H
    conversion

Correct Answer:
BEGH
SQL have character, numeric, date, conversion function.
Incorrect answer:
ASQL have character, numeric, date, conversion function.
CSQL have character, numeric, date, conversion function.
DSQL have character, numeric, date, conversion function.
FSQL have character, numeric, date, conversion function.
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 3-3

Question #13
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which MERGE statement is valid?
  1. A
    MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET
  2. B
    name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);
  3. C
    MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET
  4. D
    name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT valueS(e.employee_id, e.first_name ||', '||e.last_name);
  5. E
    MERGE INTO new_employees cUSING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET
  6. F
    name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);
  7. G
    MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET
  8. H
    name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees valueS(e.employee_id, e.first_name ||', '||e.last_name);

Correct Answer:
A
this is the correct MERGE statement syntax
Incorrect answer:
Bit should MERGE INTO table_name

Cit should be WHEN MATCHED THEN -
Dit should MERGE INTO table_name
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 8-29

Question #14
Which view should a user query to display the columns associated with the constraints on a table owned by the user?
  1. A
    USER_CONSTRAINTS
  2. B
    USER_OBJECTS
  3. C
    ALL_CONSTRAINTS
  4. D
    USER_CONS_COLUMNS
  5. E
    USER_COLUMNS

Correct Answer:
D
view the columns associated with the constraint names in the USER_CONS_COLUMNS view.
Incorrect answer:
Atable to view all constraints definition and names
Bshow all object name belong to user
Cdoes not display column associated

Eno such view -
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-25

Question #15
The COMMISSION column shows the monthly commission earned by the employee.

Exhibit -

Which two tasks would require sub queries or joins in order to be performed in a single step? (Choose two.)
  1. A
    listing the employees who earn the same amount of commission as employee 3
  2. B
    finding the total commission earned by the employees in department 10
  3. C
    finding the number of employees who earn a commission that is higher than the average commission of the company
  4. D
    listing the departments whose average commission is more that 600
  5. E
    listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID
  6. F
    listing the employees whose annual commission is more than 6000

Correct Answer:
AC

Previous Questions Next Questions

All Pages