+ Reply to Thread
Results 1 to 2 of 2
  1. Junior Member Registered Member
    Join Date
    Sep 2016
    Posts
    1
    #1

    Default Exam 98-364 - General databases or MS SQL server database?

    Hi All,

    My main question is - Exam 98-364 refers to Microsoft SQL server or generally to the databases?

    I am asking because doing test exams I came accross two different type of exams.

    1. Basic type, I would say the easy one with basic questions which can be found in the famous book "Exam 98-364 MTA Database Administration Fundamentals" or on main Microsoft training on virutal academy:
    https://mva.microsoft.com/en-us/trai...xJy_5904984382

    So such exam has basic questions about DML, DDL, normalization, data types and so on ...

    2. Difficult type with questions from All SQL providers (Oracle, MySql and so on) also with difficult questions from the area of database design and so on..

    Examples:

    "JDBC API 2.0 deifnes five levels of transaction isolation for database concurrency control. Which of the following is the lowest level of transaction isolation"?
    1. TRANSACTION_SERIALIZABLE
    2. TRANSACTION_NONE
    3. TRANSACTION_READ_COMMITTED
    4. TRANSACTION_READ_UNCOMMITTED
    5. TRANSACTION_REPEATABLE_READ

    "which statement you use to load timezones to mysql"
    1. /ust/share/zoneinfo mysql_tzinfo_to_sql | myqsl_ -u root mysql
    2. /ust/share/zoneinfo mysql_tz_to_sql | myqsl_ -u root mysql
    3. mysql_tz_to_sql /ust/share/zoneinfo | mysql -u root mysql
    4. mysql_tzinfo_to_sql /ust/share/zoneinfo | mysql -u root mysql

    and similar strange questions from oracle, mysql ....

    Can you please help me and specify what exactly I can expect on that exam ?
    Thank you very much in advance for help.
    Andrzej
    Reply With Quote Quote  

  2. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #2
    https://www.microsoft.com/en-us/lear...am-98-364.aspx

    That has everything you need to know about the exam.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks