Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
Answer / guest
o A full database backup is a full copy of the database.
o A transaction log backup copies only the transaction log.
o A differential backup copies only the database pages
modified after the last full database backup.
o A file or filegroup restore allows the recovery of just
the portion of a database that was on the failed disk.
| Is This Answer Correct ? | 3 Yes | 3 No |
How would you determine who has added a row to a table?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
When creating a user, what permissions must you grant to allow them to connect to the database?
what is the diffrence between core dba and apps dba?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What view would you use to look at the size of a data file?
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
What is database replicaion? What are the different types of replication you can set up in SQL Server?
How can we see the database version in os level
Why would you call update statistics? : sql server DBA
which background process invoke at the time of upgradation tell me???
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)