|
INTERVIEW QUESTIONS
DATABASE
SQL SERVER
DETAILS
Question: Explain about the architecture of MYSQL?
Answer: Architecture of MYSQL comprises of three main components they are • SQLOS • Relational Engine • Protocol Layer. SQLOS implements basic functions such as thread scheduling, I/O and memory management. Relational engine is used to support databases, stored procedures, tables, etc. SQL functionality is dependent upon the Protocol layer.
|
|
|
Category |
SQL Server Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8659 users |
Added on |
9/16/2014 |
Views |
66238 |
Rate it! |
|
|
Question:
Explain about the architecture of MYSQL?
Answer:
Architecture of MYSQL comprises of three main components they are • SQLOS • Relational Engine • Protocol Layer. SQLOS implements basic functions such as thread scheduling, I/O and memory management. Relational engine is used to support databases, stored procedures, tables, etc. SQL functionality is dependent upon the Protocol layer. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Explain in brief about Microsoft SQL server?
|
View Answer
|
|
How many devices can communicate concurrently?
|
View Answer
|
|
In Reporting Services 2005, how is Report Builder typically deployed to end users?
|
View Answer
|
|
You have a SQL Server 2005 sales database experiencing performance problems because of heavy I/O activity. You decide to create a snapshot of this database every hour, stored on a separate physical disk array and use that for reporting queries. However the queries still seem slow immediately after snapshot creation. Why?
|
View Answer
|
|
What does the CREATE SERVICE statement do in SQL Server 2005?
|
View Answer
|
|
Before a user can build reports using Report Builder in Reporting Services 2005, which one of the following steps must be done first?
|
View Answer
|
|
In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?
|
View Answer
|
|
What does @@textsize return?
|
View Answer
|
|
Which types of replication work with Oracle publishers?
|
View Answer
|
|
You have just upgraded your SQL Server 2000 instance on Windows 2000 to SQL Server 2005. You are looking to begin implementing encryption capabilities and need to choose an algorithm for your data. Which of the following is not available to you?
|
View Answer
|
|
What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?
|
View Answer
|
|
Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database
|
View Answer
|
|
Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?
|
View Answer
|
|
What does the DEALLOCATE statement do in SQL Server 2005?
|
View Answer
|
|
When you install SQL Server 2005 and create a new database, is a Database Master Key created?
|
View Answer
|
|
You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?
|
View Answer
|
|
Where can you view the list of server-scoped DDL triggers?
|
View Answer
|
|
You are setting up a native XML web service on your SQL Server 2005 to respond to inventory requests. How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?
|
View Answer
|
|
You have a few new SQL Server 2005 server instances and you want to be sure that SQL authenticated logins must abide by the password policy. On this platforms can you enforce this?
|
View Answer
|
|
Which protocols support Kerberos authentication on SQL Server 2005?
|
View Answer
|