Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)

• A.Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
• B.No more data files can be added to the tablespace.
• C.The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
• D.The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
• E.The MRKT tablespace may be dropped if it has no contents.

Comment: *

Name: *

Email: *

Verification: *

You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

• A.It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
• B.It generates an error when creating the table because the wallet is closed.
• C.It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• D.It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?

• A.Create the CREATE_TEST procedure with definer's rights.
• B.Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
• C.Create the CREATE_TEST procedure with invoker's rights.
• D.Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

Comment: *

Name: *

Email: *

Verification: *

A user establishes a connection to a database instance by using an Oracle Net connection.
You want to ensure the following:
1 . The user account must be locked after five unsuccessful login attempts.
2 . Data read per session must be limited for the user.
3 . The user cannot have more than three simultaneous sessions.
4 . The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?

• A.by using Oracle Label Security options
• B.by granting a secure application role to the user
• C.by assigning a profile to the user
• D.by implementing Database Resource Manager

Comment: *

Name: *

Email: *

Verification: *

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

• A.Set DB_FLASH_CACHE_ZISE = 64G.
• B.Set DB_FLASH_CACHE_ZISE = 64G, 64G
• C.Set DB_FLASH_CACHE_ZISE = 128G.
• D.DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Comment: *

Name: *

Email: *

Verification: *