Oracle-SQL/PLSQL MCQ with Answers SET - 2

 

1. The …. And …. Are the membership operators in Oracle

A) AND, OR
B) <> ,!=
C) IN and NOT IN
(D) None of the above

ANSWER= (C) IN and NOT IN
Explain:- The IN and NOT IN are the membership operators

 

2. Float data type is used to represent ….. values

A) Numeric
B) integer
C) Whole
(D) Floating Values

ANSWER= (C) Floating Values
Explain:- The Float data type is used to represent Floating Values

 

3. The ….. data types is used to represent numeric values

A) Number,integer, Float
B) Char, Varchar, Integer
C) Number, Integer, Varchar
(D) None of the above

ANSWER= (A) Number,integer, Float
Explain:- The Number,integer, Float are used to represent Numeric values in Oracle

 

4. The Varchar2 data type helps to store ….. Bytes data

A) 2000
B) 4000
C) 1000
(D) 4000

ANSWER= (D) 4000
Explain:- The Varchar dta type helps to store 4000 Bytes data in a table

 

5. The … data type is used to represent whole data values in Oracle

A) Float
B) Number
C) Integer
(D) None of the above

ANSWER= (C) Integer
Explain:- The Integer data type is used to represent whole values in Oracle

 

6. The logical operator ….. Returns True if both the conditions are true

A) OR
B) AND
C) NOR
(D) NOT

ANSWER= (B) AND
Explain:- The logical operator AND returns True if both the conditions are True

 

7. Which of following is not relational operator

A) ==
B) >
C) <
(D) !=

ANSWER= (A) ==
Explain:- The == is not used in Oracle. = is the equality operator in Oracle

 

8. In Oracle the equality operator is…

A) ==
B) =
C) Not equals
(D) !=

ANSWER= (B) =
Explain:- In Oracle the = single equals used for equality in Oracle. = is the equality operator in Oracle

 

9. If Number(2,2) is used to define the column. It will help to represent … values

A) Float
B) Integer
C) Number
(D) None of the above

ANSWER= (A) Float
Explain:- In Oracle if the Number(2,2) is used to define the floating values. The width of column will be 2 and up to two decimal points will be allowed to store in a column.

 

10. In Oracle conditions are checked by using ….. operators

A) Logical
B) Relational
C) Bitwise
(D) None of the above

ANSWER= (B) Relational
Explain:- In Oracle Relational operators are used to apply the condition on the column and based on the condition the operation is performed

 

11. Which clause is used to retrieve data from the table

A) Where
B) Insert
C) From
(D) Select

ANSWER= (D) Select
Explain:- In Oracle Select data is used to retrieve data from table

 

12. If parent data and child table data does not match what error will occur

A) Parent data does not found
B) Child data doesnot found
C) Unique data violation
(D) None of above

ANSWER= (A) Parent data does not found
Explain:- When you have made the relationship between two tables, In one table the column is Primary Key column and same common column is there in another table having Foreign Key. In this case the parent table data for common column and Child table data should match otherwise Parent data does not found error will occur.

 

13. Which query is correct for Alter Table to add new column D_id Varchar(4) to Department Table

A) Alter Table Department Add D_id Varchar(4);
B) Alter Department Add D_id Varchar(4);
C) Alter Table Department Set D_id Varchar(4);
(D) None of above

ANSWER= (A) Alter Table Department Add D_id Varchar(4);
Explain:- To add new column in existing table Alter Add Query is used with this syntax: Alter Table Tablename Add Columnname Datatype(Size);

 

14. Which of the following query is used to update the information from Table

A) Alter Add
B) Alter Modify
C) Insert All
(D) Update Set

ANSWER= (D) Update Set
Explain:- To Update the Information from Table Update Set query is used

 

15. Which data constraint is used to maintain referential data integrity

A) Primary Key
B) Foreign Key
C) Unique Key
(D) Check Constraint

ANSWER= (B) Foreign Key
Explain:- The Foreign Key data constraint is used to maintain referential data integrity