Sawaal
7
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:   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.

Subject: Oracle Certification
Job Role: Analyst , IT Trainer , Project Manager
Related Questions
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 19274
Q:

Which of the following is a comparison operator in SQL?

A) LIKE B) BETWEEN
C) = D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

LIKE, BETWEEN and = operators are used for comparison in SQL. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk

2 2185
Q:

Count function in SQL returns the number of

A) groups B) values or rows
C) columns D) distinct values
 
Answer & Explanation Answer: B) values or rows

Explanation:

Count function in SQL returns the number of values or rows.

Report Error

View Answer Report Error Discuss

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

3 2974
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 8008
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 12719
Q:

What is an Extension of Entity Type?

Answer

The collections of entities of a particular Entity Type are grouped together into an entity set.

Report Error

View answer Workspace Report Error Discuss

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

0 1889
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 10893
Q:

Data integrity constraints are used to

A) Ensure that duplicate records are not entered into the table B) Prevent users from changing the values stored in the table
C) Control who is allowed access to the data D) Improve the quality of data entered for a specific property like table column
 
Answer & Explanation Answer: D) Improve the quality of data entered for a specific property like table column

Explanation:

Integrity constraints are used to ensure accuracy and consistency of data in a relational database. Data integrity is handled in a relational database through the concept of referential integrity. Many types of integrity constraints play a role in referential integrity (RI).

 

Hence, Data integrity constraints are used to Improve the quality of data entered for a specific property i.e, table column.

Report Error

View Answer Report Error Discuss

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

0 3079