Exam 98-364 - General databases or MS SQL server database?
andriij
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
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
-
nachodba Member Posts: 201 ■■■□□□□□□□https://www.microsoft.com/en-us/learning/exam-98-364.aspx
That has everything you need to know about the exam.2020 Goals
work-life balance