Answer / Anand Prakash Trivedi

To start SQL Server in minimal configuration mode, you can use the command-line parameter '-m'. For example: 'sqlservr.exe -m' on Windows or 'sudo service sqlservr start --minimal' on Linux.

Answer / santhosh

In a Command Prompt window, you can start the SQL server in
minimal configuration mode by typing: sqlservr -c -f

This command also starts the SQL server in single-user mode.
Also, the server will not run any startup stored procedures.
Additionally, when you start the SQL server in minimum
configuration mode, then SQL Server automatically sets the
size of tempdb to 2 MB on its default device. You must then
manually increase the size of tempdb as necessary.

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

What command would you use to create a backup control file?

2 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

Explain CREATE DATABASE syntax?

2 Answers  

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

wat is global index and local indes

1 Answers   Oracle,

---

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

1 Answers  

---

what is a crs resource?

1 Answers   Oracle,

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

what is incremental checkpoint?

1 Answers   CTS,

---