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

andriijandriij Registered Users Posts: 1 ■□□□□□□□□□
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/training-courses/database-fundamentals-8243?l=TEBiexJy_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

Comments

Sign In or Register to comment.