TCS ASPIRE | Database management system quiz/question | latest 2018 - 2019

# 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