Accenture Assessment Technology Fundamentals 2022

Accenture Assessment Technology Fundamentals Assessment (TFA)

  1. Consider the following Java Code (Assume that Employee is a valid Java class)
    With respect to the code, how many object/objects will be available for garbage collection after Line-1? Choose the most appropriate option
  1. Ans- 2
  2. Choose the most appropriate option

  1. Ans – Compile time error Main.java:21: error: doWork(int) in Main cannot implement doWork(int) in A void doWork(int s) ^ attempting to assign weaker access privileges; was public 1 error Main.java:21: error: doWork(int) in Main cannot implement doWork(int) in A void doWork(int s) ^ attempting to assign weaker access privileges; was public 1 error
  1. Refer to the below code and predict the output

  1. Ans –
    Not equal! 10
  2. What is the output expected on the execution of the following code?

  1. Ans – 30
  2. Consider the table Employee(empId,jobBand)
    What is the correct DML statement to update the job band of all employees to NULL?
    ANS –
    UPDATE TABLE employee SET jobBand is NULL;
    UPDATE employee SET jobBand = NULL;
    UPDATE TABLE employee SET jobBand = NULL;
    UPDATE employee SET jobBand is NULL;
  3. Consider the table Employee(empId,jobBand)
    What is the correct SQL statement where all unique job band from employee table?
    Ans –
    select jobBand DISTINCT from employee;
    select DISTINCT jobBand,empid from employee;
    select DISTINCT(jobBand) from employee; // gave right answer as well
    select DISTINCT jobBand from employee;
  4. Consider table Account(accountId,balance) Identify the SQL queries which gives the same result
    Ans –
    SELECT * FROM Account WHERE balance>1000 and balance<5000; SELECT * FROM Account WHERE balance>=1000 OR balance<=5000; SELECT * FROM Account WHERE balance between 1000 and 5000; SELECT * FROM Account WHERE balance>=1000 AND balance<=5000;
  5. Refer the incomplete HTML Code given below

  1. Assume abc.html is existing and a valid HTML page. Identify the appropriate option to be placed at Line 1 so that values entered in the text boxes are not appended to URL while submitting to abc.html.
    Ans –
    method =” GET”
    method = “POST”
    submit = “GET”
    submit =” POST”
  2. What would be the output of the following Java Script

  1. Ans –
    number object
    int object
    number undefined
    int undefined
  2. Which of the following is not a part of SRS document
    Ans –
    Functional Requirement
    Non-Functional Requirements
    Implementation Details
    Hardware Software specifications
  3. Consider the following array (12,3,1,5,8) Tell us the number of steps that are required to sort the elements int the ascending order using insertion sort
    Ans – 3
  4. Choose the appropriate option where prototype model is used
    Ans –
    For projects where requirements are clear
    For projects where requirements are unclear
    Projects where lot of risk factors needs to be considered
    Projects with frequent changes
  5. Arrow symbols in the flowchart is used to show the sequence of steps and the relationship among them. State true or false
    Ans-
    True
    False
  6. Which command in UNIX is used for clearing the Screen?
    Ans-
    clrscr
    cls
    clear
    clearscreen
  7. What is the command to concatenate fname and lname with a space in between and display the output under the heading of “Full Name”?
    Employee(eid,fname,lname,salary)
    Ans-
    Select fname || “ “ || lname as ‘Full Name’ from employee;
    Select fname || “ “ || lname ‘Full Name’ from employee;
    Select fname & lname as ‘Full Name’ from employee;
    Select fname & ‘ ‘ & lname ‘Full Name’ from employee;
  8. Frrom the below list which files will be listed using the following command
    ls chap(^1-4)
    Ans-
    Chap4
    Chap5
    Chap6
    Chap7
  9. What is an identity of an object?
    Ans-
    Is the property that uniquely differentiates the object from other objects
    Is the id given to the object by the class
    Is the state of an object
    Is the behavior of the object
  10. Consider the following table structure and write a query to display all the employees who have and don’t have department assigned
    Emp(fname,lname,dno)
    Dept(deptid,dname)
    Ans-
    Select fname,deptid from emp e, dept d where e.dno()=d.deptid; Select fname,deptid,dname from emp e left outer join dept d on (e.dno=d.deptid); Select fname,deptid,dname from emp e, dept d where.dno = d.deptid();
    Select fname,deptid,dname from emp e full outer join dept d on (e.no=d.deptid);
  11. Refer the code and predict the output

  1. Ans-
    b A B C
    A B C
    A B C b
    B Hreeva A B C
  2. given the following code snippet: which of the following are true

  1. Ans – the output will be [7 , D, 7 ]
  2. Predict the output
    Given two files

  1. Ans – Compile time error Main.java:16: error: no1 is not public in One; cannot be accessed from outside package System.out.print(” “+o.no1); ^ Main.java:17: error: no2 has protected access in One
    System.out.print(” “+o.no2); ^ 2 errors
  2. Identify the correct CSS representation for a paragraph
    Ans-
    p{padding:25px;}
    p{padding=25px;}
    p=padding:25px;
    p: padding: 25px;
  3. Which attribute is used to reference an xml schema in an xml document
    Ans-
    xsi:schemaLocation
    xsi:Location
    xsd:schemaLocation
    xsi=schemaLocation
  4. Two modules with more dependency is known as loosely coupled modules and two modules with less dependency is known as uncoupled modules state true or false
    Ans-
    True
    False
  5. Carefully read the question and answer accordingly. To execute the result of the last executed procedure, call recursive procedures use stacks. State true or false
    Ans-
    True
    False
  6. Path is used to locate file in Unix filesystem. The types of path supported are _ and _
    Ans-
    Absolute
    Relative
    Reference
    Dynamic
  7. Predict the output
    Step 1: start the program
    Step 2: Declare a variable count and set the count as 1
    Step 3: Print the count
    Step 4: Increment the count by 1
    Step 5: Check whether count is greater than or equal to1. If yes go to step 3. If no go to step 6
    Step 6: Print the count
    Step 7: Stop
    Ans-
    1 1
    1 2
    2 1
    Loop runs indefinitely
  8. Below statement is an example of _ path in Unix
    &cd /home/course/CSE/C++
    Ans-
    Absolute
    Relative
    Reference
    Dynamic
  9. Predict the output of below command
    grep “Atul” employee.txt || echo “not found”
    Ans-
    Searches for Atul and echoes “not found”
    Searches for Atul
    Searches for Atul and displays
    Searched for Atul and echoes “not found” when not found
  10. Consider the scenario. For an insurance, customer makes a claim. The claim can be a normal or a critical claim. The insurance company confirms the claim. What diagram can be used to understand the state changes of the component triggered by events and dynamic nature?
    Ans-
    Sate chart diagram
    Sequence diagram
    Activity diagram
    Interaction diagram
  11. Predict the output

  1. Cat Meow
    Dog BOW WOW
    Dog Meow
    Cat Bow Wow

Answer is Dog Meow

  1. A team of employees is trying to analyze the root cause of the issues identified for the online Library Management. From the options identify the process that is carried out.
    Ans-
    Coding
    Testing
    Analysis
    Debugging
  2. Information hiding is achieved through which OOP principle?
    Ans-
    Abstraction
    Encapsulation
    Typing
    Hierarchy
  3. From the following options choose all the possible Exceptions for the above code
    Try{
    Int check = Integer.parseInt(“Five”);
    }
    Ans-(class cast, number format)
    ClassCastException
    IllegalStateException
    NumberFormatException
    IllegalArgumentException
    ExceptionInInitializeError
  4. Unix file system is a collection of files and directories organized in a __ manner
    Ans- hierarchical
  5. Predict the output

  1. Ans- true true
  2. Predict the output

  1. Ans-
    A 3 B
    A B
    3
    A followed by an exception
    An exception is thrown at runtime
    Exception in thread “main” java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer
  2. What is true regarding State Chart Diagram?
    Ans-
    Depicts different states of an object during lifetime
    Flow of activity
    Chart diagram of objects
    Static view of objects
  3. Predict the output
    An exception is thrown at runtime
    The code compiles and runs with no output
    CTE
  • Exception in thread “main” java.lang.ClassCastException: Tree cannot be cast to TestMain
  1. Predict the output
    Ans – 6
  2. Predict the output. Which statement can replace to allow the above code to compile and run.
    Ans –
    List> db = new ArrayList>();
    List> db = new List>();
    List db = new List(); [0, 0, 0, 0, 0, 0] [0, 1, 2, 3, 4, 5] [0, 2, 4, 6, 8, 10] [0, 3, 6, 9, 12, 15] [0, 4, 8, 12, 16, 20] [0, 5, 10, 15, 20, 25]
  3. Carefully read the question and answer accordingly. In Linear search algorithm, if an item to be searched is found in the middle of an array then it is said to be _
    Ans-
    Best case
    Worst case
    Average case
    Null case
  4. Which of the given phases consume more time during the Software life cycle
    Ans-
    Analysis
    Design
    Testing
    Maintenance
  5. If you are asked to do a modular software design, which combination of coupling and cohesion should you use for designing the software?
    Ans-
    High cohesion and high coupling
    High cohesion and low coupling
    Low cohesion and high coupling
    Low cohesion and low coupling
  6. What is the output of the following script

Ans – 20100

  1. Which jquery syntax hides all the paragraph elements
    Ans-
    $(“p”).hide();
    $(p).hide();
    $(“p”)-hide();
    (“p”).hide();
  2. Match the following
    DDL, DML, DCL, TCL
    GRANT, COMMIT, SELECT, CREATE
    Ans-
    DDL – CREATE
    DML – SELECT
    DCL – GRANT
    TCL – COMMIT
    Note: DDL (Data Definition Language) – Create, drop, alter, truncate, comment, rename DQL (Data Query Language) – SELECT DML (Data Manipulation Language) – Insert, update, delete DCL (Data Control Language) – Grant, revoke TCL (transaction Control Language) – Commit, rollback, savepoint, set transaction
  3. Which is the root element of every XSD?
    Ans-
    Schema
    Root
    Schema xsd
    Base
  4. The kernel is the core part of UNIX operating system. Choose 3 tasks achieved by Kernel from the list below
    Ans-
    Performs disk operations
    Manages I/O operations
    Performs memory and processes management
    Interfaces between user and operating system
  5. You must explicitly commit GRANT on tables. State true or false
    Ans-
    True
    False
  6. Which of the following algorithm(s) is/are said to be non-adaptive?
    Ans-
    Selection sort
    Merge sort
    Bubble sort
    Insertion sort
  7. Which of the following is more efficient in terms of memory utilization and execution speed?
    Ans-
    Recursion
    Iteration
    Sequential
    Conditional
  8. In HTML, what is the default min and max values for the input type called range?
    Ans-
    Min=0, max=100
    Min=1, max=10
    Min=0, max=10
    Min=1, max=100
  9. Root is a super user in Unix operating system and it is represented using _
    Ans-
    $
    /
    >
    ~
  10. Given
    Which of the following statement can replace // insert code here, that will compile without any errors? Choose all that apply
    Ans-
    static void check(int…checkArgs){}
    static void check(int[] checkArgs){}
    static void check(int…checkArgs,int y){}
    static void check(int checkArgs…){}
    static void check(int x,int…checkArgs){}
  11. java.util.List allows you to grow or shrink its size and provides indexed access to its elements, but whose methods are not synchronized. State True or False
    Ans-
    True
    False
  12. State true or false
    White box testers require the working knowledge of the code being tested
    Ans-
    True
    False
  13. Carefully read the question and answer accordingly. In an array, if an item to be searched is found in the last element of the array or not found in the array then it is said to be _
    Ans-
    Best case
    Worst case
    Average case
    Null case
  14. What does public String pattern() return?
    Ans-
    Returns the compiled version of boolean after matching the regular expression against the given
    Returns the compiled version of regular expression into a Pattern
    Returns the pattern’s source regular expression
    Returns the compiled version of string into the pattern
  15. What is the complexity of the given code
    Ans-
    O(nlogn)
    O(n^2)
    O(n^2logn)
    O(logn)
  16. Choose the options which are true with respect to views in SQL?
    Ans-
    View is a virtue table that does not physically exist
    Views are used for maintaining logical data independence
    View do not maintain data integrity
    View is database objects that physically exist
  17. For developing a water plant application the following statements are captured in the SRS
    i) if the water level goes below 20%, then the application should raise an alarm for immediate action
    ii) if the water level goes below 15%, then the application should automatically switch on the power button to fill in water in the tank
    Identify the issue with the requirement specified in the SRS
    Ans-
    Contradicting requirements
    No issues with the requirements
    Incomplete requirements
    Unreliable requirement
  18. Name the Unix command to perform safe shut down a Unix system
    Ans-
    Poweroff
    Shutdown
    Reboot
  19. Predict the output
    Ans-
    A few many
    A few
    Many
    Compile time error – error: no suitable method found for find(int)
  20. Predict the output
    Ans-
    6
  21. Predict the output
    Ans-
    Int 127
  22. When constructing looping statements, if the iteration condition Is not terminated, it will result in infinite loop. State True or false
    Ans-
    True
    False
  23. Predict the output
    Hi hi followed by exception
    Hi hi hi
    Hi hi
    Hi
    Hi followed by exception
  24. Select the statements that are true about Persistence
    Ans-
    Persistence is a way through which the life time of object exists even after the program terminates
    Java uses serialization for object persistence
    Persistence is a way through which the life time of object is terminated as the program terminates
    Persistence of object is done by java runtime automatically
  25. Predict the output
    Ans-
    Compile time error
    10
    18
    8
  26. Bonus calculated module was unit tested by the developer. Depending on the salary the bonus needs to be calculated. Assume if one of the salary-range is between 30000 to 40000 then the bonus should be 10%. From the given options identify the test cases for Equivalence Partitioning.
    Ans-
    25000,35000,45000
    25000,27000,29000
    42000,43000,45000
    32000,35000,39000
  27. Predict the output
    Ans-
    Bow Wow
    Roar
    Bow Wow Roar
    Compile time error
  28. Choose the statement that true about Class?
    Ans-
    Class is a dynamic component
    Class is described using attributes and methods
    Change the class to change the state of an object
    Class properties depends on object properties
  29. Which xsd correctly defines a restriction on votingage element where the value is between 18 and 130
    Ans-
  30. Given
    Public abstract Interface1 {public void method(String s);}
    Which of the following is/are correct class implementation(s)
    Ans-
    Public abstract class Class1 implements Interface{
    Public abstract void method(String s){}
    }
    Public abstract class Class1 implements Interface1{}
    Public class Class1 extends Interface1{
    Public void method(Integer i) {}
    }
    Public class Class1 implements Interface1{
    Public void method(Integer i) {}
    }
    Public class Classs1 implements Interface1{
    Public void method(String i) {}
    Public void method(Integer s) {}
    }
  31. Predict the output
    Ans-
    Watermelon Mango Banana Apple -5
  32. What is the relationship between these two Building has rooms
    Ans-
    Composition
    Aggregation
    Generalization
    Hierarchy
  33. If an element is to be retrieved from a specific location in an array, the array has to be _
    Ans-
    Traversed from the first position until the element is found
    Added in ascending order and compared with each element
    Traversed from the last position to first until the element is found
    Sorted in descending order and compared with each element.
  34. Predict the output
    Ans-
    85 Message 406 80Message
  35. In which of the given SDLC models’ rapid changes are easily incorporated
    Ans-
    V-model
    Agile model
    Prototyping model
    Waterfall model
  36. What is the lifeline in a sequence diagram?
    Ans-
    Object’s life time
    Actor’s life time
    System’s life time
    Modelling life time
  37. What are the best ways to ensure that a class implements the required behavior?
    Ans-
    Use Interface
    Method inside interface are public and abstract
    Have a strict testing
    Use encapsulation
  38. Predict the output
    How many objects eligible or GC is reached, how many objects are eligible for Garbage Collection?
    Ans – 1 (or 2)
  39. Predict the output
    Ans- An exception is thrown at runtime
  40. What are the types of Interaction Diagrams?
    Ans-
    Sequence diagram
    Collaboration diagram
    Activity diagram
    State chart diagram
  41. A Team is allocated with a new project. All their work needs to be accessed and updated in the same repository. Which of the given options would help them achieve this?
    Ans-
    Software configuration management
    Creating a common folder in the server
    Creating a common folder local
    Using IDE
  42. Predict the output?
    Ans – 2
  43. Choose the correct order in which the Oracle Server evaluate clauses
    Ans-
    Where, group by, having
    Where, having, group by
    Having, where, group by
    Group by, having, where
  44. Carefully read the question and answer accordingly
    Analysis of selection algorithm eliminates _ number of elements each time
    Ans-
    n elements
    n/2 elements
    n/4 elements
    (n/2) +n elements
  45. Predict the output
    Ans- Car Ferrari Portofino Portofino
  46. Software which controls radiation equipment for patients is best shut down, if it receives bad input for a radiation dosage. This is a best example for __
    Ans-
    Correctness
    Robustness
    Verification
    Validation
  47. Predict the output
    Ans – *c
  48. Predict the output
    Ans- Compile time error
  49. Predict the output
    Ans- 3 1
  50. Which concept ensures every change that is made to the artifact can be properly tracked and changed?
    Ans-
    Version control
    Resource planning
    Testing
    Review of artifacts
  51. Which script code produces the output as Welcome to “Javascript”
    Ans-
  1. Which is not an attribute of schema element
    Ans-
    targetnamespace
    xmlns
    elementFormDefault
    version
  2. What is the output of the following code?

Ans= 9

  1. Predict the output of the below SQL query
    SELECT DISTINCT CITY FROM CUSTOMER;
    Ans-
    Displays all cities
    Displays unique cities
    Displays distinct cities
    Query has syntax error
  2. What are the best ways to ensure that a class implements the required behavior?
    Ans-
    User interface
    Method inside interface are public and abstract
    Have a strict testing
    Use encapsulation
  3. O(nlogn) is the best-case time complexity of Bubble Sort. State True or False
    Ans-
    True
    False
  4. Predict the output of the following command
    $ who | tee userlist.txt
    Ans-
    The command displays the output on the monitor
    The command displays the output of who in the monitor and also saves the output in userlist.txt
    The command saves the output in userlist.txt
    The command displays an error message on the monitor
  5. Which of the given options perform requirement specification- based testing
    Ans-
    White box testing
    Black box testing
    Integration testing
    Glass box testing
  6. Consider the following CSS script
    Start program
    padding: 20px, 30px;
    end program
    what is the order of padding property that has two values?
    Ans-
    Top and right, left and bottom
    Right and left, top and bottom
    Top and bottom, right and left
    Right and bottom, top and left
  7. What is the command to fetch employee id, employee name and salary with 10% increase from employee?
    Employee(eid,ename,salary)
    Ans-
    Select eid, ename, (salary+salary0.1) from employee; Select eid, ename, (salary+salary10/100) from employee;
    Select eid, ename, salary10% from employee; Select eid, ename, salary10/100 from employee;
  8. UNIX is more commonly used operating system in comparison with other OS. Choose two reason from the below options in support of this statement.
    Ans-
    It is open source software
    It is highly secure
    It is user friendly
    Has good graphical user interface
  9. What attribute is used to indicate that an attribute is required for an element in the XSD
    Ans-
    use
    required
    needed
    mandatory
  10. Two tables joined using SELF JOIN are different tables with the same columns
    Ans-
    True
    False
  11. In HTML, what is the default type of an input element?
    Ans-
    submit
    text
    hidden
    reset
  12. What string datatype can be used for string that does not contain line feeds, carriage returns or tabs
    Ans-
    xs: string
    xs: name
    xs: nospace
    normalisedString
  13. Which element is used to indicate that elements defined in the xsd must appear in the same order in the xml file
    Ans-



  14. Which is the HTML5 equivalent of
    Ans-



  15. Which script displays an alert box with the required information when a button with the name msgbtn is clicked
    Ans-
  1. Which of the given options define a set of activities that transform the client needs to an effective software solution
    Ans-
    Software planning
    Software cost estimation
    Software development process
    Software resource planning
  2. order the types of cohesion from the worst cohesion to the best cohesion
    a. functional cohesion
    b. co-incidental cohesion
    c. communicational cohesion
    d. temporal cohesion
    e. procedural cohesion
    f. logical cohesion
    g. sequential cohesion
    Ans- b-f-d-e-c-g-a
  3. After the development of the online website for banking, the testers found that the application was not user friendly to differently abled people. Identify in which level of testing, the testers would have identified this issue
    Ans-
    Unit testing
    Integration testing
    System testing
    Acceptance testing
  4. In javascript, which of the following popup boxes has the cancel button? Choose one
    Ans-
    Alert box and prompt box
    Alert box and confirm box
    Confirm box and prompt box
    Alert box, prompt box and confirm box
  5. which of the following is correct if the xsd is
    Ans-
    green
    red
    green GREEN
  6. Choose a query that will display the names of colleges where the available seats are between 50 to 100 hint: inclusive of 50 and 100
    Ans-
    Select college_name from college where available_seats=50 and available_seats=100;
    Select college_name from college where available_seats 50 and available_seats 100;
    Select college_name from college where available_seats between 50 and 100;
    Select college_name from college where available_seats between 50 to 100;
  7. What will be the XSD definition for the following element 40
    Ans-



  8. Which is the correct implementation for a progress bar in HTML5
    Ans- #review



  9. Which command is used to get intermediate result in a pipeline of commands in Unix
    Ans-
    tee
    grep
    wc
    ls
  10. Carefully read the question and answer accordingly. A simple algorithm may have high complexity, whereas a complex algorithm may have lower complexity in the sense of time needed for the computations. State true or false
    Ans-
    True
    False
  11. Identify which is not an XML Naming Rule
    Ans-
    The names of elements are case- sensitive
    Names of elements must not contain spaces
    Element names can start with letters xml
    An underscore can be used to start an element name
  12. Which is not part of HTML5 API
    Ans-
    HTML Geolocation
    HTML application cache
    HTML Drag and Drop
    HTML Geography
  13. In javascript, which of the following code is valid to get an html element by name?
    Ans-
    document.getElementsByName
    document.getElementByName
    document.getElementsByNames
    document.getElementByNames
  14. Which of the following options in UNIX can be used for printing the calendar for December 2019?
    Ans-
    $ cal 12 2019
    $ cal dec 2019
    $ cal December 2019
    $ calendar 2019
  15. Kernel of UNIX operating system is written using __
    Ans-
    C
    C++
    VC++
    JAVA
  16. Predict the output
    Ans – Compile time error
  17. Which option can be used to perform a forward search of string in the vi editor
    Ans-
    /string
    /find
    ?find
    ?string
  18. Unix executables are stored in which path?
    Ans-
    /dev
    /bin
    /usr
    /tmp
  19. Which command can be used for navigating 5 pages forward in vi editor
    Ans-
    5 ctrl + f
    5 ctrl +b
    5 ctrl + a 20 times
    5 ctrl +c 20 times
  20. Carefully read the question and answer accordingly. In an array, if an item to be searched is found in the middle of an array then it is said to be _
    Ans-
    Best case
    Worst case
    Average case
    Null case
  21. Constraints ensures and __ of the data in the database
    Ans-
    Correctness
    Reliability
    Reuse
    Redundancy
  22. Predict the output
    Ans- Hello John
  23. Select the abilities given by Polymorphism to the programming language
    Ans-
    Static polymorphism is achieved by varying the input parameters
    Parent class methods can be overridden by the child class
    Static class is given as-a part of relationship
    Gives a stronger form of aggregation and composition
  24. Sam and Rose are working on the Lone Monitoring project. The head version was checked out by both Sam and Rose, both of them made their changes in the local machine. Both of them made the required changes and updated the same to the server. From the given options identify the correct option
    Ans-
    Both their changes get committed to the server
    First person change gets committed while for the second one the server notices life differences
    Both the project gets rolled back
    Second project gets overwritten by the first one
  25. The following code snippets belong to _
    Ans-
    Linear search
    Binary search
    Merge search
    Quick search
  26. With respect to the Java code given below identify the number of references and number of objects
    Ans-
    4 objects and 3 references
    3 objects and 4 references
    2 objects and 3 references
    3 objects and 3 references
  27. What is the output expected for the below code?
    Ans- Won’t compile because of Line=6, constructor can’t be static
  28. What will be the output of the following Java code?
    Ans- “Hello” will be displayed 3 times
  29. Consider the following Java code
    With respect to Employee class identify where empNo and num are stored int the memeory?
    Ans-
    empNo and num both are stored in heap
    empNo and num both are stored in stack
    empNo is stored in heap and num is stored in stack
    empNo is stored in stack and num is stored in heap
  30. What will be the output of the following code?
    Ans- default
  31. Consider the following Java code
    If you want to access empName of Employee class in all the sub classes of Employee class in the same package as well as sub classes is in some other package; which access specifier will you use?
    Ans-
    Public
    Private
    Protected
    Default
  32. Which of the following are inline HTML elements
    , ,
    Ans- and
  33. Consider the javascript code given below. What would be the print values from line 1 and line 2 on execution?
    Ans- 40 40
  34. What is the output of the program?
    Ans- 15 (20)
  35. Consider table Event(EventId, dateOfEvent) has following records
    Event id DateOfEvent

E1 12-JAN-2018
E2
E3 13-JUN-2018
Identify the appropriate SQL statement to retrieve the eventid for which there is no date available
Ans-
Select eventide from event where dateOfEvent IS NULL;
Select eventide from event where dateOfEvent = NULL;
Select eventide from event where dateOfEvent LIKE “NULL”;
Select eventide from event where dateOfEvent IS “NULL”; Consider table Department(deptId, deptname) Which of the following query is used to display the department details whose dept_name has second letter as ‘a’ and second last letter as ’e’?
Ans-
Select * from department where deptname LIKE ‘a%e’;
Select * from department where deptname LIKE ‘a%e_’;
Select * from department where deptname LIKE ‘%a%e_’;
Select * from department where deptname LIKE ‘a%e%’; Consider table Product(prodId, price) Identify the appropriate SQL statement to display all the product details whose price range is 2500 and 5000 (exclusive 2500 and 5000) choose two most appropriate option
Ans-
Select * from product where price BETWEEN 2500 and 5000;
Select * from product where price>2500 and price<5000; Select * from product where price>=2500 and price<=5000;
Select * from product where price BETWEEN 2501 and 4999; What will be the output of the following Java code?
Ans- GFT will be displayed 4 times Consider the table Item( ItemCode, ItemName, Price, Category). Which is the correct sql query to display minimum price for categories ‘A’,’C’? Choose most ppropriate option
Ans- review
Select Category, MIN(Price) from Item where Category IN (‘A’,’C’);
Select Category, MIN(Price) from Item group by category where Category IN (‘A’,’C’);
Select MIN(Price) from Item group by Price having Category IN (‘A’,’C’);
Select Category, MIN(Price) from Item where Category IN (‘A’,’C’) Group by Category; What would be the output of the SQL statement given below?
SELECT TRANSLATE(‘aAB-Cb-abc’, ‘abc-‘,’123’) from DUAL; Ans- 1ABC2*123 Consider table Account(accId, acctype, balance). Identify the appropriate SQL statement to display account details in the ascending order of balance and in the descending order of accid if the balance is same. Choose most appropriate one
Ans-
Select * from account order by balance, accId DESC;
Select * from account order by balance ASC,accId;
Select * from account order by accId DESC, balance ASC;
Select * from Account Order by accId DESC,balance; Consider table Students (sid NUMBER (3), sname VARCHAR2 (10), scontact NUMBER (10)) is already created in the database. It is required to change the data type of the column “scontact” to VARCHAR2 (15). Which of the following is Correct for the above requirement?
Note: sid column is primary key
Choose most appropriate option
Ans-
To change the data type of a column, it is important to ensure that the corresponding column is not having data for any of the record
There are no criteria to be followed. We can change the datatype of the column irrespective of the data.
Data type can be changed only for primary key column
It is not possible to change the data type of a column Identify the correct statements with respect to constraints
(i) A table can have only one FOREIGN KEY
(ii) A column with UNIQUE constraint cannot have NULL value
Ans-
Only (i)
Only (ii)
Both (i) and (ii)
Neither (i) and (ii)
157.What will be displayed in alert box while executing the below code
Ans- 100100 Refer the HTML code given below. How many cells will be displayed when the page is displayed on the browser?
Ans- 8 Assume below code present in the HEAD tag of a HTML page. Identify the appropriate HTML code to USE the style given Above
Ans- Welcome to My Homepage Welcome to My Homepage Welcome to My Homepage Welcome to My Homepage What would be the color of the text “Bengaluru” and “India” while executing the below html and css code? Assume that “Black” is the default color if there is no style applied
Ans-Bengaluru – Red, India- Green What would be the output of the java script code given below?
Ans- 12 Consider the java code given below. How many times will the Grandfather class constructor be called?
Ans- (2 times) Grandfather Father Child Grandfather Father Which of the following is TRUE about the final keyword? Final variables cannot be modified once initialized Final methods can be overridden Final classes cannot be inherited
Ans-
Only 1
Both 1 and 2
Only 2
Both 1 and 3 Which of the following statements is/are FALSE?
a. JVM is platform dependent
b. Byte code is platform dependent
Ans-
Only a is false
Both a and b are false
Only b is false
Both a and b are true What will be the output of the following Java code?
Ans- 0 What will be printed in alert box in line 1
Ans- 106 What would be the output of the javascript code given below
Ans- number Which of the following are Correct statement
a. onClick() and onFocus() are DOM events
b. In javascript a browser is represented by an implicit object called Document
c. Java script is used server-side validation
Ans-
A and c
Only a
B and c
A and b What would be the output of the java script code given below
Ans- 210 What will be the output of the following code?
Ans- hi 10 Which code should be inserted at line #4 to get the below output – 2 4 6 8 10
Ans-
for(int i=0; i<=evenNumbers.length;i++)
for(int i=0; i<evenNumbers.length-1;i++)
for(int i=0; i<evenNumbers.length;i++)
for(int i=0; i<evenNumbers.length-2;i++) Consider table Book (booId, bookName, copies) has following records
bookId bookName copied B1 JAVA 0
B2 4
B3 ORACLE 2
Identify the output of the given sql statement
SELECT COUNT (bookName) FROM Book WHERE copies>0;
Ans- 1 Consider table Employee (empId, empname, jobband). Choose the correct sql statement to retrieve all employee ids along with their job band. If job band is not assigned to an employee, then it should display ‘NA’ as job band (note: Data type of column jobBand is VARCHAR2)
Ans-
SELECT empId, NVL(jobband),’NA’ FROM Employee;
SELECT empId, NVL(jobband,NULL,’NA’) FROM Employee;
SELECT empId, NVL(NULL,’NA’,jobband) FROM Employee;
SELECT empId, NVL(jobband,’NA’) FROM Employee; Refer the following Java code
When the above code is executed how many time/times “Hello” will be printed on the console?
Ans- 1 time Consider table Students(studentId,branchId). Identify the correct sql statement to retrieve the branches which has more than 3 students.
Ans-
SELECT branched FROM Students WHERE COUNT()>3 GROUP BY branched; SELECT branched FROM Students HAVING COUNT()>3;
SELECT branched FROM Students GROUP BY studentid HAVING COUNT()>3; SELECT branchid FROM Students GROUP BY branchid HAVING COUNT()>3; With respect to the java code given below identifythe relationship that exists between class account and SavingsAccount
Ans-
Aggregation
Composition
There is no relationship between class Account and class SavingsAccount
Inheritance Which of the following statement/s is/are TRUE? Abstract method can have body Abstract class cannot be instantiated Abstract class can have constructor
Ans-
Both 1 and 2 are true
Both 2 and 3 are true
Both 1 and 3 are true
Only 2 is true Given the following declaration which expression returns the size of the array, assuming the array has been initialized?
Int[] array;
Ans-
Array[].length();
Array.length();
Array.length;
Array[].size(); What will be the output of the following java code?
Ans- Lower Case Letter Identify how many variables/object will be in stack and heap residency?
Ans-
3 in stack 1 in heap
2 in stack 2 in heap
4 in stack 0 in heap
0 in stack 4 in heap Refer to the below code and predict the output
How many String objects are created in the above code?
Ans-
2
3
1
4 Consider the Employee class given below
If you do not want all the subclasses of Employee class to override the computeSalary() method, what modification will you do for computeSalary() method?
Ans-
Make computeSalary() method as abstract
Make computeSalary() method as final
Make computeSalary() method as static Choose most appropriate option
Ans- 50 40 50 40 Identify the relationship that exists between class Student and class Faculty.
Ans-
Composition
Inheritance
No relationship
Aggregation Which is the correct CSS code to display the text “Accenture” in light grey background? Choose most appropriate option
Ans- Accenture Accenture Accenture Accenture Which of the following are the CSS selectors?
a. Element selector
b. form selector
c. class selector
Ans-
A and b
A and c
B and c
A, b and c Consider the java code given below and determine how many references are used in the java code. Assume the student is a valid java class
Ans-
2 objects and 4 references
4 objects and 2 references
2 objects and 2 references
3 objects and 4 references Predict the output of the following code
Ans- Welcome hello Predict the output
Ans-
Compilation error: illegal modifier for the constructor in type Employee What would be the output of the below java script code?
Ans- false—false You have three packages p1,p2,p3 what is the expected output of compiling and running file tester in p3 package?
Ans-
Account CurrentAccount
Compilation error at line6 in package p3 Constructor ‘Account’ is not visible
Compilation error at line3 in package p3 cannot import CurrentAccount class What will be the output of the following java code
Ans-
10000
0
Null
Compilation error at Line-1 : Implicit super constructor: Employee() is undefined Must explicitly invoke another constructor Refer to the below code and predict the output
Ans- 2 Consider table Item(itemId, category, unitprice). Identify the appropriate SQL statement to display the category and count of items in each category in the ascending order of item count. It should display the item details only if the count of item is greater than 1
Ans-
SELECT category, count(itemId) FROM item WHERE Count(itemId)>1 GROUP BY category ORDER BY COUNT (itemId);
SELECt category, count(itemId) FROM item GROUP BY category HAVING Count(itemId)>1 ORDER BY COUNT(itemId);
SELECT category,count(itemId) FROM item HAVING Count(itemId)>1 ORDER BY COUNT(itemId); Consider table Item(itemId, category, unitprice). Identify the appropriate SQL statement to display Item id, and discount in the ascending order of discount
Ans-
Select itemid, discount=unitprice0.1 from Item order by discount; Select itemId, unitprice0.1 as discount from Item order by discount;
Select itemid, discount from item order by discount;
Select itemId, unitprice*0.1 as discount from item order by itemId; You are suppose to create a table “ExamResult” with the following descripton. studentId NUMBER(4), courseid VARCHAR(10), mark NUMBER(3). There should not be duplicate combination of studentId, and courseid in any record. Identify the correct DDL statement to create ExamResult table
Ans-
CREATE TABLE ExamResult( studentId NUMBER(4), courseid VARCHAR2(10), mark NUMBER(3), CONSTRAINT er_pk PRIMARY KEY(studentId, courseid)); Kevin is a java programmer. He writes a Java code and compiles his code. What type of file Kevin will get as a result of compiling his Java code?
Ans-
Java file
.exe file
.class file
Obj file Ram is a Developer; he receives a defect list from the testing team for the code which he developed. He fixes the defects and assigns it back to the test manager/tester. What should be the status of the defect now?
Ans-
Open
Fixed
Closed
New Software Configuration Management, __ concept is used to control the changes
Ans-
Baseline
Process
Procedure
Audit Consider the given array:
E A F B D C
E A F B D C
A E F B D C
A E B F D C
A E B D F C
A E B D C F…. so on
After all consecutive iterations, the array is sorted
Which sorting technique compares the adjacent data elements and swaps each pair of elements?
Ans-
Quick sort
Bubble sort
Merge sort
Heap sort Difficult Unit test performed on the post office savings schemes module. Assume that the minimum deposit amount is Rs. 1000 and the maximum deposit amount is Rs. 10000. Based on the Boundary Value Analysis choose the correct test cases to perform this unit test.
Ans-
999,1000,10000,10001
800,6000,15000
999,1001,5000,9999,10001
1000,5000,10000 John is a poker card player in a casino. The way he arranges his cards as he picks them up one by one is a real time example of which sorting technique?
Ans-
Bubble sort
Merge sort
Insertion sort
Selection sort In many situations, it would be necessary to make a decision before arriving at a conclusion or to go on to the next step of processing. Which of the following suits the given description?
Ans-
Conditional statement
All of the options
Iterative statement
Sequential statement which of the following program has the lowest run-time complexity?
Ans-
Tower of Hanoi
Sum of n Digits
Find even or odd
Fibonacci series Manual execution of steps in an algorithm is called as __.
Ans-
Dry run
Flowchart
Quick run
Pseudocode In case of Banking application, customers are the only stakeholders State true or false
Ans-0 Dave has to store data in a nonlinear data type to represent hierarchical relationship between elements. Which data structure should he use for it?
Ans-
Linked List
Stack
Queue
Tree The names in a telephone directory were not in order. It took a long time to look for the telephone number of a particular person. Which algorithm would be the best to resolve this issue.
Ans-
Binary Search
Linear Search
Deletion Algorithm
Sorting Algorithm Roshan is a beginner in the learning path of Data Structure. Assume a singly linked list of length n is given. In a worst-case scenario, he wants to find out the maximum number of computations required to search for a given element. Help Roshan to find out the best option
Ans-
Log 2 n
N
Log 2n+1
Log 2n-1 A Professor class uses the Scheduler class to display the scheduled classes of the professor for a week. What will be the relationship between the Professor and the Schedule class?
Ans-
Inheritance
Aggregation
Composition
Dependency A system administrator needs to identify different types of files in the UNIX system. Help by matching the correct symbols used to identify the file type – 2. l 3.b 4.c
With
a. Regular file b. Link file c. Block device file d. Character device file
Ans-
1-A, 2-B, 3-C, 4-D
1-D, 2-A, 3-B, 4-C
1-D, 2-B, 3-C, 4-A
1-D, 2-C, 3-B, 4-A Choose the executable query to display contact_details by concatenating mail_id and the phone number of employees (multiple answers possible)
Example: table name- employee
Mail-id phone_number
123@gmail.com 9755367343
Sample output: 123@gmail.com,9755367343
Ans-
SELECT concat(mail_id, phone_number) as contact_details FROM employee;
SELECT mail_id, (‘,’), phone_number as contact_details FROM employee;
SELECT concat(concat(mail_id,’,’),phone_number) as contact_details FROM employee;
SELECT || mail_id || ‘,’ || phone_number as contact_details FROM employee; Zara marketing company wants to keep track of the attendance of its employees in all of their branches so that the salary calculation can be done from the Central office located at Bangalore. The head office has delegated the work to the branch offices so that they can keep track of the attendance in any manner, be it manual or biometric or swipe cards etc.
For the above scenario, identify the correct statements from the given options.
Ans-
Head office is an abstract class
Branch office is an abstract class
Head office is a concrete class
Branch office is a concrete class
Both head office and branch office are abstract classes Which of the following statements are true in regard to the object-oriented programming technique? object is a blueprint or template for a class class is a blueprint or template for an object object is an instance of a class class is an instance of an object
Ans-
1 2 only
1 4 only
2 3 only
3 4 only Assume a class Student with the attributes id, name, grade and collegeName. The value for collegeName is “Trindy” which is same for all the objects of the Student class. What type of variable is collegeName?
Ans-
Static variable
Instance variable possessed by each object
Local variable for the class
Public variable Predict the output
Ans- 10 What does an action flow represents in an Activity Diagram?
Ans-
Transition from one action state to another
Passing of data from activity to another
Trigger events
Flow of priority flows Which of these is used to prevent the error ‘ORA-00937’ not a single group group function?
Ans-
Use group by clause
Use where clause
Use order by clause
Use having clause Which key can be used to change the mode from input mode to command mode?
Ans-
Esc
Esc + i
Esc + a
Esc + l Match the following Tables 2. Index 3. Views 4. Synonyms 5. Sequences
a. store all the data in database
b. indicate where data is stored in another table
c. modify the user’s view of data to only certain rows and columns in a table
d. definable label for a table
e. generate unique integers that can be assigned primary keys of tables
Ans-
1-A, 2-B, 3-C, 4-D, 5-E
1-E, 2-A, 3-B, 4-C, 5-D
1-D, 2-E, 3-C, 4-A, 5-B
1-D, 2-C, 3-E, 4-A, 5-B Choose an DDL command which delete all rows from the table and where the deleted data cannot be rolled back (hint: Table structure should not get deleted)?
Ans-
DROP
TRUNCATE
DELETE
None of the above Match the following data command with the correct output
Consider today’s date is 22nd April 2020 date +%b 2. data +%D 3. date +%F 4. date +%H
With
a. Apr b. 04/22/20 c. 20-04-22 d.05
Ans-
1-A, 2-B, 3-C, 4-D
1-D, 2-A, 3-B, 4-C
1-D, 2-B, 3-C, 4-A
1-D, 2-C, 3-B, 4-A predict the output for the given pseudocode snippet
SET count = 1
WHILE count less than or equal to 5
Print “Hello world”
Count = count+1
END WHILE
Ans-
Prints “Hello world” 5 times
Prints “Hello world” 6 times
Loop goes on infinitely
Prints “Hello world” 4 times Predict the output
Ans- 3 Match the metacharacters with the respective types ?”[][!] 2. > >> < << 3. ,() & && || 4. $1 to $9
a. Positional parameters b. Filename substitution c. I/O Redirection d. Process Execution
Ans-
1-A, 2-B, 3-C, 4-D
1-D, 2-A, 3-B, 4-C
1-D, 2-B, 3-C, 4-A
1-D, 2-C, 3-B, 4-A the standard output of one program can be redirected as standard input to another program using _
Ans-
|
||
>
< Consider the query
Start program
DELETE FROM departments WHERE department_id=50;
ERROR 1: ORA-02292: integrity constraint (HR.EMP_DEPT_FK) violated – child record found
End program.
What does the error convey?
Ans-
You cannot delete a row, if the row’s primary key column holds a input that is present as a foreign key in another table
You cannot delete a row when it has column level constraints
You cannot delete a row when it has table level constraints
None of the options Which of the following
a. int number();
b. float average
c. double[] marks;
d. counter int[];
Ans- Consider the following code snippet and predict the output
Ans- Compilation error at Line-1 : The blank final field ‘x’ may not have been initialized What will be the output of the following Java code
Ans- 1003 What is the output of the following Java code
Ans- Compilation error Predict the output
Ans- ONE TWO THREE Consider the table Product (pid, pname, pcost) Identify the appropriate SQL statement to rename the table to ProductsInfo.
Ans-
ALTER TABLE Products RENAME TO ProductInfo; Consider the table Account (accId, balance, accountType). The following constraints to be enforced AccId should be unique and NOT NULL Account type should be ‘C’ or ‘S’. Balance should be greater than 1000 and 3000 for account type ‘C’ and ‘S’ respectively.
Identify the CORRECT SQL statement to create the Account table with the above mentioned constraints.
Ans-
CREATE TABLE account (accid NUMBER (2) CONSTRAINT acc_pk PRIMARY KEY, balance NUMBER (4), accountType CHAR , CONSTRAINT acc_chk CHECK (accountType=’S’ AND balance>3000) OR (accountType=’C’ AND balance>1000)); Which of the following is used to reference data that can act as an abbreviation or can be found at an external location?
Ans- ENTITY Display the contents present inside tag in uppercase. Which of the following options will suit the requirement?
Ans- h1{text-transform: uppercase;} __ is an unparsed character data that can’t be parsed be the parser.
Ans- CDATA In a CSS script, each property of an element is separated by a __
Ans – semicolon (;) In CSS script, which of the following style is used to print a table with double border?
Ans- border-style: double; An external Java script file can be included in an HTML code using the __ attribute in a script tag
Ans – src Predict the output
Ans- Run time exception Which of the following tag is not supported in HTML5 but used in HTML4?
Ans- which OOP principle is the ranking or ordering of abstraction
Ans- hierarchy The object which is used to fetch the input from an element for processing is __
Ans- document
Form
navigate Predict the output
Ans- [One, 1, null, 3.4, null] in which of the following statements can sub queries used?
Ans –
SELECT statement and UPDATE statement
Alter statement
DELETE statement
All of the above Match the appropriate options to move cursors in the vi editor l 2. k 3. h 4. b
With
a. move cursor down one line
b. move cursor up one line
c. move cursor left one line
d. move cursor to beginning of next word
Ans-
1-A, 2-B. 3-C, 4-D For a logically cohesive module, there are some activities to be experimented. These activities are preferred from inside the module itself
Is the above given statement true? If not, choose the correct option to make it true.
Ans-
the activities are selected from outside the module
the activities are selected in a random manner
the activities are selected in a sorted manner
the given statement is true Which of the given pseudocodes finds the perimeter (circumference) of the circle radius
Ans-
BEGIN
NUMBER radius, circumference
INPUT radius
Circumference=23.14radius
OUTPUT circumference
END which of the given statements are true with respect to hierarchy principle of OOP
Ans-
Generalization represents “IS A” relationship between classes Predict the output
Ans- Run time exception Predict the output
Ans – 1 3 8 Predict the output
Which of the following statement has to be uncommented in order to compile the above code without any errors?
Ans-
Return new ArrayList<TempEmp<(); which of the following is a well formed XML document?
Ans-
Startprogram
ravi nehrunagar 23251545
Endprogram Which of the following java script code helps to change the content of the anchor tag?
Startprogram
click here
End program
Ans=
Document.getElementById(“hid1”).innerHTML=”clicked” which of the following jQuery script is valid to hide the first occurred paragraph with the class name as hideMe
Ans – review
$(“p.hideMe:hide(first)”); consider the table Project (ProjectId, ProjectName, ProjectType) is created without any constraint and has the records as per attachment
ProjectId ProjectName ProjectType
P1 FIN A1
P2 SALE A2
P1 FIN A1
Identify the ALTER statement which executes successfully on project table.
Ans-
ALTER TABLE Project ADD CONSTRAINT proj_pk PRIMARY KEY(ProjectId);
ALTER TABLE Project ADD CONSTRAINT proj_uk UNIQUE(ProjectName);
ALTER TABLE Project ADD CONSTRAINT proj_no NOT NULL(ProjectType);
ALTER TABLE Project ADD CONSTRAINT proj_chk CHECK(ProjectType IN(“A1”,”A2”)); Consider table Player(PlayerId, PlayerName, Rating) has records as shown below.
PlayerId PlayerName Rating
P1 Sachin 5
P2 ABD 4.3
P3 Virat 4.6
P4 Watson 4.3
P5 Butler 4.6
Identify the appropriate SQL statement to display the player details whose rating is equal to Virat’s rating or Watson’s rating (note: Result can have Virat’s and Watson’s record as well)
Ans-
SELECT * FROM Player where Rating IN (SELECT Rating FROM Player WHERE PlayerName = “Virat” or PlayerName= “Watson”); What access specifier can be used for computeSalary() method in Employee class so that code in Line-1 will execute without any error?
Ans- Either public or protected or default Consider the tables given below
Customer (customerId, customerName)
Book (bookId, bookName)
Purchase (purchaseId, bookId, customerId)
bookId and customerId in purchase table are foreign keys referring to Book and Customer book tables respectively. Which is the CORRECT SQL statement to retrieve name and book name for all books purchased by customers?
Ans-
SELECT c.customerName, b.bookName FROM customer c INNER JOIN purchase p ON c.customerId=p.customerId INNER JOIN book b ON b.bookId=p.bookId; Which command can be used in vi editor to delete 10 lines?
Ans – 10 dd What operator is used to present the error “ORA-01427: single row sub query returns more than one row?
Ans – Use the IN operator a company wants to create a Leave Management System software for its employees. Find the classes for Employee Leave Management software. The company wants to maintain its employee’s leave information.
Ans- (some chose company also)
Employee
Leave
Company
Project Choose an SQL query to find name of all the employees whose name contain the word “kumar” example kumaran, arun kumar (kumar will be at any place)
Ans-
SELECT * FROM employees where lower(name) like “%kumar%”; the element to specify a list of predefined options for input controls is
Ans- Given the following XML document
raveena dantan
What is a correct schema structure for it?
Ans-
Startprogram

Endprogram Predict the output
Ans- IndexOutOfBoundException Predict the output
Ans – CTE Consider the following java code
Identify the CORRECT Java code which will help you to create an instance of Software Engineer
Ans- SoftwareEngineer engineer = new SoftwareEngineer(“Dave”,1007); Given two executable queries
a.) select name, address from users where user_id not in(select user_id from bookingdetails where lower(name)=’city union bank’) order by name;
b.) select name, address from users where user_id in (select user_id from bookingdetails where lower(name) != “city union bank”) order by name;
will both queries produce the same output?
Ans- True State True or False
A sequence diagram can represent object interactions arranged in a time sequence. It will represent only a sequence of the flow but aspects like branching, looping cannot be represented in the sequence diagram
Ans- False Mrs, Nancy has a Pan Card
What is the cardinality relationship between the entities: Person and Pan card
Ans- One to One In the City Library when a member needs to return a book, the librarian will collect the penalty from the member if the book is returned later than the due date. When this is represented in a use case diagram, what is the relationship between the use cases “Return Book” and “Calculate Penalty”?
Ans- extend
Include
Exclude
Generalization
realization which of the following statements are true with respect to “a query with join operation”?
Ans-
You must refer to all the columns from both tables with ….
You must refer to the columns that are common to 2 tab…
You must have the column common to 2 tables in the….
You can sort your result by a column which is not p….. which of these have higher precedence: the AND operator or the NOT operator?
Ans-
AND
NOT
Both have equal precedence
None of the above Which of the following statements is true with respect to given Oracle query
Start program
Create table AQI_DELHI_1 as Select * from AQI_DELHI;
End program
Ans-
Table “AQI_DELHI_1” is created with same structure as that of “AQI_DELHI” table – with AQI_DELHI table’s data
The query is erogenous
Table “AQI_DELHI_1” is created with same structure as that of “AQI_DELHI” table – without AQI_DELHI table’s data Which jQuery is syntactically wrong?
Ans- what is the syntax for representing the minimum of an element in XMLSchema?
Ans-



what is a lifeline in a Sequence Diagram?
Ans-
Objects’s life time
Actor’s life time
System’s life time
Modelling life time what is the use of a DTD in XML development?
Ans-
It is required for validating XML documents
For displaying a particular section of XML code
For avoiding name collisions
For giving more control over structure and content of XML document Consider the given problem statement
You have to input 100 numbers and find the sum of the 100 numbers and display the process of the sum.
Identify which of the given pseudo code snippets would achieve the desired result.
Ans- (pls understand I’m not gonna type all snippets :D) All of the option Predict the output
Ans- (Map=IDIB1001,map=IDIB1000)

Click here to read more Blogs

Click here to read more interview questions and answers

About Author


After years of Technical Work, I feel like an expert when it comes to Develop wordpress website. Check out How to Create a Wordpress Website in 5 Mins, and Earn Money Online Follow me on Facebook for all the latest updates.

Leave a Comment