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

883

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1953

What are the commands you'd issue to show the explain plan for "select * from dual"?

1958

how can you get actual data change values from previous transactions in oracle?

808

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

792

how can you schedule a job in database?

797

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3166

Query processing is slow(eg select query)how will u solve that

7152

What is transparent data encryption? : sql server DBA

769

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

745

what are the benefits of flashback feature?

766

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.

1906

Why would you call update statistics? : sql server DBA

756

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1792

how can you implement fine-grained auditing?

801