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
No Answer is Posted For this Question
Be the First to Post Answer
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What is database replicaion? What are the different types of replication you can set up in SQL Server?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the operating modes in which database mirroring runs? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How do you add a data file to a tablespace?
how can you record information about current session?
Describe what redo logs are.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How would you force a log switch?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
Oracle (3253)
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)