RDBMS Test Your Self, Interview Questions

1. ___________ Provide table security by restricting access to a predetermined set of rows or columns of a table.

Ans: VIEWS

2.Create or replace view emp-view as (select empno, ename, job, deptno from emp where job='manager') with read only

 Ans: None of the above

3.Given that a button can generate an action event which listener would you expect to have to implement, in a class, which would handle this event?

Ans: Action listener

4.You are writing a db application to run on Ur DBMS.you don't want your users to be able to view the underlying table structures. At the same time u want to allow certain update operators.

Ans: View

5.How many passes are advisable for test execution planning.

Ans:3

6.what are the values of variable trouble and *pt after the following. Program fragment has been executed?

double trouble =13.3

Double *pt;

Pt=&trouble;

*Pt=9.9;

Ans: trouble is 9.9,*pt is 9.9

7.People avoid listening because

Ans: They want to avoid ideas, which contradict their own.

8.which of the following can be done in WR.

Ans: All of the above.

9.Is the following code legal?

Struct a

{

Int x;

struct a b;

}

Ans: Yes

10.Which properly procedure is used to assign a value to a properly in a class.

Ans: SET

11.Testing Metrics should be collected during all stages of a test?

Ans: True

12.Assembly test is known as

Ans:Integration test

13. ----------- Is built in function is used to extract a sub string from a main string in VB script.

Ans: Mid.

14.Employee_id number primary key

      First_name varchar2 (25)

      last_name varchar2(25)

      hire_date date

Which of the following update statement is valid

Ans: update employees set first_name = 'JOHN' AND last_name='SMITH' where employee_id =180;

15._______ is not a type of TSL function

Ans: Customization

16.Difference between assembly testing and component testing

Ans: Assembly testing test integration of the component whereas component testing validate all component are correctly built and function as per the design.

17.String testing is __________

Ans: Assembly testing

18.public class test

    {

       Static int total=10;

       Public static void main  (String args [])

            {

               new test ();

             }

Public test ()

Ans: The value 10 is one of the…….

19. _______ Verifies that deliverable is completed inline with the project standards.

   Ans: Quality Assurance Standards

20.which of the following are true.

   Ans:All the above options are true.

21.Wat are the Primary inputs required to build and test application components.

     1.class design

     2.component design

     3.physical data model

     4.system test condition

     5.test plan

Ans: 1,2,3, &5

22.printf can be implemented

  1.output

   2.variable length argument list

   3.None

Ans: Variable length argument list

23._____ is not a part of AO

Ans: Desktop management

24.public double Square Root (double value) throws

AirthmeticException

{

            if (value >=0) return Math.sqrt( value);

            else

                        throw new ArithmeticException();

}

public double func(int x)

{

            double y = (double)x;

            try{

                        y=SquareRoot(y);

            }

            catch(ArithmeticException e)

            {

                        y=0;

            }

            finally

            {

                        y--;     }

       return y;

}

Referring to the above, what value is returned when method func(4) is invoked.

• -2
• -1
• 0
• 1

25.The approach where the writer takes many things into consideration before writing is

 Ans: Systematic

26.At what point of time User acceptance criteria identified

 Ans:Requirement phase

27."How are u feeling today?" is a

 Ans:Open ended question

28. Given that a button can generate an action event which listener would you expect to have to implement, in a class, which would handle this event?

Ans: Action listener 

29.An address of an entity

  Ans: ptr=&j;

30.Two cases would u use an outer join

  Ans:(1) the tables being join have both matched and unmatched data

         (2) The columns being  have NULL values

31.define the high level view of all major aspects tat could affect its success and    structures the direction and shape of the test effort.

  Ans: Test objective

32.Integrated with test director.

 Ans: (1) Vuser scripts from a test director project may be added to controllers script list.

          (2)Results of a scenario can be saved to a test director   test subject.

33.unique departments

ANS: Select count (DISTINCT dept-id) from employees where last_name='SMITH'

34.main ()

{

int i=4,j=7;

j=j|| I++ && printf("youcan");

printf("%d%d", I ,j);

}

 

Ans: 4 1

35.__________ is responsible in executing component test scripts.

Ans: Developer.

36.Firo-b dimensions control is

Ans:Options 2 & 4.

37.great tester not having the following

Ans: Strong understanding of pgming concepts.

38.Stage containment

Ans: all of the above.

39.Validate component test plan

Ans: all of the above

40. One c question

Ans: Minus 2

----------

Topic : Oracle:: Sub Topic : SQL

Question 1        Which of the following choices identifies a GROUP BY query that will result in an error from oracle when run against the database ?

            select deptno , job , sum(sal) from emp group by job , deptno ;

            select sum(sal) , deptno , job from emp group by job ,deptno ;

            select deptno , job , sum(sal ) from emp group by job;

            select deptno , sum(sal) , job from group by job , deptno

           

           

            Topic : Oracle:: Sub Topic : SQL

Question 2        _______________ is a join that allows selection of all rows from the first table and matching rows from the second table

            Inner join

            Outer join

            Equi join

            None of above

           

  

Question 3        You added a PHONE-NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Identify from the following, the most appropriate command for the above.

            MERGE

            INSERT

            UPDATE

            ADD

            ENTER

            You cannot enter the phone number for the existing employee records

            Topic : ATS Process:: Sub Topic : AO

Question 4        Speed to market is not one of the reasons why AO is done

            True.

            False

           

            Topic : ATS Process:: Sub Topic : AO

Question 5        AO work for a US client carried out in India, Chennai & US can be termed as?

            No shore

            Offshore

            Poly shore

            Onshore

           

           

            Topic : ATS Process:: Sub Topic : POP

Question 6        Which function is primarily responsible to manage the service interfaces between the custome and the unit?

            Provide Service

            Unit management

            Service Management

            Finance & reporting

            Performance measurement

           

            Topic : ATS Process:: Sub Topic : POP

Question 7        When a programmer doesn't respond or is not reachable to receive a severity 1 ticket information from help desk, who is the immediate point of escalation?

            CEO

            CFO

            Team Lead

            Project manager

           

           

            Topic : ATS Process:: Sub Topic : ATSEPQ

Question 8        The term used to identify problems existing in the product being developed before proceeding to the following stage:

            Verification

            Validation

            Stage Containment

            Testing

           

           

            Topic : ATS Process:: Sub Topic : ATSEPQ

Question 9        Few of the following deliverables that must be prepared for the Product Test during the application analysis :

            Test Approach

            Test Conditions and Expected Results

            Test Cycle Control Sheet

            All of the above

           

           

            Topic : ATS Process:: Sub Topic : ATSTesting

Question 10      When you discover that something is wrong with your car, you take it to the mechanic and give him or her your best description of the problem – just as when a defect is discovered during testing, the tester documents it for the fix-it team. Which is the test performed by the mechanic?

            Product Test

            Performance Test

            Regression Test

            Assembly Test

           

           

            Topic : ATS Process:: Sub Topic : ATSTesting

Question 11      Tests that require human judgment to assess the correctness of the result, or extensive on-going human intervention to keep the test running are also called as

            manual test

            Unit Test

            Load Test

            Monkey Test

           

           

            None of them

           

           

Question 15      What will be the content of array variable table after executing the following code? Int table[][]=new int[3][3]; for(int i=0; i<3; i++) for(int j=0; j<3; j++) if(j == i) table[i][j] = 1; else table[i][j] = 0;

            0

            100010001

            100110111

            1010100

           

            In any classpath directory

            In directory mypackage under the current working directory

           

           

            Topic : Programming Techniques:: Sub Topic : PT

Question 28      "My salary was increased by 15%!" Select the statement which will EXACTLY reproduce the line of text above.

            printf("\"My salary was increased by 15/%\!\"\n");

            printf("My salary was increased by 15%!\n");

            printf("My salary was increased by 15'%'!\n");

            printf("\"My salary was increased by 15%%!\"\n");

            printf("\"My salary was increased by 15'%'!\"\n");

           

            Topic : Programming Techniques:: Sub Topic : Pointers

Question 29      #include <stdio.h> char *myFunc(char *abc); int main() { char *x, *y; x = "HELLO"; y = myFunc (x); printf ("y = %s \n", y); return 0; } char* myFunc (char *ptr) { ptr += 3; return (ptr); } What will print when the sample code above is executed?

            y = HELLO

            y = ELLO

            y = LLO

            y = LO

            x = O

           

            Topic : Programming Techniques:: Sub Topic : PT

Question 30      #include<stdio.h> void main() { printf("%d",11 ^ 5); } What does the operation shown above produce?

            1

            6

            8

            14

            15

           

            Topic : Programming Techniques:: Sub Topic : BestPractices

Question 31      Identify the proper sequence of Program development Life Cycle

            Testing, build, Requirement analysis, Design, Deploy

            Testing, Deploy, build, Requirement analysis, Design

            Requirement analysis, Design, Build, Testing, Deploy

            Design, Requirement analysis, Build, Testing, Deploy

           

           

            Topic : Programming Techniques:: Sub Topic : BestPractices

Question 32      State TRUE/FALSE: Every static variable is constructed only once during the lifetime of the program.

            FALSE

            TRUE

           

           

           

           

            Topic : Programming Techniques:: Sub Topic : BestPractices

Question 33      Identify the wrong declarations from the following as per variable declarations Best Practices:

            int line; /* length of a segment */

            int point,width[];

            char Desig, Appraisals[3];

            char name[];

           

           

            Topic : Programming Techniques:: Sub Topic : BestPractices

Question 34      Identify the wrong function name from the following as per Naming Function Best Practices:

            PrintReport()

            checkorderinfo()

            ShowResult()

            CheckOut()

           

           

            Topic : Oracle:: Sub Topic : RDBMS

Question 35      Choose the most appropriate from the following: A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functional dependent on primary key.

            1NF

            2NF

            3NF

            None of the Above

           

           

            Topic : Oracle:: Sub Topic : RDBMS

Question 36      Select the most appropriate Wildcard used for Single Character pattern Matching

            _ %

            & *

            ! ^

            None of the Above

           

           

            Topic : Oracle:: Sub Topic : SQL

Question 37      which clause allows the deletion of child records if the parent records are deleted

            on delete cascade

            drop constraint constraint_name cascade

            cascade constraints

            None of the above

           

           

            Topic : Oracle:: Sub Topic : SQL

Question 38      consider the following sql statement select qty from SALES where rate in(300,800); which of the following operators can be used to substitute the 'IN' operator

            AND

            BETWEEN..AND

            LIKE

            >=

            OR

            <=

            Topic : Oracle:: Sub Topic : SQL

Question 39      Evaluate this SQL Statement: SELECT e.employee_id, (0.15 *salary) + (0.5 * e.commission_pct ) + (s.sales_amount) * (.35 * e.bonus )) AS CALC_VALUE FROM employees e, sales s Where e.employee_id = s.emp_id; What will happen if we remove the parentheses from the calculation?

            The Value displayed in the CALC_VALUE column will be lower.

            The value displayed in the CALC_VALUE column will be higher.

            There will be no difference in the value displayed in the CALC_VALUE column.

            An error will be reported.

            None

           

            Topic : Programming Techniques:: Sub Topic : PT

Question 40      A self explanatory information assisting the reader to read the program and providing him with the required technical details is known as __________

            Comment

            Algorithm

            Code

            None of the above

           

           
----------

1)validation is done by performing?
4 options are there answer is 1,2,4

2)which command is used to assign property in class
SET

3)some programming question
answer is 1----1 ,1-----2

3)some true false question on gui regression
answer is true

4)some java code is given we have to find its legal or not
ans is not legal

5)in sql what is the order of commands
ans is where,groupby,having

6)some programe in java we need to fing output
ans is 10.-2,-2

7)system testing is also known as
ans is product testing

8)string testing is also known as
ans is application integration testing

9)who is responsible for building and testing applicaton component
ans is test lead

10)which of these is invalid variable name
ans is a ,c and e

11)gui regression test does not enable u to compare state
ans true

12)what is name of file in integration testing and bla bla
ans is cross reference specification

13)in what testing we do logical study
ans is white box testing

14)some code is given
ans is if (x<=1) return 1

15)ommiting where clause from delete stmt has following effect
ans is delete stmt will remoove all records from table

16)how do u find out where correlation is required
ans is a&b

17)some true false ques on due deligance
ans is true

18)which integrity ensures thatevery value of foreign key is mached with value of primary key
ans is referencial integrity

19)command to display msg in vb script
ans is mssg("hello")

20)which is constraining factor of ao
ans is all of above

21)main objective of frame work development is reusabolity of component
ans is true

22)a program with cases is given switch
ans is a is two


--

        QUESTIONS-



1.       Key form of communication........... System Investigation Request

2.         Metrics are critical to successful testing........... T/F

3.         Export/Import........... RSTXDBUG

4.         sql query : select q.qt, r.rate from sales q, listst r where
q.serialid=r.serialid group by q.qtty; sales table – 7 rows, list
table – 12 rows, removal of which clause will result in output with 64
rows

5.         testing framework will consist of........... test stages

6.         lock - enque, deque.

7.       Invalid for flow logic of a dialog program
both 1 & 2

8.         output configuration -NACE

9.       variable assigned that is assigned value for loop pass within Do- END loop

10.     SUPERSCRIPTS AND SUBSCRIPTS ARE USED IN - CHARACTER FORMATS

11.   skip generates  --- ........... one line  

12.   what is true about test approach.

13.   Accenture Delivery Suite -------- ........... Accenture Delivery Methods  

13.   SMART GOAL........... achievable

14.join not used........... cluster table

15.data objects........... all

16. authority........... check

17.system integration request........... from project to program

18.flow logic........... all of the above

19.select count (distinct dept_id) from employees where last name = smith
header ........... ans

20.which interface setting of the search help will determine field
sequence............ LPOS

21.    SEPG........... software engg. Process group

22.    ABAP Processor........... work process

23.    class builder - SE24 (Ans)

24.    CAB

25.    Detailed orientation ........... good tester

26.    sql query project details........... subs

27.    form can have only 1 main window........... true

28.    most important interface design

29.    assembly test........... application team

30.    scripts to print forms..

31.    medium level defects mentioned in SIR mustt be fixed........... true

32.    not true about order by clause........... multiple clauses

33.    SAP application are developed using........... ABAP

34.    conversion exit of a data variable is attached........... Domain

35.    It is possible to assign more than 1 job to a process in a
project........... True