Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform | Interview Question

Q&A Categories

Applications
Business-Objects
Clarify-CRM
- AJAX
- CSS
- CSS3
- Html
- java-Script
- VB-Script
Concepts
- Data-Modeling
- Data-Structures
- OLAP
- OOPS
- UML
Data-Warehouse
- Abinitio
- Analysis-services
- Business-Intelligence
- Cognos
- Concepts-and-Architecture
- Data-Warehouse-General
- DataStage
- Designer
- ETL
- Informatica
- MicroStrategy
- Reportnet
Database
- Btrieve
- Database-Admin
- Firebird
- Informix
- Microsoft-Access
- MYSQL
- PostgreSQL
- SAP-DB
- SQL
- SQL-server-2000-interview-questions
- Stored-Procedures
- Sybase
- Unify
General
- Career-Goals
- Creativity
- Flexibility
- Human-Resources
- Interests
- Job-Peformance
- Leadership
- Motivation
- Personal-Interview
- Self-Assessment
- Skills
Help-Desk
J2EE
- Core-Java
- EJB
- Hibernate
- Java
- Java-Patterns
- JDBC
- JMS
- JSP
- Ruby
- Servlets
- Struts
- Websphere
Languages
Mainframe
- CICS
- COBOL
- DB2
- IDMS
- JCL
- VSAM
Management
- Business-Analyst
- Citrix
- Desktops
- Lotus-Notes
- MBA
- Network
- Project-Manager
- Servers
- Team-Lead
Microsoft
- Ado-NET
- Architecture
- ASP
- ASP-NET
- Basics
- C-Sharp
- DataGrid
- DotNet
- Mixed
- VB-NET
- Visual-Basic
Microsoft-NET
Networking
- Bluetooth
- Client-Server-Computing
- Computer-Networks
- Networks-and-Security
Operating-System
- Shell-Scripting
- Solaris-Admin
- UNIX
- Unix-Commands
- Unix-Programming
- Windows-Unix
Oracle
- Backup-and-Recovery
- D2K
- Data-Access
- Database-Administration
- Database-security
- Distributed-Processing
- Memory-Management
- Oracle-Forms-3-0
- Oracle-Forms-4-0
- Oracle-General
- PL-SQL
- Programmatic-Constructs
- RMAN
- Scenarios
- SQL-Plus
- System-Architecture
Oracle-Apps
- Application-Object-Library
- Component-Interface
- Flexfields
- Forms-Customization
- HRMS
- PeopleCode
- PeopleTools
- PS-Admin
- PS-Mixed
- Scope-and-Application
- Segment-Security
- SQR
- Technical
- test
Peoplesoft
Programming
- Alogirthms
- C
- C-Plus-Plus
- ColdFusion
- Delphi
- Perl
- PHP
- Python
- VBA
- VoiceXML
- XML
SAP-R-3
- ABAP
- BDC
- Internal-Tables
- Modules
- Reports
- SAP-Admin
- sd
Siebel
- Siebel-General
Testing
- Bug-Tracking
- Common
- Common-Questions
- DataBase-Testing
- Discussion
- Load-Testing
- Product-Testing
- QA-Testing
- Quality-Control
- Quality-Management-
- Security-Testing
- Software-Testing
- Test-Automation
- Test-Cases
- Testing-General
- Testing-Scenarios
- Web-Testing
- Whitebox-Testing
- Wireless-Testiing
Testing-Tools
- LoadRunner
- QTP
- Rational-Robot
- SilkTest
- Test-Director
- Winrunner
Web
Accounting-Reports
Accounts-Payable
Accounts-Receivables
Audit
Cashier
Cost-Accounting
Fixed-Assets
General-Ledger
Payroll
Supervisory

Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform

Sep

8

2010

Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform a full database backup. You decide to implement the following backup strategy : Full backup : 9am SundayFile 1 backup : 8pm Monday eveningFile 2 backup : 8pm Tuesday eveningFile 3 backup : 8pm Wednesday eveningFile 1 backup : 8pm Thursday eveningFile 2 backup : 8pm Friday eveningFile 3 backup : 8pm Saturday eveningTransaction log backups : Hourly, every day.DB suffers critical failure ‘

In: SQL-server-2000-interview-questions Asked By: faiz [

]

Answer this Question Now

No Answers yet, be the first to Answer!

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Sign Up

Get all of your questions answered now!

Member Log In

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr

[1 - 25

]

Green Star Level

[26 - 50

]

Blue Star Level

[51 - 500

]

Orange Star Level

[501 - 5000

]

[5001 - 25000

]

Black Star Level

[25001+

]