Oracle Certification Questions

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

0 2887
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

2 2734
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

0 2660
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

2 2612
Q:

Data integrity constraints are used to

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
 
Answer & Explanation Answer: D) Improve the quality of data entered for a specific property like table column

Explanation:

Integrity constraints are used to ensure accuracy and consistency of data in a relational database. Data integrity is handled in a relational database through the concept of referential integrity. Many types of integrity constraints play a role in referential integrity (RI).

 

Hence, Data integrity constraints are used to Improve the quality of data entered for a specific property i.e, table column.

Report Error

View Answer Report Error Discuss

0 2556
Q:

STUFF and REPLACE are used to replace characters in a string

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

Explanation:

They both are used to replace characters in a string

Report Error

View Answer Workspace Report Error Discuss

0 2492
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 2414
Q:

Count function in SQL returns the number of

A) groups B) values or rows
C) columns D) distinct values
 
Answer & Explanation Answer: B) values or rows

Explanation:

Count function in SQL returns the number of values or rows.

Report Error

View Answer Report Error Discuss

2 2410