1Z0-060 試験問題を無料オンラインアクセス

Which three SQL statements would display the value 1890.55 as $1, 890.55?

• A.Option A
• B.Option E
• C.Option B
• D.Option C
• E.Option D

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 EMPLOYEEStable in the SECURESPACEtablespace with the SALToption on the EMPLOYEEcolumn.
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 creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• C.It generates an error when creating the table because the wallet is closed.
• D.It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Which two statements are true regarding constraints?

• A.A column with the unique constraint can contain null values.
• B.A foreign key cannot contain null values.
• C.A constraint is enforced only for the insert operation on a table.
• D.A constraint can be disabled even if the constraint column contains data.
• E.All constraints can be defined at the column level as well as the table level.

Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c?
(Choose two.)

• A.You can create and configure pluggable databases by using EM express.
• B.You cannot start up or shut down a database instance by using EM express.
• C.Multiple databases on the same node (or host) may each be individually managed by using EM Express.
• D.By default, EM express is available for a database after database creation.
• E.You can perform basic administrative tasks for pluggable databases by using the EM express interface.

Which two statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?

• A.System privileges apply only to the PDB in which they are used.
• B.System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
• C.Common users connected to a PDB can exercise privileges across other PDBs.
• D.The granter of system privileges must possess the set container privilege.
• E.Local users cannot use local system privileges on the schema of a common user.