Sawaal

 Oracle Certification Questions

Popular Latest Rated
Q:

What is the default return value of a function?

A) int B) char
C) string D) None of the above
 
Answer & Explanation Answer: A) int

Explanation:

The default return value from a function is int. In other words, unless explicitly specified the default return value by compiler would be integer value from function.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Database Administration

3 3971
Q:

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

A) Primary key B) Unique key
C) Partial key D) None of the above
 
Answer & Explanation Answer: A) Primary key

Explanation:

Primary key helps us to identify a row uniquely in a relation

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Database Administration

2 3918
Q:

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

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

0 3512
Q:

Multiple users can share a local temporary table

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Multiple users can't share a local temporary table

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

0 3344
Q:

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

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

0 3309
Q:

A Transparent DBMS

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
 
Answer & Explanation Answer: C) Keeps its physical structure hidden from users

Explanation:

DBMS :: Database Managemet System.

A DBMS which keeps its physical structure hidden from the user is known as a transparent DBMS.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer , Network Engineer , Project Manager , Software Architect

2 3264
Q:

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

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

It is one of the operation of Log Shipping

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

0 3150
Q:

What is the difference between oracle,sql and sql server?

Answer

  • Oracle is based on RDBMS.

  • SQL is Structured Query Language.

  • SQL Server is another tool for RDBMS provided by MicroSoft


 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

2 3081