TCS ASPIRE | Database management system quiz/question | latest 2014
# 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. All of the above B. Find and remove fields that are related to the only part of the key. C. Assign the new table with the key i.e. part of the whole composite key. D. Group the removed items in the another table.
Answer Key: A
# Question 2 of 10 10.0 Points In which of the following ways does “TRUNCATE TABLE” differ from “DELETE”? A. All of the above B. The number of deleted rows are not returned. C. Truncate operations are not transaction safe. D. Truncate operations drop and re-create the table which is much faster than deleting rows. one by one.
Answer Key: A
# 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
# 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. None of the above B. REMOVE TABLE < TABLE NAME> C. DROP TABLE < TABLE NAME > D. DELETE TABLE < TABLE NAME > 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 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. 7sct 5a9 B. None of the above C. 7 sct D. Change 7 sct 5a9 Answer Key: D
# Question 10 of 10 10.0 Points What is joining a Table to itself called? A. Self Join B. Outer join C. Left inner join D. Inner join Answer Key: A