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
- 0 Answers
- 745 Views
- I also Faced
- E-Mail Answers
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
What is a correlated sub-query? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Explain what partitioning is and what its benefit is.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
how can you create a user-defined lock?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Give two examples of referential integrity constraints.
what do you understand by flashback feature of oracle?
What is the difference between Datapump & export/import?
I lost one datafile i dont have backup how can you recover that???
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
