22 solutions available
Question 2Assertion. Data redundancy may lead to data inconsistency.Reason. When redundant data or the multiple copies of data mismatch, it makes the...
Question 3Assertion. Data redundancy may lead to many problems.Reason. In RDBMS, data redundancy is 100% removed.
Question 6Assertion. There can be multiple options for choosing a primary key in a data table.Reason. All attribute combinations inside a data table...
Question 7Assertion. All types of keys contain unique values for each row.Reason. A foreign-key attribute of a table is the primary key of another...
Question 8Assertion. The foreign-keys of tables are used to establish relationships with other tables and must be handled carefully.Reason....
Question 1Summarize the major differences between a relation and a traditional file.
Question 3What is data redundancy ? How does it impact a database ?
Question 6(i)Define primary key.
Question 6(ii)Define foreign key.
Question 7What is MySQL ? What are its functions and features ?
Question 8What is the role of database server in database management system ? Give the key features of MySQL.
Question 10How are SQL commands classified ?
Question 11What functions should be performed by ideal DDL ?
Question 12Differentiate between DDL and DML commands.
Question 13Name some commands used to assign/revoke privileges from database users.
Question 14Name some table maintenance commands.
Question 15What is TCL part of SQL ?
Question 2What are views ? How are they useful ?
Question 3(ii)Define candidate key.
Question 6What do you understand by the terms Primary Key and Degree of a relation in relational database ?
Question 10Which of the following is not a legal sub-language of SQL ?DDLQALDMLTCL
Question 4Common attribute of two tables is called a foreign key.