Database Concepts Quiz

1. Which of following represent logical storage of data?
Option :
a. Table
b. View
c. None.
d. Index
Ans: b

2. Which SQL statement is used to extract data from a database?
option:
a. SELECT
b. EXTRACT
c. OPEN
d. GET
Ans: a

3. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Options:
a. SELECT * FROM Persons SORT 'FirstName' DESC
b. SELECT * FROM Persons SORT BY 'FirstName' DESC
c. SELECT * FROM Persons ORDER BY FirstName DESC
d. None of the above
e. SELECT * FROM Persons ORDER FirstName DESC

Ans: c

4. With SQL, how can you return the number of records in the "Persons" table?
Options:
a. SELECT COUNT(*) FROM Persons
b. SELECT COLUMNS(*) FROM Persons
c. None of the above
d. SELECT COLUMNS() FROM Persons
e. SELECT COUNT() FROM Persons
Ans : a
5. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
Options:
a. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
b. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
c. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
d. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
Ans: d

Communication Quiz (VOCABULARY) in TCS ASPIRE

Each project will have a set of predefined deliverableswhich have to be submitted according to timelines. If thetimelines are not met, the net result is a slippage. Alldeliverablesshould be stored in a document repository. Resources are deployed in projects but the actual work will start when they are allocated specific tasks. Resources should anticipatechanges to the requirements and should have proper response to the enquiries made by the customer. The tasks should be carried out as per the priority and issues should be tracked as per the severityattached to the issue. There should be proper mentoring of the junior associates and the outputs of the associates should be consistent in quality standards and should containreliableinformation. There should be proper monitoring of progress of the deliverables and each deliverable has to go through a strict review process. Defects are logged during the review and various metrices are collected as part of the review process. During the course of project delivery, the project manager should ensure proper utilization of resources and there should be a collaborative effort amongst all team members. A good PM should be a good strategistand must be a/an mentorto all associates. All team members are expected to achieve thetargets set for them. Based on the targets, there will be a/anappraisal at the end of each year.