TCS PA PLSQL MCQs

 TCS PA PLSQL MCQs

1.What type of join in below statement..?
Select column name(s) from table1 T1 , table2 T2 Where condition;
1.self join
 


2.Plsql question with global variables and local variables
1.95,95
2.95,195
3.195,195
4.Error


3.How many types of indices are present in sqlserver ?
1.2
2.1
3.3
4.4


4.Sql command-
1.select age where age between 30 and 100
2.select age where age(30,100)
3.select age where age>=30 and age<=100


5.Which is the invalid command in sql?
 
Fetch
 


6.To increase the size of a column in SQL.. ?
ALTER TABLE table_name MODIFY column_name datatype(new_size)


7.One question from plsqlwas” the upward to lower flow in a loop is ....?”
 
reverse
 


8.SQL Query used to search details based on the 1st character in a column..?
Select * from table_namewhere name like ‘(char)%’;


9.What is purpose of type and rowtype..?
 TYPE provides datatype of a variable and ROWTYPE provides record type that represents a entire row of a table or view or columns selected in the cursor


10.Procedure can be called in how many ways

using execute command
calling the name of the procedure from other plsqlblock


11.What will happen(pl/sqlcode)Exit when (c1%rowcount>5) or (c1%notfound)

 terminate loop when row count is greater than 5 or when no data found


12.Which are the types of conditional statements in plsql? 

IF THEN END IFIF THEN ELSE END IFIF THEN ELSIF END IF
 

 

14.We cannot use where clause with truncate.
1.True
 


15.What is the output of the below query?
select left('Welcome to PLSQL',3)
1.wel
 


16.Sql command to drop the column in specific table.. ?

alter table tablenamedrop column columnname

17.What type of join in below statement..?

Select column_name(s) from table1 T1 , table2 T2

 Where condition;

Ans: self join

18. Plsql question with global variables and local 

variables

 Ans :Error

19. How many types of indices are present in sql server ?

Ans: 2

20.SQL Query used to search details based on the 

1st character in a column..?

Ans : Select * from table_name where name like 

‘(char)%’;

21 sql command to drop the column in specific table.. ?

Ans : alter table tablename drop column columnname

22. Sql command correct syntax to check between the 

values .. ?

Ans : BETWEEN val1 and val2

23.  which is the invalid command in sql ?

Ans :Fetch

24. what is the exit condition … plsql ?

Ans : exit when SQL%NOTFOUND