Relational Databases

Question 1Assertion. A database is centrally stored data and a DBMS is a system to manage the database.Reason. DBMS is a database management system,...

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 4Assertion. A primary key is used to uniquely identify the rows in a data table.Reason. A primary key is a field or attribute which has a...

Question 5Assertion. A data table can have only one primary key.Reason. In a data table, there can be only one attribute/field containing unique...

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 9Assertion. A unique value that identifies each row uniquely is the primary key.Reason. Only one column can be made the primary key.

Question 1Summarize the major differences between a relation and a traditional file.

Question 2(i)Define database.

Question 2(ii)Define SQL.

Question 2(iii)Define view.

Question 3What is data redundancy ? How does it impact a database ?

Question 4What is data inconsistency ? How does it impact a database ?

Question 5(i)Define tuple.

Question 5(ii)Define attribute.

Question 5(iii)Define domain.

Question 5(iv)Define degree.

Question 5(v)Define cardinality.

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 9What is the use of SQL in 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 1(a)Define relation.

Question 1(b)Define tuple.

Question 1(c)Define attribute.

Question 1(d)Define domain.

Question 1(e)Define primary key.

Question 1(f)Define candidate key.

Question 1(g)Define cartsian product.

Question 1(h)Define degree.

Question 2What are views ? How are they useful ?

Question 3(i)Define primary key.

Question 3(ii)Define candidate key.

Question 3(iii)Define alternate key.

Question 3(iv)Define foreign key.

Question 4What is an Alternate Key ?

Question 5What is the importance of a Primary Key in a table ? Explain with a suitable example.

Question 6What do you understand by the terms Primary Key and Degree of a relation in relational database ?

Question 7What do you understand by the terms Candidate Key and Cardinality of a relation in relational database ?

Question 1Collection of logically related data tables is called a database.

Question 2The duplication of data is known as data redundancy.

Question 3A pool of values wherefrom a field can draw values, is called domain.

Question 4A row in a relation is called a tuple.

Question 5A column in a relation is called an attribute.

Question 6The number of attributes in a relation is called its degree.

Question 7The number of tuples in a relation is called its cardinality.

Question 8An attribute that can uniquely identify each tuple in a relation is called primary key.

Question 9A non-key attribute derived from the primary key of some other relation is called foreign key.

Question 10A data model wherein data is arranged in tabular forms called relations and linked through common attributes of relations, is called...

Question 1A relational database consists of a collection ofTablesFieldsRecordsKeys

Question 2A relational database consists of a collection ofTuplesAttributesRelationsKeys

Question 3A(n) ............... in a table represents a logical relationship among a set of values.AttributeKeyTupleEntry

Question 4The term ............... is used to refer to a record in a table.AttributeTupleFieldInstance

Question 5The term ............... is used to refer to a field in a table.AttributeTupleRowInstance

Question 6A ............... is a property of the entire relation, which ensures through its value that each tuple is unique in a...

Question 7Which of the following attributes cannot be considered as a choice for primary key ?IdLicense numberDept_idStreet

Question 8An attribute in a relation is a foreign key if it is the ............... key in any other relation.CandidatePrimarySuperSub

Question 9Consider the table with structure as :Student(ID, name, dept name, tot_cred) In the above table, which attribute will form the primary key...

Question 10Which of the following is not a legal sub-language of SQL ?DDLQALDMLTCL

Question 1A table in a relational database can store empty values.

Question 2A relation is a table having unordered non-atomic values.

Question 3A primary key can store empty values in it.

Question 4Common attribute of two tables is called a foreign key.

Question 5A common attribute of two tables is called a foreign key if it is the primary in one table.

Question 6Part of SQL which creates and defines tables and other database objects, is called DDL.

Question 7Part of SQL which manipulates data in tables, is called TCL.

Question 8Part of SQL which accesses and manipulates data in tables, is called DML.

Question 9Part of SQL which controls transactions, is called TCL.

Question 10MySQL is the name of a customised query language used by Oracle.