We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Let suppose you are working as a database controller in a renowned company which has a huge database system that change recurrently. A lot of transactions, searches and DML operations are being processed daily. It is obvious that these operations facilities are being provided by different types of query languages.

Following are the two cases;

  • The organization wishes to speed up its retrieval process of data from database table(s), having no Unicode characters and also demands to save hard disk space.
  • The organization wishes to speed up its retrieval process of data from database table(s), having Unicode characters and also needs not to save hard disk space.

For above mentioned cases, you are asked to create columns (table) of database with suitable data types meeting to the following conditions. 

  • The column (Table) will hold a fixed-length Unicode characters like Japanese, Chinese, French, Arabic and so on characters. 
  • The data stored in a column is Unicode or multilingual and is of variable length.

Suggest the suitable Data Types, NCHAR, NVARCHAR, CHAR and VARCHAR, for the above mentioned situations with reasoning; so that the retrieval of information from the column (tables) would be fast enough.

Note: In the above scenario you only read from columns (table) and not write to columns (table).

For every situation explain your answer with suitable arguments.

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 5270

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Please Discuss here about this GDB.Thanks
Our main purpose here discussion not just Solution
We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.

koi hai ju solution share ker de

khud ki koshesh krna hogi .

dosto plz chak it and coments here 

  • The data stored in a column is Unicode or multilingual and is of variable length.

Answer:

NVARCHAR is used in this questions because Variable-length Unicode string data. n defines the string length and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size, in bytes, is two times the actual length of data entered + 2 bytes.Therefore, NVARCHAR is best for this.

not suitable answer

so u can help?

Any Hints of GDB CS403, Please Share...........

This solution was very helpful thanks @Muhammad Azeem

NVARCHAR having Performance issue due to "Double Byte Storage" Disk space is not the issue but memory and performance will be. Double the page reads, double index size.

 

Depending on your DBMS, you can create your database defining what would be the character encoding (normally, UTF-8 would do). Once the database was create with that encoding, you can insert text in any language. Take into account that the actual number of characters that you will be able to store within a table column will normally be less that what you defined as string length. For instance, if you create the column as varchar(1000), you will NOT be able to store 1000 character in all cases.

Check your specific DBMS documentation on how to configure UTF-8 encoding.

Take ideas from the given pictures

Attachments:

RSS

Latest Activity

ϝ ι ყ α replied to + "AS"'s discussion Neelam Mat Karna ...
6 minutes ago
ϝ ι ყ α replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Me, Mom and Winters
9 minutes ago
+ M.Tariq Malik left a comment for Waqas Kh@n
10 minutes ago
+ M.Tariq Malik left a comment for Dot Net Developer
12 minutes ago
ϝ ι ყ α replied to ϝ ι ყ α's discussion *خواتین.........XD XD *
13 minutes ago
+ M.Tariq Malik left a comment for AsadJaved
13 minutes ago
ϝ ι ყ α replied to ϝ ι ყ α's discussion *خواتین.........XD XD *
14 minutes ago
+ M.Tariq Malik left a comment for CS619
15 minutes ago
+ M.Tariq Malik left a comment for Zahid Iqbal
16 minutes ago
+ M.Tariq Malik left a comment for Zain
16 minutes ago
+ M.Tariq Malik left a comment for Zareen
17 minutes ago
+ M.Tariq Malik left a comment for Malik AB
19 minutes ago
ϝ ι ყ α liked + Iuuoɔǝut+'s discussion Agar Mujh Sy Mohabbat Hy .........
22 minutes ago
+++LEARNER+++ replied to +++LEARNER+++'s discussion How to Speak Correct English
32 minutes ago
+++LEARNER+++ posted discussions
36 minutes ago
ayesha joined + M.Tariq Malik's group
39 minutes ago
ayesha joined + M.Tariq Malik's group
39 minutes ago
+ ! ! ! ! МĂĤĂŔ βĂŚĨŤ ŚĨĂĹ ^ liked + "αяsαℓ " Ќąƶµяɨ •"'s discussion Me, Mom and Bachy howey paisy
1 hour ago
+ ! ! ! ! МĂĤĂŔ βĂŚĨŤ ŚĨĂĹ ^ liked + "αяsαℓ " Ќąƶµяɨ •"'s discussion Me, Mom and Winters
1 hour ago
+ ! ! ! ! МĂĤĂŔ βĂŚĨŤ ŚĨĂĹ ^ liked + Iuuoɔǝut+'s discussion Mohabbat ab Khamosh ho gai
1 hour ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service