When creating a user, what permissions must you grant to
allow them to connect to the database?
Answers were Sorted based on User's Feedback
What are the high-availability solutions in sql server and differentiate them briefly? : 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
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
wat is global index and local indes
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
deleted of control file how will u recover control file?
What are the operating modes in which database mirroring runs? : sql server DBA
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
who owns the operating system files created by the utl_file package?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
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)