What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How would you determine the time zone under which a database was operating?
what are the types of connection load-balancing?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Describe what redo logs are.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How would you go about generating an EXPLAIN plan?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
How would you determine who has added a row to a table?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)