CS101 532 CS201 225 CS301 232 CS302 174 CS304 192 CS401 224 CS402 258 CS403 228 CS408 113 CS411 121 CS502 249 CS504 268 CS601 679 CS604 381 CS605 261 CS607 184 CS609 230 CS610 300 CS614 100 CS703 65
Code Question Option A Option B Option C Option D Answer
CS403 Dml Commands Are Used For: Inserting Data Into Databases Creating Databases Destroying Databases Creating Db Objects A
CS403 Dml Does Not Used To Add New Rows To Tables Retrieve Row From Tables Modify The Rows Of Tables Alter A Table Definition D
CS403 Each Table Must Have A Key Primary Secondary Logical Foreign A
CS403 Emp_Dob Holds Employee Birth Dates. Which Format Will Display The Month In Number Format Such As 01 Or 11? Month: Format([Emp_Dob] M) Month: Format([Emp_Dob] Mm) Month: Format([Emp_Dob] Mmm) Month: Format([Emp_Dob] Mmmm) B
CS403 Given Are The Relations Of Student And Instructor Which Relational Algebra Operation Could Have Been Applied On The Pair Of Relations Student And Instructor To Obtain The Above Data? Instructor – Student Student n Instructor Instructor ÷ Student Student – Instructor B
CS403 Grant Belong To Which Types Of Sql Command Classification Dml Ddl Dcl Dql C
CS403 Grant Belongs To Which Type Of Sql Commands Classification Dml Ddl Dcl Dql C
CS403 Grant Is A __________ Command Dcl Dml Ddl None Of The Above A
CS403 Grant Select Update(Designation) On Employee To Amali Hiruni With Grant Option; What Does This Sql Statement Do? Grant Permission To Amali Only To Retrieve Data From Employee Table And Grant Permission To Hiruni Only To Update The Designation From Employee Table Grant Permission To Hiruni In Order To Grant Select And Update Permission To Amali Grant Permission To Amali & Hiruni To Update Designation Of Employees In The Employee Table Grant Permission To Amali And Hiruni To Update All Data Except Designation In Employee Table C
CS403 How Many Clustered Index(Es) Do Each Database Table Have? 2 3 5 1 D
CS403 Identify The Basic Part(S) Of A Select Statement? Select From Both Select And From Distinct C
CS403 Identify The Constraint That Limits The Values That Can Be Placed In A Column Not Null Check Foreign Key Unique A
CS403 Identify The Correct Statement With Respect To Normalization Normalization Is A Formal Technique That Can Be Used Only At The Starting Phase Of The Database Design Normalization Can Be Used As A Top-Down Standalone Database Design Technique The Process Of Normalization Through Decomposition Must Achieve The Lossless Join Property At Any Cost Whereas The Dependency Reservation Property Is Sometimes Sacrificed The Process Of Normalization Through Decomposition Must Achieve The Dependency Reservation Property At Any Cost Whereas The Lossless Join Property Is Sometimes Sacrificed B
CS403 Identify The Correct Statement With Respect To Normalization. Normalization Is A Formal Technique That Can Be Used Only At The Starting Phase Of The Database Design. Normalization Can Be Used As A Top-Down Standalone Database Design Technique. The Process Of Normalization Through Decomposition Must Achieve The Lossless Join Property At Any Cost Whereas The Dependency Reservation Property Is Sometimes Sacrificed. The Process Of Normalization Through Decomposition Must Achieve The Dependency Reservation Property At Any Cost Whereas The Lossless Join Property Is Sometimes Sacrificed. D
CS403 Identify The Factor Which Enforces A Relation In 3Nf? Every Non-Key Attribute Is Fully Functionally Dependent On Primary Key Every Non-Key Attribute Is Partially Dependent On Super Key The Domain Of Attribute Must Include Only Atomic Values Every Non-Key Attribute Is Non-Transitively Dependent On Primary Key D
CS403 Identify The Incorrect Statement Among The Given An Entity May Be An Object With A Physical Existence Like A Car A House Or An Employee One Cannot Consider Something Which Has Conceptual Existence Like A Course In A Degree Program As An Entity Age Can Be Considered As A Single Value Attribute Of A Person An Entity Type Describes The Schema Or Intension For A Set Of Entities Which Share The Same Structure B
CS403 Identify The Language Which Is Used To Specify Database Schema Dcl Dml Ddl Non Of The Above D
CS403 Identify The Operation Which Is Not One Of The Parts Of The Five Basic Set Operations In Relational Algebra? Join Union Cartesian Product Set Difference A
CS403 In “One To Many” Cardinality One Instance Of A Relation Is Mapped With Many Instances Of Second Entity Type One Instance Of Second Entity Type Primary Key Of 2 Relations None Of Above A
CS403 In “One To One Relationship” One Instance Of First Entity Type Is Mapped With Two Instances Of Second Entity Type True False A