GeekInterview.com
Series: Subject: Topic:
Question: 5 of 250

Locks in Oracle

A user issues the below query, 1. Select * from table1 lock table At the same time DBA is trying to modify this table table1 using alter command, will he able to do that or not?
Asked by: zefyrpma | Member Since Nov-2011 | Asked on: Nov 15th, 2011

View all questions by zefyrpma

Showing Answers 1 - 4 of 4 Answers
anil

Answered On : Dec 13th, 2011

No we cant do if table lock

  
Login to rate this answer.
rohan makode

Answered On : Feb 25th, 2012

No because dba is updating the table so it is not possible.

  
Login to rate this answer.
anil

Answered On : Mar 13th, 2012

there dba can break the lock given to table.
but in real time, no dba has the right to break the lock given by the user

  
Login to rate this answer.
doc123

Answered On : Mar 22nd, 2012

View all answers by doc123

DDL lock are exclusive locks. It shared the data. Means anyone can select data from same table.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Backup and Recovery

Basics

Concepts and Architecture

D2K

Data Access

Database Administration

Database security

Database Tuning

Distributed Processing

General

Memory Management

Oracle Forms 4.0

PL/SQL

Programmatic Constructs

RMAN Interview Questions

Scenarios

SQL

SQL Plus

System Architecture

Interview Coaching

Careers and Higher Education Options for BBA Graduates

How do you handle conflict?

Do you find yourself busy most of the time? Why?

How do you deal and overcome major challenges?

Do you seek advice from others when you have a question?

How do you handle workplace problems?

Do you have any questions that you want to ask?

Do you like working in a team or alone? Explain.

What do you do when someone criticizes you?

BPO Career for BTech Graduates

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe