TCS iON ProCert - PL/SQL and Unix Technologies
Registration Closes
Assessment Date
About TCS iON ProCert - PL/SQL and Unix Technologies
Possess 2 to 10 years of experience
Age group of 22 to 37 years
Minimum 50% in 10th, 12th and Graduation
Cannot be currently employed with TCS
Part Time/Distance Education/Correspondence qualifications will not be eligible
Not have more than 2 years break in career/academics
Assessment Details
Minutes Questions Marks
Proctored Remote Assessment covering key areas in PL/SQL and Unix Technologies, conducted online
Minutes Questions Marks
Scenario based questions to test application of applied PL/SQL and Unix Technologies knowledge
Database Schema
Database Architecture
Data Manipulation Language (DML) Commands
Transaction and Control SQL (Structured Query Language)
Database Utilities
Database Maintenance
Advanced Database Concepts
Unix and Shell Programming
Please click here for detailed sub-topics under each topic.
Assessment Topics
+ Expand All - Collapse AllDatabase Schema (Number of Questions - 15)
- Data types
- Tables and views
- Constraints
- Normalization
- Temporary tables
Database Architecture (Number of Questions - 5)
- File system
- Buffer, Tablespace
- Database Partitioning Feature (DPF)
- Interfaces
Data Manipulation Language (DML) Commands (Number of Questions - 15)
- Select/insert/update/delete
- Sorting, Aggregate, Group By
- Subqueries
- Joins and ranks
Transaction and Control SQL (Structured Query Language) (Number of Questions - 15)
- Triggers
- Indexes
- Cursors
- Stored procedures
- Functions
- Packages
- Exception handling
Database Utilities (Number of Questions - 5)
- Load
- Injection
- Statistics
- Query plan
Database Maintenance (Number of Questions - 5)
- Reorganization
- Compression
- Partitioning
- Restructuring
- Performance tuning
- Version upgrades
Advanced Database Concepts (Number of Questions - 5)
- Multiple Query Transactions (MQT)
- Modification Detection Code (MDC)
- Columnar storage
- Blob/Clob/XML
Unix and Shell Programming (Number of Questions - 10)
- Files and directories
- Variables
- Flow control and loops
- Filters and regular expressions
- Commands (find, bc, pipes, and more)
Advantages of TCS iON ProCert - PL/SQL and Unix Technologies
- Get Recognised - Gain recognition for your PL/SQL and Unix Technologies experience and expertise
- Get an Edge - Stand out among your peers by enhancing your industry credibility
- Get Noticed - Get career opportunities in PL/SQL and Unix Technologies with top recruiters
Key Features
Available Assessment Centres
Andhra Pradesh
- Chirala
- Guntur
- Kakinada
- Kurnool
- Nellore
- Rajahmundry
- Tirupathi
- Vijayawada
- Visakhapatnam
- Vizianagaram
Assam
- Dibrugarh
- Guwahati
- Jorhat
- Silchar
- Tezpur
Bihar
- Arrah
- Darbhanga
- Muzaffarpur
- Patna
Chandigarh
- Chandigarh
Chhattisgarh
- Bhilai Nagar
- Bilaspur
- Raipur
Delhi
- New Delhi
Goa
- Panaji
Gujarat
- Ahmedabad
- Anand
- Gandhinagar
- Mehsana
- Rajkot
- Surat
- Vadodara
Haryana
- Ambala
- Gurugram
- Hisar
- Karnal
- Kurukshetra
Himachal Pradesh
- Hamirpur
Jammu and Kashmir
- Jammu
- Samba
Jharkhand
- Bokaro Steel City
- Dhanbad
- Hazaribagh
- Jamshedpur
- Ranchi
Karnataka
- Bengaluru
- Hubballi (Hubli)
- Kalaburagi (Gulbarga)
- Mangaluru (Mangalore)
- Mysuru (Mysore)
- Shivamogga (Shimoga)
- Udupi
Kerala
- Kannur
- Kozhikode
- Thiruvananthapuram
- Thrissur
Madhya Pradesh
- Bhopal
- Gwalior
- Indore
- Jabalpur
- Sagar
- Satna
- Ujjain
Maharashtra
- Amravati
- Aurangabad
- Jalgaon
- Kolhapur
- Mumbai
- Nagpur
- Nanded
- Nashik
- Navi Mumbai
- Pune
Meghalaya
- Shillong
Mizoram
- Aizawl
Nagaland
- Kohima
Odisha
- Balasore
- Berhampur-Ganjam
- Bhubaneswar
- Cuttack
- Dhenkanal
- Rourkela
- Sambalpur
Punjab
- Amritsar
- Bhatinda
- Jalandhar
- Ludhiana
- Mohali
- Patiala
Rajasthan
- Ajmer
- Bikaner
- Jaipur
- Jodhpur
- Kota
- Sikar
- Udaipur
Tamil Nadu
- Chennai
- Coimbatore
- Madurai
- Salem
- Tiruchirappalli
- Tirunelveli
Telangana
- Hyderabad
- Karimnagar
- Warangal
Uttar Pradesh
- Agra
- Aligarh
- Allahabad
- Bareilly
- Ghaziabad
- Gorakhpur
- Greater Noida
- Jhansi
- Kanpur
- Lucknow
- Meerut
- Moradabad
- Muzaffarnagar
- Noida
- Varanasi
Uttarakhand
- Dehradun
- Haldwani
- Roorkee
West Bengal
- Asansol
- Hooghly
- Kolkata
- Siliguri
Candidate Testimonials
Have a Question?
If you want to know more about our products, pricing or anything else