TCS SQL Final Assessment, TCS Xplore 2022

Below are the answers to the TCS Xplore SQL final assessment. There is a total of 20 questions in the final assessment of SQL. Answers to SQL Final Quiz is highlighted in yellow colour.

Also Read: TCS Xplore Java Quiz Answers(All Modules) 2022

Also Read: TCS Xplore Digital Awareness Quiz Answers 2022

Question 1. Select The suitable option from below to create an index on the "job" column in the emp table?

Answer: Create Index emp_ind on emp(job);

Question 2. Which of the below constraints will make sure to allow, only the values of a column (in a master) to the respective column of a child table?

Answer: foreign key

Questions 3. Select a suitable option for Normalization importance on a database?

Answer: To avoid redundancy

Applying changes to the table data without affecting the other attributes

To fetch the perfect and exact data, required

Data would not lost

Question 4. Which of the following is true with respect to referential integrity?

Answer: Every foreign key value must match a primary key value in the associated table i.e. parent table

Question 5. What is the grant statement to grant statement to grant select, insert, delete privileges on table: Emp to user : TestUser? Emp is the table NameTestUser is the User Name

Answer: Grant select, insert, delete on Emp to TestUser

Question 6. Which is below statement is used to remove access or privileges on the database object to users?

Answer: Revoke

Question 7. Which of the following is the type of constraint?

Answer: CHECK, DEFAULT, PRIMARY KEY, UNIQUE KEY

Assume that the respective data values/attributes referred in the options were exists in the table. By referring to the above table structure, for which of the below questions, are we would require to apply the concept of SubQuery?

Answer: Query to get employee, whose designation is same of swarna's designation

Query to get employee details belonging to dept of RAJA

Questions 9. The formal classification describing the level of database normalization in a data model are called Normal Forms Select True or False

Answer: True

Questions 10. From the table below EmpId | EmpName | ProjId | No.OfHoursWorked.................

Answer: Table 1 EmpId | EmpNameTable : ProjectId | ProjectNameTable3: Empid | ProjId | No.OfHourWorked

Question 11. Which SQL statement returns a numeric value?

Answer: SELECT sysdate-hire_date from EMP;

Question 12. From the table below EmpId | EmpName | ProjId | No.OfHoursWorked.................

Answer: EmpId and ProjId together

Question 13. Refer to the table below EmpId | EmpName | ProjId | ............................... by referring to the above table, Select a suitable query that gets all employees whose project is the same as a project of 'd'?

Answer: SELECT * FROM EMP WHERE ProjId = (SELECT ProjId FROM EMP WHERE EMPNAME ="d')

Question 14. table below EmpId | EmpName | ProjId | >1 a p1 >> 2 p2>>>3 c p3......... by referring the above table, Select a suitable query which would letch EMPID EMPNAME ProName for Each employee?

Answer: SELECT EMPID.EMPNAME.B.ProjId. B.ProjName From EMP A Proj B where A.ProjId = B.ProjId

Question 15. The DDL command is?

Answer: ALTER, DROP, CREATE

Question 16. We can use Transactional control statements in the Database Triggers? Select True or False

Answer: False

Question 17. Type of SQL statement are?

Answer: DDL, DML, TCL

Question 18. Select a suitable option for SubQuery?

Answer: Inner query executes first and then based on the output of inner query, the outer query executes

Question 19. A column with reference to a record in a table should not have multiple values. Which of the normal form, Talks about the above statement?

Answer: First

Question 20. DCL Commands are used to enforce database security in multiple user environments. Select True or False?

Answer: True

TCS SQL Final Assessment, TCS Xplore 2022