DBMS and SQL (EPGDM-103) -  Computer Science Assignment Answer
Assignment Task:

Q1: What is the difference between float and decimal data type?

Q2: Why truncate is DDL Command?

Q3: What is the difference between Candidate key, Primary key and super key?

Q4: Why NULL values are not allowed in the primary key? 

Q5: Describe the database terms: Redundancy, integrity, isolation, durability, consistency, atomicity. 

Q6: What is the difference among DELETE, TRUNCATE, DROP commands? 

Q7: What is the difference between having and where clause? 

Q8: What are the three levels of data abstraction? 

Q9: Is a NULL value same as zero or a blank space? If not then what is the difference? 

Q10: How do you search for a value in a database table when you don’t have the exact value to search for? 

Q11: How do you insert null values in a column while inserting data? 

Q12: How do you copy rows from one table to another? 

Q13: What happens if you omit the WHERE clause in the UPDATE statement? 

Q14: Can you remove rows from a table based on values from another table? Explain.

Q15: Which SQL statement is used to add, modify or drop columns in a database table?

Q16: Which of the following are true: 

An SQL query can contain a HAVING clause only if it has a GROUP BY clause.

  • Not all attributes used in the GROUP BY clause need to appear in the SELECT clause

  • An attribute of an entity can have more than one value.

  • In a row of a relational table, an attribute can have more than one value.

  • Order By clause appears at the end of any query

  •  “Like” is a comparison operator in MySQL.

  • Drop command can delete entire data of table but not table structure

  • Count function in SQL returns the number of distich values

  • Check Constraint can be applied to positive values.

  • All group functions ignore null values.

 

This Computer Science Assignment has been solved by our Computer Science Assignment  Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

 

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Mitchell Lee
  • Posted on : November 05th, 2018

Whatsapp Tap to ChatGet instant assistance