41 solutions available
Question 1Assertion (A): In hierarchical model, searching for a record is a time-consuming task.Reasoning (R): Hierarchical model owns to the...
Question 3Assertion (A): A database is the largest component for holding and storing data and may contain several tables.Reasoning (R): Each table...
Question 4Assertion (A): Referential integrity is a constraint that defines rules of holding data in parent and child table.Reasoning (R):...
Question 5Assertion (A): The number of attributes or columns in a relation is called the degree of the relation.Reasoning (R): The number of tuples...
Question 6Assertion (A): A foreign key is an attribute whose value is derived from the primary key of another relation.Reasoning (R): A foreign key...
Question 7Assertion (A): Order by clause is used to sort the records of a table in ascending or descending order.Reasoning (R): For sorting in...
Question 9Assertion (A): The HAVING clause is used with GROUP BY clause and aggregate functions.Reasoning (R): WHERE clause specifies the condition...
Question 11Assertion (A): Cartesian product of two sets (A and B) is defined as the set of all possible ordered pairs denoted by (A + B).Reasoning...
Question 13Which of the following types of table constraints will prevent the entry of duplicate rows?UniqueDistinctPrimary KeyNULL
Question 15Which of the following commands will delete the table from MYSQL database?DELETE TABLEDROP TABLEREMOVE TABLEALTER TABLE
Question 16Which function is used to display the total number of records from a table in a database?Sum(*)Total(*)Count(*)Return(*)
Question 17With SQL, how do you select all the records from a table named "Persons", where the value of the column "FirstName" ends with an...
Question 2Write some characteristics of RDBMS.
Question 5What is SQL? What are different categories of commands available in SQL?
Question 7Differentiate between DDL and DML commands.
Question 9An organization wants to create two tables EMP & DEPENDENT to maintain the following details about its employees and their...
Question 11Differentiate between char and varchar data types.
Question 15What is the significance of GROUP BY clause in an SQL query?
Question 16What is the difference between WHERE and HAVING clause in SQL select command?
Question 17Write SQL queries to perform the following based on the table PRODUCT having fields as (prod_id, prod_name, quantity, unit_rate, price,...
Question 18(i)Define database.
Question 18(ii)Define data inconsistency.
Question 18(iii)Define primary key.
Question 18(iv)Define candidate key.
Question 18(v)Define foreign key.
Question 19Differentiate between Primary key and Unique constraints.
Question 20Consider the following EMP and DEPT tables:Table:...
Question 21Write SQL commands for (i) to (vi) and write output for (vii) on the basis of PRODUCTS relation given below:Table:...
Question 22Write SQL commands for (i) to (vi) on the basis of relations given below:Table:...
Question 23What are DDL and DML?
Question 24Differentiate between primary key and candidate key in a relation.
Question 25What do you understand by the terms Cardinality and Degree of a relation in relational database?
Question 26Differentiate between DDL and DML. Mention the two commands for each category.
Question 27Write SQL Commands for (i) to (v) and write the outputs for (vi) to (viii) on the basis of the following table:Table:...
Question 28Write SQL Commands/output for the following on the basis of the given table GRADUATE:Table:...
Question 29(a)What is the difference between Candidate key and Alternate key?
Question 29(b)What is the degree and cardinality of a table having 10 rows and 5 columns?
Question 29(c)For the given table, do as directed:Table: STUDENTColumnNameData typesizeConstraintROLLNOInteger4Primary KeySNAMEVarchar25Not...
Question 30Write SQL queries based on the following tables:Table: PRODUCTP_IDProductNameManufacturerPriceDiscountTP01Talcum PowderLAK40NULLFW05Face...
Question 31Answer the questions based on the table given below:Table:...
Question 32A department store MyStore is considering to maintain their inventory using SQL to store the data. As a database administrator, Abhay has...