Home - Certification - Oracle Certification

Oracle Certification Online Exam Quiz

Important questions about Oracle Certification. Oracle Certification MCQ questions with answers. Oracle Certification exam questions and answers for students and interviews.

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

Options

A : 1

B : 2

C : 3

D : 4

5. What is the default return value of a function?

Options

A : int

B : char

C : string

D : None of the above

6. 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); } }

Options

A : 15 0 2

B : 15 0 0

C : 15 20 0

D : 15 0 20

7. MOV extension refers usually to what kind of files?

Options

A : Audio

B : Movies or other Videos

C : Images

D : Documents

9. Which among the following keys are used to identify each row of the table uniquely?

Options

A : Primary key

B : Unique key

C : Partial key

D : None of the above

1. A Transparent DBMS

Options

A : Keep its logical structure hidden from users

B : Can access control

C : Keeps its physical structure hidden from users

D : Can not hide sensitive information from users

2. A relational database developer refers to a record as

Options

A : a relation

B : an attribute

C : a criteria

D : a tuple

3. Count function in SQL returns the number of

Options

A : groups

B : values or rows

C : columns

D : distinct values

9. Which command is used to return maximum value from result set?

Options

A : MAX

B : MIN

C : MAXIMUM

D : MAXI

10. A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls

Options

A : TRUE

B : FALSE

C :

D :

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

Options

A : LIKE only

B : IN only

C : NOT IN only

D : IN and NOT IN

5. Which of the following is a comparison operator in SQL?

Options

A : LIKE

B : BETWEEN

C : =

D : All of the above

6. Go command is a signal to execute the entire batch of SQL statements after previous Go

Options

A : TRUE

B : FALSE

C :

D :

7. Copying the logs on the standby/backup server is an operation of Log Shipping

Options

A : TRUE

B : FALSE

C :

D :

8. Multiple users can share a local temporary table

Options

A : TRUE

B : FALSE

C :

D :

9. STUFF and REPLACE are used to replace characters in a string

Options

A : TRUE

B : FALSE

C :

D :

10. Breaking of relationships is allowed once referential integrity on a database is enforced

Options

A : TRUE

B : FALSE

C :

D :

1. Can?t update primary table?s primary key if row being modified has related rows in secondary table once referential integrity is enforced

Options

A : TRUE

B : FALSE

C :

D :

3. The SQL keyword BETWEEN is used:

Options

A : for ranges

B : as a wildcard

C : to limit the columns displayed

D : All the above

4. Data integrity constraints are used to

Options

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

Certification more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.017887115478516