What are the operating modes in which database mirroring runs? : sql server DBA

1171

What the different types of replication and why are they used? : sql server DBA

1168

Why would you use sql agent? : sql server DBA

1073

What authentication modes does sql server support? : sql server DBA

1200

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1985

how can you communicate with operating system files from oracle?

1037

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4421

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.

2162

Explain materialized views and how they are used.

2432

what are the types of connection load-balancing?

994

who owns the operating system files created by the utl_file package?

1058

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2797

What are statistics, under what circumstances they go out of date, how do you update them?

2238

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1254

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1010