AsCEnD Machine Learning

Machine Learning Assessment

Q1. 100 articles need to divide based on content like sports, Business Entertainment Which ML Model is

Answer: Clustering

Q2. Target Variable also called as in Machine Learning?


Answer: All are correct

Q3. How do you handle missing or corrupted data in a dataset?

Answer: Replace missing values with mean/median/mode

Q4. Identify which of the following is/are preprocessing steps?

Answer: All are correct

Q5. Which of the following is Machine Learning Type?

Answer: Both

Q6. Which of the following approach is supervised Learning?

Answer: All Are Correct

Q7. Clustering approach is example for which type of learning?

Answer: Unsupervised Learning

Q8. A feature G1 can take certain value A, B, C, D, E & F and represents grade of students from a University Which of the following statement is true in following case?

Answer: Feature G1 is an example of ordinal variable

Q9. Please identify what is the purpose of below code?
>>>from sklearn.preprocessing import Imputer >>>imp = Imputer(missing values=0, strategy='mean', axis=0) >>>imp fit_transform(X_train)

Answer: Code replacing Missing values in dataset with Mean

Q10. Which of the following is a good test dataset characteristic?

Answer: All Are Correct

Q11. What is the input to the Machine Learning Model?

Answer: Data and Output

Q12. What is the purpose of performing cross-validation 2

Answer: All Are Connected

Q13. Machine Learning is subset of?

Answer: Artificial Intelligence

Q14. What is Machine Learning?

Answer: All are correct

Q15. Identify Outlier in below data?
5,7,10,13,15,18,99,9,8.

Answer: 99

AsCEnD Mongo DB

Mongo DB Fundamentals Assessment

Q1. Which of the following are popular columnar databases?

Answer: All are correct

Q2. Collection and a document in MongoDB is equivalent to which of the SL concepts respectively

Answer: Table and Row

Q3. is the command in mongodb that is equivalent of SQL's truncate

Answer: db.col.remove()

Q4. What is the name of default storage engine in MongoDB?

Answer: MMAPV1

Q5. The following statement is True or False?

NoSQL database is not viewed as a replacement to RDBMS but Rather, a complementary addition to RDBMS and SQL.

Answer: FALSE

Q6. What does the following query do when performed on the posts collection?

db.posts.update({_id:1),($Set:{Author:Tom"}})

Answer: Both B & C

Q7. _________ is the method used to limit the records in mongoDB.

Answer: Limit()

Q8. Objectid is a 12-byte BSON type in which the last 3 bytes represent

Answer: The machine identifier

Q9. MongoDB is a leading NoSQL classified as a document-oriented database State True or False?

Answer: TRUE

Q10. ________ is the method used to display results in a formatted way

Answer: Preety()

Q11. Which of the following is equilant opeartor on NoSQL for SQL SELECT operator?

Answer: $out

Q12. You want to return maximum 10 matching documents that will return with only the id name and address fields. Which of the following queries will you use?

Answer: db.users.find({age: {$gt:18}}, {name:1, address:1}).limit(10)

Q13. Which of the following are NOSQL Traits?

Answer: All are correct

Q14. Which of the following are correct classification of NoSQL databases?

Answer: All are correct

Q15. Which among the following is the way to access the different documents in the result set?

Answer: Sort

AsCEnD Advanced DotNet

DotNet Advanced Concepts Assessment

Q1. Number of threads that exists for each of the processes that occurs in the program

Answer: Atleast 1

Q2. Which of the following statement is correct?

Answer: Anonymous types are class types that derive directly from object.

Q3. We can create nested anonymous type

Answer: TRUE

Q4. Choose the namespace which supports multithreading program

Answer: System Threading

Q5. What is the correct statement about lambda expression?

Answer: The return type of lambda expression can be neglected in some cases

Q6. Which of these methods of Thread class is used to Suspend a thread for a period of time?

Answer: sleep()

Q7. Select the type of multitasking methods that exist

Answer: Process based and thread based

Q8. Choose the correct statement about process-based multitasking

Answer: Both

Q9. What types of Objects can you query using LINQ?

Answer: All of the above

Q10. LINQ is ____________.

Answer: Language Integrated Query

Q11. Which of the following supports LINQ queries?

Answer: All of the above

Q12. What LINQ expressions are used to shape results in a query

Answer: Group & Select

Q13. Correct syntax for declaring anonymous type

Answer: var Emp=new {ID=106,Name="Priya"};

Q14. Which LINQ keyword is used to categorize results in a query?

Answer: group

Game of Skills - SQL Warriors

SQL Warriors

Q1. As part of New ways of learning' Initiative. TCS engages candidates through Digital technologies, Hackathons and Biz Play

Answer: YES

Q2. You have missed the survey to provide location and date for proctored assessment. You would like to attend the upcoming assessment in the loan centre which is near to your home. You can attend the assessment if you have a copy of your offer letter.

Answer: NO

Q3. Back Ground check (BGC) is not applicable for all new joinees.

Answer: NO

Q4. You are allowed to take proctored assessments until you receive joining letter

Answer: YES

Q5. During proctored assessment, you noticed that your reference number in the allocated system is not right but name matches. It is ok to continue the exam as long as your name matches.

Answer: NO

Q6. If you clear proctored assessment with Boy and above, you will get readiness and competency Incentives

Answer: YES

Q7. Both, Readiness & Competency Incentive are recoverable from the Employee, the associate resigns & leaves service within 12 months

Answer: YES

Q8. Your friend and you got the TCS offer letter on the same day. Your friend has access to Xplore courses. She is really enjoying the courses and scaling up her knowledge. You have not yet accepted TCS offer letter, but would like to access xplore courses. Will it be possible?

Answer: NO

Q9. Is it mandatory to have PAN card before joining TCS?

Answer: YES

Q10. Your friend got offer from other organisation and he accepted it. He is y curious to know about TCS xplore program. He asked your credentials to check the courses. There is no harm in sharing login credentials as he is your best friend.

Answer: NO

TCS Xplore Hackathon Java - Hackerrank SQL

Unit - Hackerrank Activities - SQL

Q1. Employee Count in Each Department(Department wise)

Write the SQL query to display the name of the department along with the count of employees working in it.

Solution:
select Departments.deptName,COUNT(Employees.eDeptId) From departments LEFT Join Employees on Departments.deptId=Employees.eDeptId Group By Departments.deptId,Departments.deptName Order by count(Employees.eDeptId) Desc, departments.deptName;

Q2. Display Department Details

Write the SQL query to print the department id and name of the respective Department for all the departments which are located in Ground Floor

Solution:
select Dept_Id,Dept_Name from Department where Dept_Location='Ground Floor';

Q3.Display non-Programmer Department name

Write the SQL query to print the names of the departments which does not have any Programmers.

Solution:
select distinct Dept_name from Departments,Employees where Dept_ID=Emp_Dept_Id and Dept_name not in (select distinct Dept_name from Departments,Employees where Dept_id=Emp_Dept_Id and Emp_Skill like'Programmer');