226-1z0-071: Oracle Datbase 12c SQL

#Question

To display the current user logged into the Oracle Database, which SQL command is required?

A.

SELECT ACTIVE_USER;

B.

SELECT SESSION_USER;

C.

SELECT CURRENT_USER;

D.

SELECT USER FROM dual;

Reveal answer Discussion

0

Correct Answer: D

The SELECT USER command returns the username of the current session in Oracle, providing convenient context for user-related queries.

1z0-071: Oracle Datbase 12c SQL

Discussing...

To display the current user logged into the Oracle Database, which SQL command is required?

---

you have to be logged in to comment Login Or Register

#Question

To find the maximum number of concurrent users that can connect to the database, which query should be executed?

A.

SELECT * FROM v$database;

B.

SELECT MAX_USERS FROM v$parameter;

C.

SELECT COUNT(*) FROM v$session;

D.

SHOW PARAMETERS;

Reveal answer Discussion

0

Correct Answer: C

Querying the v$session view provides the current session information, useful for identifying the maximum number of concurrent users.

1z0-071: Oracle Datbase 12c SQL

Discussing...

To find the maximum number of concurrent users that can connect to the database, which query should be executed?

---

you have to be logged in to comment Login Or Register

#Question

A user wants to retrieve only employees with a certain position but in a case-insensitive manner. What should be used?

A.

REGEXP;

B.

LIKE operator;

C.

UPPER() function;

D.

LOWER() function;

Reveal answer Discussion

0

Correct Answer: D

The LOWER() function allows comparisons without regard to case, making it easier to match entries irrespective of their casing.

1z0-071: Oracle Datbase 12c SQL

Discussing...

A user wants to retrieve only employees with a certain position but in a case-insensitive manner. What should be used?

---

you have to be logged in to comment Login Or Register

#Question

To find the current date in SQL, what command should be used?

A.

SELECT NOW();

B.

SELECT GETDATE();

C.

SELECT CURRENT_DATE;

D.

SELECT SYSDATE FROM dual;

Reveal answer Discussion

0

Correct Answer: D

SYSDATE returns the current date and time in Oracle SQL, accessible from the dual table, often used for such queries.

1z0-071: Oracle Datbase 12c SQL

Discussing...

To find the current date in SQL, what command should be used?

---

you have to be logged in to comment Login Or Register

#Question

When a database is recovering from a failure, which SQL command should be executed first?

A.

Rebuild indexes;

B.

Truncate all tables;

C.

Start a recovery process;

D.

Rollback uncommitted transactions;

Reveal answer Discussion

0

Correct Answer: C

Starting the recovery process is crucial in restoring the database to a consistent state after a failure, allowing for the correction of uncommitted data.

1z0-071: Oracle Datbase 12c SQL

Discussing...

When a database is recovering from a failure, which SQL command should be executed first?

---

you have to be logged in to comment Login Or Register

#Question

How can you ensure that a stored procedure cannot be modified by users?

A.

Set it as a public synonym;

B.

Use the EXECUTE ONLY privilege;

C.

Add it to a read-only schema;

D.

Use DEFINITION ONLY onCREATE;

Reveal answer Discussion

0

Correct Answer: B

The EXECUTE ONLY privilege prevents users from modifying the stored procedure while allowing execution, ensuring controlled access.

1z0-071: Oracle Datbase 12c SQL

Discussing...

How can you ensure that a stored procedure cannot be modified by users?

---

you have to be logged in to comment Login Or Register

#Question

What's the purpose of a data dictionary in a database?

A.

To manage backups;

B.

To hold user credentials;

C.

To backup data;

D.

To store metadata;

Reveal answer Discussion

0

Correct Answer: D

A data dictionary contains metadata that describes the structure and characteristics of the database objects within the system, aiding in management and operations.

1z0-071: Oracle Datbase 12c SQL

Discussing...

What's the purpose of a data dictionary in a database?

---

you have to be logged in to comment Login Or Register