Sybase DBA Test

Topics covered

Adaptive Server Installation, Job Scheduler, Transaction Management Data, Reverse Engineering

  • MAQ (Multiple Answer Question)
  • MCQ (Multiple Choice Question)
  • Descriptive Question
  • White Board Simulator
  • Coding Simulator
  • Audio Question
  • Video Question
  • Case Study Question

Sybase DBA test is useful to effectively assess the database skills of candidates before an interview. Sybase DBA test is designed to check the application and database administration skills. The test is created and validated by Subject Matter Experts.

Test Topics :
 
The Sybase DBA Test contains questions on following topics :  

  • Adaptive Server Installation

  • Job Scheduler

  • Transaction Management Data

  • Reverse Engineering

This pre-employment test is useful for hiring:
  • Sybase DBA Developer
  • Sybase DBA Consultants

Test details:

Sybase DBA Test enables employers and recruiters to evaluate skills and job readiness of DBA candidates. For this reason, the emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge.

Test Details: 20 minutes 

20 Application Questions



The combination of Application and Theory questions helps to evaluate Technical as well as practical Skills of Candidates.

Sybase Test (DBA)

Question #1 of 3

What happens to the data and timestamp on a page when a data change is rolled back?

    • Undo data and timestamp changes.

    • Log CLR, undo data and timestamp changes.

    • Log CLR, undo data change and put a new timestamp on the page.

    • Log CLR, undo data change and keep the previous timestamp.

Question #2 of 3

Which stored procedure will set Recovery Fault Isolation for a database?

    • sp_suspect_threshold

    • sp_suspect_db

    • sp_dboption

    • sp_suspect_granularity

    • sp_forceonline_db

Question #3 of 3

What functionality does Recovery Fault Isolation (RFI) provide?

Note: There can be multiple correct answers to this question.

    • List databases with suspect pages.

    • Recover a suspect database

    • Restore a database without dropping

    • Bring suspected pages online for all users after they have been repaired.

SAMPLE REPORT
Candidate Name: David Messi Test Date: 28-May-2014
Test Name: Sybase Test (DBA) Test Start Time: 13.30

Score: 18 Out Of 20

Percentage: 90

Result: PASS

passing score image
SECTION PERFORMANCE
Section Name FAIL PASS
Sybase DBA (Adaptive SQL Server Administrator)
Score: 18/20
STRENGTH AND WEAKNESS
Strength Sybase DBA (Adaptive SQL Server Administrator)
Weakness -
* Note: If score <= 40 then its a Weakness. If score >= 80 then its a Strength.
ONLINE PROCTORING
0%
10 20 30 40 50 60 70 80 90 100%
Tolerable Limit Not acceptable
Window Violation: 0 | Time Violation: 0 secs
CANDIDATE DETAILS
Gender : Male Phone Number : +1-541-754-3010
Total Experience (Years) : 3 Total Experience (Months) : 5
Skill Set : Sybase DBA (Adaptive SQL Server Administrator) Current Employer : Interview Mocha
Current Job Title : Solution Architect Current Salary : 600.00
Expected Salary : 1000000.00 Current Location : Chicago

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo

How Interview Mocha works?

  • Add this test to your account

  • Invite candidates to take this test online

  • Candidates take the test

  • View and share actionable test reports

Trusted by leading brands worldwide

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • hexaware
Why hiring managers and recruiters across the globe love Interview Mocha
  • Largest number of ready pre-employment skill tests
  • Relevant test compositions and quality questions designed by Subject Matter Experts (IM SME)
  • Fastest custom test creation DNA
  • World’s most super easy skill assessment platform
  • High level of platform security implementation
  • Friendly and quick customer support
  • Ready to listen and implement your feedback, we are all ears
  • Affordable pricing

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo