Sawaal

 Oracle Certification Questions

Popular Latest Rated
Q:

Which packages contain the JDBC classes?

A) java.sql B) java.sl
C) java.jd D) java.jdbc
 
Answer & Explanation Answer: A) java.sql

Explanation:

The Java packages which contain JDBC classes and interfaces is Java.SQL.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Database Administration , IT Trainer , Software Architect

6 19458
Q:

A relational database developer refers to a record as

A) a relation B) an attribute
C) a criteria D) a tuple
 
Answer & Explanation Answer: D) a tuple

Explanation:

A relational database developer refers to a record as a tuple.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Database Administration , IT Trainer , Project Manager , Software Architect

7 12941
Q:

How many joining conditions are required to join 4 tables in SQL?

A) 1 B) 2
C) 3 D) 4
 
Answer & Explanation Answer: C) 3

Explanation:

To join 'n' tables 'n-1' conditions should be satisfied.

So to join 4 tables 3 conditions should be satisfied.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer

5 11052
Q:

The SQL keyword(s) ________ is used with wildcards.

A) LIKE only B) IN only
C) NOT IN only D) IN and NOT IN
 
Answer & Explanation Answer: A) LIKE only

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Database Administration , IT Trainer

2 8115
Q:

In the following pieces of code, B and D will compile without any error. True or false ?

A: StringBuffer sb1 = "abcd";

B: Boolean b = new Boolean("abcd");

C: byte b = 255;

D: int x = 0x1234;

E: float fl = 1.2;

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

The code segments B and D will compile without any error. A is not a valid way to construct a StringBuffer, you need to create a StringBuffer object using "new". B is a valid construction of a Boolean (any string other than "true" or "false" to the Boolean constructor will result in a Boolean with a value of "false"). C will fail to compile because the valid range for a byte is -128 to +127 (i.e., 8 bits, signed). D is correct, 0x1234 is the hexadecimal representation in java. E fails to compile because the compiler interprets 1.2 as a double being assigned to a float (down-casting), which is not valid. You either need an explicit cast, as in "(float)1.2" or "1.2f", to indicate a float.

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Analyst , IT Trainer , Project Manager

7 8092
Q:

what will be the output of the following code?

class Value
{
    public int i = 15;
}
public class Test
{
    public static void main(String argv[])
    {
        Test t = new Test();
        t.first();
    }
    public void first()
    {
        int i = 5;
        Value v = new Value();
        v.i = 25;
        second(v, i);
        System.out.println(v.i);
    }
    public void second(Value v, int i)
    {
        i = 0;
        v.i = 20;
        Value val = new Value();
        v =  val;
        System.out.println(v.i + " " + i);
    }
}

A) 15 0 2 B) 15 0 0
C) 15 20 0 D) 15 0 20
 
Answer & Explanation Answer: D) 15 0 20

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Analyst , IT Trainer , Project Manager , Software Architect

4 7157
Q:

Which dml command is used in conjunction with @@identity?

A) INSERT and UPDATE B) UPDATE and DELETE
C) SCOPE_IDENTITY and IDENT_CURRENT D) Commit and rollback
 
Answer & Explanation Answer: C) SCOPE_IDENTITY and IDENT_CURRENT

Explanation:

Using automatically incrementing IDENTITY columns is very popular with database developers. You don’t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.

 

You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Software Architect , Project Manager , Network Engineer , IT Trainer , Database Administration , Analyst

9 6119
Q:

What is the output after compile and run the following code ?

int Output = 10;
boolean b = false;
if((b == true) && ((Output += 10) == 20))
{
System.out.println("We are equal " + Output);
}
else
{
System.out.println("Not equal! " + Output);
}

A) Compilation and output of "We are equal 10" B) Compilation and output of "Not equal! 10"
C) Compilation error, attempting to perform binary comparison on logical data type D) Compilation and output of "Not equal! 20"
 
Answer & Explanation Answer: B) Compilation and output of "Not equal! 10"

Explanation:

The output will be "Not equal! 10". Please note that && is logical AND operator. If first operand before (&&) is false then the other operand will not be evaluated. This illustrates that the Output +=10 calculation was never performed because processing stopped after the first operand was evaluated to be false. If you change the value of b1 to true, processing occurs as you would expect and the output would be "We are equal 20".

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Analyst

6 5686