Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam 1z0-071 topic 1 question 114 discussion

Actual exam question from Oracle's 1z0-071
Question #: 114
Topic #: 1
[All 1z0-071 Questions]

Which two statements are true about Oracle databases and SQL? (Choose two.)

  • A. Updates performed by a database user can be rolled back by another user by using the ROLLBACK command.
  • B. A query can access only tables within the same schema.
  • C. The database guarantees read consistency at select level on user-created tables.
  • D. A user can be the owner of multiple schemas in the same database.
  • E. When you execute an update statement, the database instance locks each updated row.
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
archit4321
2 weeks, 6 days ago
Selected Answer: CE
C and E are the most accurate
upvoted 1 times
...
billysunday1
1 month, 3 weeks ago
Selected Answer: CE
C and E. https://docs.oracle.com/cd/B28359_01/server.111/b28318/schema.htm#CNCPT111 A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include the following types of objects:
upvoted 1 times
...
billysunday1
1 month, 3 weeks ago
Selected Answer: CD
Answer should be C and D. C is ACID which Oracle SQL always do https://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_8003.htm CREATE USER my_user IDENTIFIED BY my_password DEFAULT TABLESPACE tbspace1 QUOTA UNLIMITED ON tbspace1; GRANT schema1, schema2 TO my_user;
upvoted 1 times
ogi33
1 month, 2 weeks ago
GRANT schema1, schema2 TO my_user make error , can grant only role or privileges https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/GRANT.html#GUID-20B4E2C0-A7F8-4BC8-A5E8-BE61BDC41AC3
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...