Relations produced from an E-R model will always be in
Relations produced from an E-R model will always be in
Relations produced from an E-R model will always be in
Akilesh Kharvi ? Dec 8 '2016 at 21:39
Answer: 3 NF
Explanation:
BCNF is higher form of normalization then 1,2,3 NF forms so BCNF will always be in 3NF,2NF,1NF
A binary relation is always a BCNF relation.
A driver's salary may not exceed Rs. 25,000 p.m. This is a / an
Akilesh Kharvi ? Dec 8 '2016 at 21:36
Answer : integrity constraint
Explanation:
Integrity Constraints are used to apply business rules for the database tables.
The constraints available in SQL are Foreign Key, Not Null, Unique, Check.
Check Constraint :This constraint defines a business rule on a column. All the rows must satisfy this rule. The constraint can be applied for a single column or a group of columns.Syntax to define a Check constraint: [CONSTRAINT constraint_name] CHECK (condition) example: [CONSTRAINT salary] CHECK salary<25000
Given the relational functional dependencies x —> w ; x ->y ; y -> z and z -> pq which of the following is NOT VALID ?
Akilesh Kharvi ? Dec 8 '2016 at 21:33
Answer:w ->z
Explanation:
If X→Y and Y→Z then X→Z so it is valid.
If X→W and X→Y then X→WY so it is valid.
If Y→Z and Z→PQ then Y→PQ so it is valid.
w not implies anything so w ->z is not valid.
so answer is w->Z
Which of the following is an example of multilevel indexing ?
Akilesh Kharvi ? Dec 8 '2016 at 21:31
Answer : B-tree
Explanation:
A B-tree is a method of placing and locating files (called records or keys) in a database. (The meaning of the letter B has not been explicitly defined.) The B-tree algorithm minimizes the number of times a medium must be accessed to locate a desired record, thereby speeding up the process.
Reference: http://searchsqlserver.techtarget.com/definition/B-tree
The main reason for changing IP addresses from IPv4 to IPv6 is
Akilesh Kharvi ? Dec 8 '2016 at 21:29
Answer : IPv6 provides more addresses than IPv4.
Explanation:
IPv4 uses 32 bits for an IP address that allows about 4 billion unique IP addresses. When IPv4 was introduced in the 1970s and accepted as the protocol for the Internet, they did not foresee this explosion in the popularity of the Internet or the extent to which online technologies would become all pervasive. It was therefore firmly believed that these 4 billion addresses would be sufficient to cover any future growth of the Internet.
IPv6 uses 128 bits for IPv6 addresses which allows for 340 billion billion billion billion (3.4x1038) unique addresses.
When secure data is to be transmitted over a network, encryption and decryption are undertaken by the
Akilesh Kharvi ? Dec 8 '2016 at 21:28
Answer: presentation layer
Explanation:
encryption and decryption is takes place at presentation layer
Attributes in XML indicate
Akilesh Kharvi ? Dec 8 '2016 at 21:26
Answer : a way of attaching properties to elements
Explanation:
Attributes are part of the XML elements. An element can have multiple unique attributes. Attribute gives more information about XML elements. To be more precise, they define properties of elements. An XML attribute is always a name-value pair.
Syntax
An XML attribute has following syntax:
<element-name attribute1="" attribute2="">
....content..
< /element-name>
example:
<garden>
<plants category="flowers"/>
<plants category="shrubs">
</plants>
</garden>
so Attribute is a way of attaching properties to elements