Oracle Certification Questions

Q:

The SQL keyword BETWEEN is used:

A) for ranges B) as a wildcard
C) to limit the columns displayed D) All the above
 
Answer & Explanation Answer: A) for ranges

Explanation:

In SQL, BETWEEN Keyword is used for ranges like Number Ranges, Date Ranges, etc...

Report Error

View Answer Report Error Discuss

0 2519
Q:

What is the difference between a Local and a Global temporary table?

Answer

Local :


Only available to the current Db connection for current user and are cleared when connection is closed.


Multiple users can’t share a local temporary table.


 


Global:


Available to any connection once created. They are cleared when the last connection is closed.


Can be shared by multiple user sessions

Report Error

View answer Workspace Report Error Discuss

1 2476
Q:

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

A) MAX B) MIN
C) MAXIMUM D) MAXI
 
Answer & Explanation Answer: A) MAX

Explanation:

MAX command is used to return maximum value from result setMAX 

Report Error

View Answer Report Error Discuss

1 2453
Q:

What command would you use to create a backup control file?

Answer

Alter database backup control file to trace

Report Error

View answer Workspace Report Error Discuss

3 2420
Q:

In R-DBMS, the data is organized in the form of _____.

A) Hierarchical structure B) Tabular structure
C) Linked structure D) All of the above
 
Answer & Explanation Answer: B) Tabular structure

Explanation:

Data is organized in the form of row and columns, thus it is in tabular structure.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification

5 2394
Q:

What are the different types of SQL statements ?

Answer

SQL statements are broadly classified into three. They are


1. DDL – Data Definition Language


DDL is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table.


2. DML – Data Manipulation Language


DML is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table. The Select statement is considered as a limited version of the DML, since it can't change the data in the database. But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function.


3. DCL – Data Control Language


DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc. Example - Grant, Revoke access permission to the user to access data in the database.

Report Error

View answer Workspace Report Error Discuss

4 2325
Q:

Insert command falls in which sub-language of SQL ?

A) DCL B) DQL
C) DML D) DDL
 
Answer & Explanation Answer: C) DML

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification

5 2274
Q:

What is XPath?

Answer

XPath is an expressions to select a xml node in an XML document.


It allows the navigation on the XML document to the straight to the element where we need to reach and access the attributes.


 

Report Error

View answer Workspace Report Error Discuss

1 2115