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

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

  • Full Access (272 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 are true about scalar subquery expressions? (Choose three.)
  1. A
    They can be nested.
  2. B
    They cannot be used in the VALUES clause of an INSERT statement.
  3. C
    A scalar subquery expression that returns zero rows evaluates to zero.
  4. D
    They can be used as default values for columns in a CREATE TABLE statement.
  5. E
    A scalar subquery expression that returns zero rows evaluates to NULL.
  6. F
    They cannot be used in GROUP BY clauses.

Correct Answer:
AEF
Reference:
https://docs.oracle.com/cd/B12037_01/server.101/b10759/expressions010.htm

Question #12
Examine this query:

Which two methods should you use to prevent prompting for a hire date value when this query is executed? (Choose two.)
  1. A
    Use the DEFINE command before executing the query.
  2. B
    Replace '&1' with '&&1' in the query.
  3. C
    Use the UNDEFINE command before executing the query.
  4. D
    Execute the SET VERIFY OFF command before executing the query.
  5. E
    Execute the SET VERIFY ON command before executing the query.
  6. F
    Store the query in a script and pass the substitution value to the script when executing it.

Correct Answer:
AF

Question #13
You need to allow user ANDREW to:
1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table.
2. GRANT that permission to other users.
Which statement will do this?
  1. A
    GRANT UPDATE ON customers.title, customers.address TO andrew;
  2. B
    GRANT UPDATE (title, address) ON customers TO andrew;
  3. C
    GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION;
  4. D
    GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;
  5. E
    GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;
  6. F
    GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;

Correct Answer:
C
chatbot-img GPT-4o - Answer
Indeed, option C is your best choice for allowing Andrew both to modify the TITLE and ADDRESS columns of the CUSTOMERS table and to extend that permission to others. The key here is 'WITH GRANT OPTION' included in the GRANT statement. This specific clause empowers Andrew not only to update specified fields but also to pass along those same privileges, ensuring he can fulfill both requirements laid out in your scenario.

Question #14
You own table DEPARTMENTS, referenced by views, indexes, and synonyms.
Examine this command which executes successfully:
DROP TABLE departments PURGE;
Which three statements are true? (Choose three.)
  1. A
    It will remove the DEPARTMENTS table from the database.
  2. B
    It will drop all indexes on the DEPARTMENTS table.
  3. C
    It will remove all views that are based on the DEPARTMENTS table.
  4. D
    It will remove all synonyms for the DEPARTMENTS table.
  5. E
    Neither can it be rolled back nor can the DEPARTMENTS table be recovered.
  6. F
    It will delete all rows from the DEPARTMENTS table, but retain the empty table.

Correct Answer:
ABE
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables010.htm#ADMIN01505

Question #15
Which three statements are true about Structured Query Language (SQL)? (Choose three.)
  1. A
    It requires that data be contained in hierarchical data storage.
  2. B
    It best supports relational databases.
  3. C
    It provides independence for logical data structures being manipulated from the underlying physical data storage.
  4. D
    It is the only language that can be used for both relational and object-oriented databases.
  5. E
    It guarantees atomicity, consistency, isolation, and durability (ACID) features.
  6. F
    It is used to define encapsulation and polymorphism for a relational table.

Correct Answer:
BCE
chatbot-img GPT-4o - Answer
SQL is inherently designed to facilitate interaction with relational databases, making it a prime language in that environment. It provides some level of independence from the physical data storage, allowing users to manage the data without manipulating its actual storage structurally. It also ensures that any transaction it handles adheres to the ACID properties, crucial for maintaining database integrity and reliability during operations. This combination of features underscores its suitability and robustness for managing relational databases effectively.

Previous Questions Next Questions

All Pages