Sawaal

 Oracle Certification Questions

Popular Latest Rated
Q:

What is the purpose of SQL Profiler in SQL server?

Answer

SQL profiler is a tool to monitor performance of various stored procedures. It is used to debug the queries and procedures. Based on performance, it identifies the slow executing queries. Capture any problems by capturing the events on production environment so that they can be solved.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

1 2123
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

1 2113
Q:

Explain Data Definition Language

Answer

Data Definition Language (DDL):- are the SQL statements that define the database structure.


Example:



  1.  CREATE

  2.  ALTER

  3.  DROP

  4.  TRUNCATE

  5.  COMMENT

  6.  RENAME

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

1 2050
Q:

Candidate Key in DBMS?

Answer

A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer , Software Architect

1 1881
Q:

Difference between Union and Union all?

Answer

The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table. A UNION statement effectively does a SELECT DISTINCT on the results set.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer , Software Architect

2 1862
Q:

Foreign key in DBMS is

Answer

Foreign keys are the columns of a table that points to the primary key of another table. They act as a cross-reference between tables.


 


In detail : A Foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table.

Report Error

View answer Workspace Report Error Discuss

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

1 1658