Database Concepts Quiz

Database concepts Quiz1

Part 1 of 1 - 100.0 Points Question 1 of 10 10.0 Points In which of the following ways does “TRUNCATE TABLE” differ from “DELETE”?  A. Truncate operations drop and re-create the table which is much faster than deleting rows. one by one. B. All the options C. The number of deleted rows are not returned. D. Truncate operations are not transaction safe. Answer Key: B Question 2 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 3 of 10 10.0 Points What is joining a Table to itself called? A. Inner join B. Outer join C. Left inner join D. Self Join Answer Key: D Question 4 of 10 10.0 Points Which of the following options list the steps to convert a table to its second normal form? A. Find and remove fields that are related to the only part of the key. B. Group the removed items in the another table. C. All the options D. Assign the new table with the key i.e. part of the whole composite key. Answer Key: C 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 Integrity constraint can be dropped if the rule that it enforces is not longer TRUE or if the constraint is no longer needed. Answer Key: True Question 7 of 10 10.0 Points What would be the output of following command. SELECT TRANSLATE('1sct523','123', '7a9') “Change” FROM DUAL;  A. Change 7 sct 5a9 B. 7 sct C. 7sct 5a9 D. None of the options Answer Key: A Question 8 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. DELETE TABLE < TABLE NAME > C. DROP TABLE < TABLE NAME > D. None of the options Answer Key: C Question 9 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. Answer Key: False Feedback: False ( all above tasks can not be performed ) Question 10 of 10 10.0 Points SELECT TRIM(' Hansel ' ) “Trim both sides” FROM DUAL What would be the output of the above command? A. Trim both sides Hansel  B. None of the options C. Hansel  D. Trim both sides  Answer Key: A