TCS PA RiO MCQs

TCS PA RiO MCQs

 

1.. Rio weekly celebrate because ?

Aimed to improve System support
 

2.Operation Flow of information in Rio.. ?

1.Primary -> Secondary -> KT

2.Secondary -> Primary -> KT

3.KT -> SECONDARY -> PRIMARY

3.Transition phase ?

1.Primary -> Secondary -> KT

2.Secondary -> Primary -> KT

3.KT -> SECONDARY -> PRIMARY
 

4.In which normalization from transitive dependency.. ?

3nf
 

5.How to print server output on terminal ?

1.set dbmsoutput on

2.set output on

3.set serveroutput on  
 

6.Difference between primary key and foreign key ?

1.primary key is only one and foreign key may be one or more

2.primary key  is unique and foreign key can be duplicate

3.primary key can't null and foreign key can be null
 

7.Insert into category values(2, 'polo', 1200.99);

1) successfully inserted

2) sqlerror

3) syntax error of insert

8.Truncated command can't be used with where clause .. ?

1.True

2.False

9.Rio

1.discipline in execution+pursuit of excellence+customer experience

2.discipline in execution+pursuit of excellence+rigor

3.discipline in execution+integrity+customer experience ​
 

10.The role of production support engineer requires

1.only technical knowledge

2.only domain knowledge required

3.right combination of technical and inter personnel skills

4.only interpersonal skills​

11.RiO stands for?

Rigor in Operations
 

12.Name the pledge taken by support engineers to ensure they adhere to project discipline-

1.tcs pledge

2.operations pledge

3.account pledge

4.project oath
 

13.Students as a group associated with multiple faculty members and faculty members are associated with multiple students. The relationship?

1.one to one

2.many to one

3.many to many

4.one to many
 

14.Tick the correct one

1.foreign key can be null but primary key cannot be null

2.unlike primary key foreign key contains dublicatevalue

3.one primary key can have multiple foreign keys
 

15.What are the various keywords used along with the ALTER statements?

1.ADD,DROP,SELECT,MODIFY

2.DROP,RENAME,ADD,MODIFY

3.DROP,DELETE,ADD,MODIFY
 

16.Which of the below option ensure that the value of COLUMN(named as budget) is non-negative?

1.alter(budget>=0)

2.alter(budget<0)

3.check(budget<0)

4.check(budget>=0)
 

17.DBMS and RDBMS are one and same?

1.false

2.true
 

18.Rio is an initiative that is aimed at improving our production support operations
 

19.RiO Day Celebrated on

24th July as TCS operations day(available 24x7) and whole week is known as RiO week to spread awareness about RiO