Information please
-
Hi Gurus,
I want to know some information on the following with respect to SQL Server 2000 context. One of my friends when attended an interview was asked these questions.
1. Stack
2. Queue
3. Pass by value
4. Pass by reference
5. Thread
6. Process
7. Entities
8. Domains
9. Roll Forward
10. Virtual Memory
11. Transaction
I could answer some of them, so wanted to share them with others and know their feedback.
Any light on these areas will be appreciated.
Lucky -
That's what you get when your interviewer only has his/her mandatory-questions-list but without a clue what it's all about
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
7. Entities: Did he ask something related to ER Diagrams?...
Tables are also called entities.
Naveen
-
I just see a list of terms. What are the questions.
-
Hi Alzdba / Reshu Mehta / Robert Stewart
Thanks for your replies. It seems he was asked to explain the technical usage of the listed terms with respect to SQL Server. He applied for a Developer position.
Reshu
He didn't ask about ER diagrams, but basically what do you mean by entities and domains.
Thanks in advance.
Lucky -
3 and 4 are development terms in VB. I am not aware of any context that they apply to SQL directly.
WABALUBADUBDUB
-
Thread
A thread is a Windows function that enables application instructions be separated into many concurrent execution paths.
When the OS executes an application, it creates a unit of work called process. This process has a thread, which is a group of instructions performed by the application. Applications may have one or multiple threads depending on their complexity. Applications with multiple threads are normally complex applications with several tasks that could be performed at the same time. Each thread stores the data unique to it in an area of memory called a stack.
Review Threads in BOL.
Entity
An entity is a logical object that represents a person, place, or thing about which an organization maintains information. An entity in the logical model usually corresponds to a table in a physical data model.
Domain
A domain is an ER (Entity-Relationship) object that assigns properties to an attribute or column. By using domains you ensure consistency because a domain can be reused as many times as you like in a single or multiple data models. Some of the domain properties include column data type, default value, valid value, and user defined properties.
Roll Forward
The SQL Server transaction log keeps information about data modifications applied to databases. This information contains the start and the end of every transaction and associates any data modification with the transaction. With this information in the log, SQL Server can either redo (roll forward) or undo (roll back) the data modifications associated with a transaction.
Review “Transaction Recovery” in BOL.
Transaction
A transaction is a logical unit of work composed of a set of statements (selects, inserts, updates, or deletes) to be applied to a database. If all these statements complete successfully the changes in the transaction are successfully applied to the database otherwise if any of them fail, none of the modifications are applied to the database. All applications used transactions (either implicit or explicit) in order to modify data.
Review “Transaction Architecture” in BOL.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply