Time left 0:19:23Question 1Not yet answeredMarked out of 1.00Flag questionTipsQuestion textWhich of the following options is not correct?Select one:a.alter table emp drop column column_name;b.alter table emp modify name varchar(30);c.alter table emp add column_name varchar(25);d.alter table emp drop column_name;Clear my choiceQuestion 2Not yet answeredMarked out of 1.00Flag questionTipsQuestion textHow would you add a foreign key constraint on the dept_no column in the EMP table, referring to the id column in the DEPT table?Select one:a.Use the ALTER TABLE command with the MODIFY clause on the EMP table.b.Use the ALTER TABLE command with the MODIFY clause on the DEPT table.c.Use the ALTER TABLE command with the ADD clause on the EMP table.d.This task cannot be accomplished.e.Use the ALTER TABLE command with the MODIFY clause on the EMP table.
Question
Time left 0:19:23Question 1Not yet answeredMarked out of 1.00Flag questionTipsQuestion textWhich of the following options is not correct?Select one:a.alter table emp drop column column_name;b.alter table emp modify name varchar(30);c.alter table emp add column_name varchar(25);d.alter table emp drop column_name;Clear my choiceQuestion 2Not yet answeredMarked out of 1.00Flag questionTipsQuestion textHow would you add a foreign key constraint on the dept_no column in the EMP table, referring to the id column in the DEPT table?Select one:a.Use the ALTER TABLE command with the MODIFY clause on the EMP table.b.Use the ALTER TABLE command with the MODIFY clause on the DEPT table.c.Use the ALTER TABLE command with the ADD clause on the EMP table.d.This task cannot be accomplished.e.Use the ALTER TABLE command with the MODIFY clause on the EMP table.
Solution
Sure, I can help with that.
For Question 1, the incorrect option is: b. alter table emp modify name varchar(30);
The correct syntax to modify a column in a table is: ALTER TABLE table_name MODIFY column_name column_type;
So the correct command should be: alter table emp modify column_name varchar(30);
For Question 2, the correct answer is: c. Use the ALTER TABLE command with the ADD clause on the EMP table.
The syntax to add a foreign key constraint is: ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column1, column2, ... column_n) REFERENCES parent_table (column1, column2, ... column_n);
So the correct command should be: ALTER TABLE EMP ADD CONSTRAINT fk_deptno FOREIGN KEY (dept_no) REFERENCES DEPT(id);
Similar Questions
Time left 0:15:27Question 11Answer savedMarked out of 1.00Flag questionQuestion textIf A=1’b1,B=2’b01,C=2’b00 y={4{A},2{B},C} equalsa.Noneb.10’b1111010100c. 8’b11110100d.9’b111101010Clear my choiceQuestion 12Not yet answeredMarked out of 1.00Flag questionQuestion textIn the given code snippet, statement 2 will executed at a.25b.15c.0d.30Clear my choiceQuestion 13Not yet answeredMarked out of 1.00Flag questionQuestion textIf A= 4b`001x and B= 4b`1011, then result of A+B will bea.110x b.1111c.xxxxd.1100Clear my choiceQuestion 14Not yet answeredMarked out of 1.00Flag questionQuestion textIn Verilog `d1234 is aa.32 bit decimal number b.It is invalid notationc.4 bit decimal number d.16 bit decimal number
Time left 0:06:01Question 7Not yet answeredMarked out of 2.50Flag questionTipsQuestion textWrite as a single logarithm:log2+log3+log4𝑙𝑜𝑔2+𝑙𝑜𝑔3+𝑙𝑜𝑔4 Select one:A.log9𝑙𝑜𝑔9B.log10𝑙𝑜𝑔10C.log12𝑙𝑜𝑔12D.log24𝑙𝑜𝑔24CLEAR MY CHOICEQuestion 8Not yet answeredMarked out of 2.50Flag questionTipsQuestion textWrite as a single logarithm:log(43)+log3+log7log(43)+log3+log7Select one:A.log11𝑙𝑜𝑔11B.log11.3𝑙𝑜𝑔11.3C.log12𝑙𝑜𝑔12D.log28
Time left 0:47:21Question 11Not yet answeredMarked out of 1Flag questionTipsQuestion textQuestionFacility IndexDiscrimination Index120.80.4250.50.3320.70.6400.40.3Which one of the questions, based on the indices, is BEST suited to be included in a revised version of the test?Question 11Answera.25b.40c.32d.12Clear my choiceQuestion 12Not yet answeredMarked out of 1Flag questionTipsQuestion textThe scatter diagram shows scores of 10 students on Mathematics and Science. The correlation between Mathematics and Science can be described asQuestion 12Answera.strongly positiveb.weak positivec.strongly negatived.weak negativeClear my choiceQuestion 13Not yet answeredMarked out of 1Flag questionTipsQuestion textMs. George obtained a reliability index of -.85 for her two English tests. Which of the following is a possible cause for the reliability index? i. High scores were obtained for the first test and high scores for the second test. ii. High scores were obtained for the first test and low scores for the second test. iii. Low scores were obtained for the first test and low scores for the second test.Question 13Answera.ii onlyb.i onlyc.i, ii and iiid.i and ii onlyClear my choiceQuestion 14Not yet answeredMarked out of 1Flag questionTipsQuestion textAfter comparing two sets of scores, a correlation coefficient of zero was obtained. This indicates that Question 14Answera.the variables are independent of each other b.there is a strong positive relationship between the two variables.c. there is a strong negative relationship between the two variables.d.there is no linear relationship between the two variables
Which of the following options is not correct?Select one:a.alter table emp drop column column_name;b.alter table emp modify name varchar(30);c.alter table emp add column_name varchar(25);d.alter table emp drop column_name;
Time left 0:09:09Question 5Not yet answeredMarked out of 2.50Flag questionTipsQuestion textDifferentiatef(x)=x+sinx𝑓(𝑥)=𝑥+sin𝑥.Select one:A.1−cosx1−cos𝑥B.1−sinx1−sin𝑥C.1+cosx1+cos𝑥D.sinx
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.