microsoft 98-364 online test
Database Fundamentals
What students need to know about the 98-364 exam
- Total 235 Questions & Answers
- Passing score: 700
Question 1
In which situation do you need to perform a restore on a database?
- A. when data becomes corrupted in the database
- B. when you need to roll back a transaction
- C. when you encounter an error in your application
- D. when data needs to be deleted from the database
Answer:
A
Question 2
You are a Database Administrator of MySQL database.
Few days back, your server crashed. Now, it is up and online.
You need to check the integrity of various tables used in the database.
You need to issue the CHECK TABLE command.
For which of the following tables will this command work? Each correct answer represents a complete solution. (Choose
two.)
- A. FEDERATED
- B. MyISAM
- C. MERGE
- D. InnoDB
Answer:
B D
Question 3
Which of the following is the process of extracting trails on a regular basis so that they can be transferred to a designated
security system where the database administrators do not have access?
- A. Native auditing
- B. Abstraction
- C. Database security
- D. Encryption
Answer:
A
Question 4
Which of the following is an ANSI approved language for communicating and managing data in a relational database
management system (RDBMS)?
- A. SQL
- B. DDL
- C. XML
- D. QL
Answer:
A
Question 5
You manage a database named Exams accessed via a website.
The website is regularly accessed by users in different countries.
You are redesigning a table named History that records when users have purchased and taken online exams.
You need one of the columns in the History table to record what time of day that a user has taken an exam.
Additionally, you need this column to have time zone awareness.
What data type should you use?
- A. datetimeoffset
- B. datetime
- C. Use two different columns with one column of datetime, and the second column indicating the UTC offset.
- D. datetime2
Answer:
A
Question 6
This question requires that you evaluate the underlined text to determine if it is correct.
The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers, constraints, and
permission specifications for those tables.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is
incorrect, select the answer choice that makes the statement correct
- A. No change is needed
- B. DROP TABLE
- C. TRUNCATE TABLE
- D. ALTER TABLE
Answer:
B
Question 7
You work as the Database Administrator for a MySQL database server.
In an hour or so, you are able to bring a corrupted server online.
You execute the CHECK TABLE command and find that some of the InnoDB tables need to be repaired.
You restart the server and discover that auto-recover has failed.
Which of the following steps will you take to recover the corrupted InnoDB tables?
- A. Run the ANALYZE TABLE command.
- B. Run the REPAIR TABLE command.
- C. Recover the tables from the last backup.
- D. Run the OPTIMIZE TABLE command.
- E. Restart the server with the innodb_force_recovery option.
Answer:
D
Question 8
The component that holds information for a single entry in a table is called a:
- A. Data type
- B. Row
- C. Column
- D. View
Answer:
B
Question 9
You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter
and four digits. Which data type should you use for the AccountNumber column?
- A. CHAR
- B. BYTE
- C. DOUBLE
- D. SMALLINT
Answer:
A
Question 10
You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer:
D