Answere of DBMS

Question 1 of 10 10.0 Points
Which of the following options list the steps to convert a table to its second normal form?

A. Group the removed items in the another table.

...
B. Find and remove fields that are related to the only part of the key.

C. All of the above

D. Assign the new table with the key i.e. part of the whole composite key.

Answer Key: C
Question 2 of 10 10.0 Points
In which of the following ways does “TRUNCATE TABLE” differ from “DELETE”?

A. The number of deleted rows are not returned.

B. Truncate operations drop and re-create the table which is much faster than deleting rows. one by one.

C. Truncate operations are not transaction safe.

D. All of the above

Answer Key: D
Question 3 of 10 10.0 Points
Following tasks can be performed when using the ALTER TABLE clause:

1.Change the name of the table
2.Change the name of the column
3.Decrease the size of a column if table data exists.

True
False

Answer Key: False
Feedback: False ( all above tasks can not be performed )
Question 4 of 10 10.0 Points
Sometimes tables within particular database become obsolete and ought to be discarded. Which of the following commands would you use for the same?

A. REMOVE TABLE < TABLE NAME>

B. DROP TABLE < TABLE NAME >

C. DELETE TABLE < TABLE NAME >

D. None of the above

Answer Key: B
Question 5 of 10 10.0 Points
A foreign key must have a corresponding primary key or unique key value in the master table.

True
False

Answer Key: True
Question 6 of 10 10.0 Points
NULL value is equivalent to a value of Zero if the data type is number

True
False

Answer Key: False
Question 7 of 10 10.0 Points
Integrity constraint can be dropped if the rule that it enforces is not longer TRUE or if the constraint is no longer needed.

True
False

Answer Key: True
Question 8 of 10 10.0 Points
SELECT TRIM(' Hansel ' ) “Trim both sides” FROM DUAL

What would be the output of the above command?

A. None of the above

B. Trim both sides

C. Hansel

D. Trim both sides
Hansel

Answer Key: D
Question 9 of 10 10.0 Points
What would be the output of following command.

SELECT TRANSLATE('1sct523','123', '7a9') “Change” FROM DUAL;

A. None of the above

B. 7 sct

C. Change
7 sct 5a9

D. 7sct 5a9

Answer Key: C
Question 10 of 10 10.0 Points
What is joining a Table to itself called?

A. Left inner join

B. Outer join

C. Inner join

D. Self Join

Answer Key: D