Wednesday, June 15, 2011

Re: [ vuZs.net ] CS403 Answer requested

 DML perform functions such as 
Select correct option:
Insertion
Deletion
Creation of database
All of above

Ref:

Performance considerations for DML statements

The database server performs additional actions if it detects any down-level version page during the execution of data manipulation language (DML) statements (INSERT, UPDATE, DELETE, SELECT). These actions can impact performance.

 "Select" and "project" are the examples of

Select correct option:

Unary operations

Binary operations

Ternary operations

All of above


REF:


The select, project, and rename operation are called unary operation because they operate on one relation.

Six basic operators:
·       Unary Operators
1)   Select     σ  (Sigma)
2)   Project    ∏ (PI)
3)    Rename -  ρ  (rho)
·       Binary Operators
1)    Union    -  U
2)    Set Difference - 
3)    Cartesian Product - X




________________
Mehreen Humayun
4th Semester, MBA(Banking)
Distance Learning Student
Quality in Everything We Do







On Thu, Jun 16, 2011 at 8:20 AM, Zubair Hussain <zubair@vuzs.net> wrote:

 DML perform functions such as 
Select correct option:
Insertion
Deletion
Creation of database
All of above
"Select" and "project" are the examples of 
 Select correct option: 
  Unary operations
Binary operations
Ternary operations
All of above
Regards

Zubair Hussain
www.vuzs.net

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net

No comments:

Post a Comment