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

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

Question Posted / narmada kumari


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

What view would you use to look at the size of a data file?

3 Answers  

what is the differnce between process and thread ?

1 Answers   IBM,

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

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

0 Answers  

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  




Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

How many packages we have in db

1 Answers   Tesco,

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

Name three advisory statistics you can collect.

1 Answers  

what r the types of backup?

5 Answers   CSC,

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories