Given the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL. S2: Given the table R(a,b,c) where a and b together form the primary key, the following is a valid table definition. CREATE TABLE S ( ConstINTEGER, d INTEGER, e INTEGER, PRIMARY KEY (d), FOREIGN KEY (a) references R) Which one of the following statements is CORRECT?

Multi Choice Type QuestionGiven the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL. S2: Given the table R(a,b,c) where a and b together form the primary key, the following is a valid table definition. CREATE TABLE S ( ConstINTEGER, d INTEGER, e INTEGER, PRIMARY KEY (d), FOREIGN KEY (a) references R) Which one of the following statements is CORRECT?Marks : 1Negative Marks : 0Answer hereS1 is TRUE and S2 is FALSE.Both S1 and S2 are TRUE.S1 is FALSE and S2 is TRUE.Both S1 and S2 are FALSE.

Which of the following statements is FALSE about keys in a relationaldatabase?a. Any candidate key is eligible to become a primary key.b. A primary key uniquely identifies the tuples in a relation.c. A candidate key that is not a primary key is a foreign key.d. A foreign key is an attribute whose value is derived from the primarykey of another relation

Which of the statement(S) are incorrect w.r.t primary key in SQL. A. A primary key can contain duplicate values to ensure redundancy.B. A primary key can be a composite key, consisting of multiple columns.C. A primary key must be an auto-increment field.D. A primary key cannot be null

The relationship between the two relations is created using __________Candidate keyPrimary keyForeign keyCheck constraintQ2 of 6outlined_flagWhich of the following statement(s) is/are FALSE about Primary key? [ Choose any TWO]Primary key uniquely identifies a rowThere can be more than one Primary key for a tablePrimary key column(s) in one table can be referenced by Foreign key column(s) in another tableColumns with string(Char/Varchar2) data types cannot be made Primary key because they are largeQ3 of 6outlined_flagThe entity Customer(CustId,CustName,Email,ContactNo,Adress) has three Candidate keys: a) CustId b) Email and c) ContactNo. Suggest the best Primary key for this entity.CustIdEmailContactNoCustId and ContactNoQ4 of 6outlined_flag  Identify the Candidate key for the RechargePlan table. OperatorPlansOperator, RechargeTypeOperator, PlansQ5 of 6outlined_flag Identify the Primary key for the RechargePayment table.OperatorPlansRechargeIdOperator, PlansQ6 of 6outlined_flag Identify the Foreign key for the table RechargePayment. OperatorPlansRechargeId, OperatorOperator, PlansSubmitContentsDetailsDatabase Management System Part - 1Course | Beginner63h 50minfoexpand_morefolderIntroductiontimelapse2h 33mweb_assetDatabase Systems Overviewdone_all20massignment_turned_inQuiz - Database Introductiondone_all6mweb_assetTypes of Database Systemsdone_all10mweb_assetRelational Modeldone_all15massignment_turned_inQuiz - Functions and Relational Modeldone_all10mweb_assetData Integrity and Constraintsdone_all40massignment_turned_inQuiz - Data Integrity12mweb_assetExercises - Data Integrity and Constraintsdone_all40mchevron_rightfolderER Diagram1h 36mchevron_rightfolderPractice Problems : Introduction To DBMS1h 30mchevron_rightfolderVideos on introduction to DBMS, keys and ER diagrams33m 16schevron_rightfolderAssignment : DBMS Basics1h 23mchevron_rightfolderNormalization4h 37mchevron_rightfolderSQL Basics1h 38mchevron_rightfolderPractice Problems : Normalization, SQL Basics30mchevron_rightfolderAssignment : SQL Basics, Normalization, Functional Dependency1h 15mchevron_rightfolderDDL Statements3h 56mchevron_rightfolderDML Statements Part 12h 53mchevron_rightfolderPractice Problems : DDL, DML - 11hchevron_rightfolderVideos on DDL and DML Statements2h 59mchevron_rightfolderAssignments : DDL Statements, Insert Statement and Select clause4h 25mchevron_rightfolderDML Statements Part 21h 34mchevron_rightfolderAdditional Concepts2h 10mchevron_rightfolderSorting Data50mchevron_rightfolderPractice Problems : DML - 2, Functions, Sorting45mchevron_rightfolderVideos on Updating Data, Deleting Data ,SQL Functions, Case , Order By1h 10mchevron_rightfolderAssignments : DML, Function and Sorting3h 2mchevron_rightfolderGroup By Having2h 1mchevron_rightfolderCombining Data51mchevron_rightfolderCartesian Product and Inner Join1h 16mchevron_rightfolderPractice Problems : Grouping, Join - 11h 30mchevron_rightfolderVideos on Group By Having, Combining Data, Cartesian Product and Inner Join1h 17mchevron_rightfolderAssignments : Grouping Data, Combining Data, Cartesian Product and Inner Join2h 34mchevron_rightfolderSelf Join and Outer Join3h 38mchevron_rightfolderModular Query Writing50mchevron_rightfolderPractice Problems : Joins - 21h 45mchevron_rightfolderVideos on Self Join and Outer Join33m 21schevron_rightfolderAssignments : Self Join, Outer Join2h 29mchevron_rightfolderSelf Study on Joins1hchevron_rightfolderDatabase Playground2hassessmentAssessmentDB11h 45mPowered by Infosys Wingspan

Create Table SALE(        SaleID integer,        SaleDate date,        Tax decimal,        Total decimal);Create Table ITEM(        ItemID integer,        Name char(30),        Cost decimal,        Price decimal);Create Table SALE_ITEM(        SaleID integer,        SaleItemID integer);Considering the SQL create statements; assume that SALE, SALE_ITEM and ITEM tables were created without Primary Keys and Foreign Keys.  Which of the following SQL statements gives an error?Question 12Select one:a.Alter Table SALE Add Primary Key (SaleID);Alter Table SALE_ITEM Add Primary Key (SaleID);Alter Table SALE Add Foreign Key (SaleID) References SALE_ITEM;b.Alter Table SALE Add Primary Key (SaleID);Alter Table SALE_ITEM Add Primary Key (SaleID, SaleItemID);Alter Table SALE_ITEM Add Unique (SaleID);Alter Table SALE Add Foreign Key (SaleID) References SALE_ITEM (SaleID);c.Alter Table SALE Add Primary Key (SaleID);Alter Table SALE_ITEM Add Primary Key (SaleID, SaleItemID);Alter Table SALE_ITEM Add Unique (SaleID);Alter Table ITEM Add Primary Key (ItemID);Alter Table SALE Add Foreign Key (SaleID) References SALE_ITEM;d.Alter Table ITEM Add Primary Key (ItemID);Alter Table SALE_ITEM Add Primary Key (SaleID, SaleItemID);Alter Table SALE_ITEM Add Unique (SaleID);Alter Table ITEM Add Foreign Key (ItemID) References SALE_ITEM;