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.inner join
3.outer join
4.Left outer 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?
1.Revoke
2.Join
3.Fetch
4.Like


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 ....?”
1.inverse
2.reverse
3.backward
4.none


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
1.automatically called
2.called using select statement
3.using execute command
4.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?
1. IF THEN END IFIF THEN ELSE END IFIF THEN ELSEIF END IF
2.IF THEN END IFIF THEN ELSE END IFIF THEN ELSIF END IF
3.IF THEN END IFIF THEN ELSE ENDIF THEN ELSEIF END
4.IF THEN END IFIF THEN ELSE ENDIF THEN ELSIF END

 

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


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


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