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?

2679

which background process invoke at the time of upgradation tell me???

2728

Where do you find the default index fill factor and how to change it? : sql server DBA

1079

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1727

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.

1992

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1905

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.

2167

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2463

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4348

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1001

What is a correlated sub-query? : sql server DBA

1085

Explain materialized views and how they are used.

2441

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

993

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

3761

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1198