1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

hi,
suppose i created one table after few days i did some
insert,update how can i know when will i did ddl or dml
operation is undergone on that table

Question Posted / venubabu polineni

Answers were Sorted based on User's Feedback



hi, suppose i created one table after few days i did some insert,update how can i know when will ..

Answer / prashe

select OWNER,OBJECT_NAME,CREATED,LAST_DDL_TIME,from
dba_objects where OBJECT_NAME='&object_name';
for DDL command.

Is This Answer Correct ?    2 Yes 0 No

hi, suppose i created one table after few days i did some insert,update how can i know when will ..

Answer / naga bandaru

we should go with log minor or streams to find when DML
operation have been performed.

Is This Answer Correct ?    2 Yes 0 No

hi, suppose i created one table after few days i did some insert,update how can i know when will ..

Answer / gogune suresh kumar

For DDL operations query user_objects table.
For DML you need to create a trigger for that.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB Administration Interview Questions

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

How many packages we have in db

1 Answers   Tesco,

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

What is a system database and what is a user database? : sql server DBA

0 Answers  




when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

Can you redefine a table online?

0 Answers   Oracle,

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

How to start SQL Server in minimal configuration mode?

1 Answers  

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories