Home  >  Oracle  >  Oracle Basics Practice Test: Oracle Applications & Database Operations

There are two sessions currently connected to your database instance. In the first session, the following UPDATE statement is executed:SQL> UPDATE dept SET deptno=80 WHERE dname='SALES';The UPDATE statement above waits to complete the execution. Investigations reveal the following facts:– The UPDATE statement is waiting to acquire a lock– There is referential integrity constraint between the DEPT and EMP table– Department number 30 represents the SALES department– The EMP table is updated in the second session as follows:SQL> UPDATE emp SET sal=sal*0.17 WHERE deptno=30;Which action would you perform to avoid waiting in the first session ?

🎲 Try a Random Question  |  Total Questions in Quiz: 60  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
Oracle Basics Practice Test: Oracle Applications & Database Operations — practice the complete quiz, review flashcards, or try a random question.
🧠 Flashcards (fast review) 🧪 Practice Quiz ⚔️ Challenge a Friend 🥊
Quiz on Oracle application approaches, risks and standards, atomic data and business models, data entry, query and reporting, normalization, foreign key, primary and unique keys. Here are some basics of Oracle Database: Schema: A collection of objects that organizes data into logical units. It is an important element of an Oracle Database, as it provides a way to store and manage the data within the system. Database application: A software program that interacts with a database to access and manipulate data. Data dictionary: The repository that manages memory and storage for the DBMS.... Show more

There are two sessions currently connected to your database instance. In the first session, the following UPDATE statement is executed:<br>SQL> UPDATE dept SET deptno=80 WHERE dname='SALES';<br>The UPDATE statement above waits to complete the execution. Investigations reveal the following facts:<br /><br>– The UPDATE statement is waiting to acquire a lock<br /><br>– There is referential integrity constraint between the DEPT and EMP table<br /><br>– Department number 30 represents the SALES department<br /><br>– The EMP table is updated in the second session as follows:<br>SQL> UPDATE emp SET sal=sal*0.17 WHERE deptno=30;<br>Which action would you perform to avoid waiting in the first session ?






 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.