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
4228 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

Give two examples of referential integrity constraints.

2 Answers

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

why we use cursors

1 Answers

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

0 Answers Oracle,

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers

how can you enable flashback feature?

0 Answers Oracle,

What is replication? : sql server DBA

0 Answers

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers

For more DB Administration Interview Questions Click Here