From the database level, how can you tell under which time zone a database is o

From the database level, how can you tell under which time
zone a database is operating?

Question Posted / narmada kumari

1 Answers
4344 Views
I also Faced
E-Mail Answers

From the database level, how can you tell under which time zone a database is operating?..

Answer / b.r.reddy

Select dbtimezone from dual;

Is This Answer Correct ?

4 Yes

1 No

Post New Answer

More DB Administration Interview Questions

internal architecture

0 Answers CSC,

How would you extract DDL of a table without using a GUI tool?

0 Answers

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers

how can you schedule a job in database?

0 Answers Oracle,

Can you redefine a table online?

0 Answers Oracle,

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers Oracle,

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 happens on checkpoint? : sql server DBA

0 Answers

What column differentiates the V$ views to the GV$ views and how?

3 Answers

What is transparent data encryption? : sql server DBA

0 Answers

the process of adding a cpu in sql server is called..?

2 Answers TCS,

For more DB Administration Interview Questions Click Here