0
Alien head

programming languages Online Quiz - 66

Description: programming languages Online Quiz - 66
Number of Questions: 20
Created by:
Tags: programming languages

_________ is a feature that allows one interface to be used for a general class of actions.

  1. Encapsulation

  2. Class

  3. Inheritance

  4. Polymorphism

Answer: 4

Java allows two or more statements to be grouped into blocks of code called Code Blocks.

  1. True

  2. False

Answer: 1

A constant value in Java is created by using a literal representation of it.

  1. True

  2. False

Answer: 1

An _________ is a special kind of Java program that is designed to be transmitted over the Internet.

  1. Viewlet

  2. Applet

  3. Servlet

  4. Object

Answer: 2

The print( ) method is just like println( ), except that it does not output a newline character after each call.

  1. True

  2. False

Answer: 1

The Separator, Comma is Used to separate package names from subpackages and classes

  1. True

  2. False

Answer: 2

_____________ is the process by which one object acquires the properties of another object.

  1. Encapsulation

  2. Class

  3. Inheritance

  4. Polymorphism

Answer: 3

Which function forces group functions to include null values?

  1. Group By

  2. NVL

  3. Order By

  4. Include NULL

Answer: 2

Which is the clause used to restrict groups?

  1. Having

  2. Where

  3. restrict

  4. exclude

Answer: 1

We can use MIN and MAX for any

  1. Numeric data

  2. Data type

  3. Character data

  4. None of the above

Answer: 2

Self Join is used to join a table to itself.

  1. True

  2. False

Answer: 2

Outer join operator is indicated as

  1. (+)

  2. (-)

  3. (*)

  4. +

Answer: 1

An outer join is used to:

  1. Return records which have no direct match

  2. Return records which have direct match

  3. Return all the records

  4. None of the above

Answer: 1

A Non equi-join is a join condition that does not contain an equality operator.

  1. True

  2. False

Answer: 2

The minimum number of join statements required to join 10 tables together are:

  1. 9

  2. 11

  3. 5

  4. 12

  5. None of the above

Answer: 1

Which of the following WHERE clauses represent equi-join?

  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above

Answer: 2

In a join condition it is mandatory to specify the table name along with the column name

  1. True

  2. False

Answer: 2

When is a Cartesian product formed?

  1. When a join condition is omitted.

  2. When a join condition is invalid.

  3. All rows in the first table are joined to all rows in the second table

  4. All of the above.

Answer: 4

We can nest Group Functions

  1. True

  2. False

Answer: 2

We can use Group functions in the WHERE clause

  1. True

  2. False

Answer: 2
+ View questions