How would you determine the time zone under which a database
was operating?
Answer Posted / raman
select DBTIMEZONE from dual;
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Why would you use sql agent? : sql server DBA
what is logical system in sap basis
What are the different types of indexes available in sql server? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
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.
what is a user-defined lock?
what are the types of connection load-balancing?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you get actual data change values from previous transactions in oracle?
What are the different ways you can create databases in sql server? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
which background process invoke at the time of upgradation tell me???
What is the default port no on which sql server listens? : sql server DBA