Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

Sybase DBA Test

Topics Covered

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

Useful for hiring

  • Sybase DBA Developer
  • Sybase DBA Consultants

Start hiring job-fit candidates using this assessment

GET A DEMO

"We are impressed with Interview Mocha's comprehensive IT skill test batteries and their ability to provide tailor-made assessments quickly. The results we got from Interview Mocha exceeded our expectations, employees found the tests quick, fun, and a benchmark of their knowledge."

Ajay Garg, Siemens,
Associate Manager
Question

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

Answer
    • 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

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

Answer
    • sp_suspect_threshold

    • sp_suspect_db

    • sp_dboption

    • sp_suspect_granularity

    • sp_forceonline_db

Question

What functionality does Recovery Fault Isolation (RFI) provide?

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

Answer
    • 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.

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO