0

programming languages Online Quiz - 66

Description: programming languages Online Quiz - 66
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0

We can use Group functions in the WHERE clause

  1. True

  2. False


Correct Option: B

We can nest Group Functions

  1. True

  2. False


Correct Option: B
  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.


Correct Option: D

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

  1. True

  2. False


Correct Option: B

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


Correct Option: B

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


Correct Option: A

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

  1. True

  2. False


Correct Option: B
  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


Correct Option: A

Outer join operator is indicated as

  1. (+)

  2. (-)

  3. (*)

  4. +


Correct Option: A

We can use MIN and MAX for any

  1. Numeric data

  2. Data type

  3. Character data

  4. None of the above


Correct Option: B

Which is the clause used to restrict groups?

  1. Having

  2. Where

  3. restrict

  4. exclude


Correct Option: A

Which function forces group functions to include null values?

  1. Group By

  2. NVL

  3. Order By

  4. Include NULL


Correct Option: B

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

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: A

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


Correct Option: B

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

  1. True

  2. False


Correct Option: A

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

  1. Encapsulation

  2. Class

  3. Inheritance

  4. Polymorphism


Correct Option: D
- Hide questions