Oracle 1z0-182 Online Access

Oracle Database 23ai Administration Associate Questions and Answers

Question 9

You execute this command: CREATE BIGFILE TABLESPACE big_tbs DATAFILE '/u01/oracle/data/big_f1.dbf' SIZE 20G; Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace?

Options:

It will be a dictionary-managed tablespace by default.

Additional data files may not be added.

AUTOEXTEND is possible for the datafile.

It will always have a 32K blocksize.

It must be bigger than the largest SMALLFILE tablespace.

Question 10

orcl.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~] impdp system/oracle SCHEMAS=sh,oe REMAP_SCHEMA=sh:hr DUMPFILE=orcl.dmp EXCLUDE=index TABLE_EXISTS_ACTION=replace LOGFILE=impdp.log Which two statements are true?

Options:

It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

It skips only tables that exist in ORCL:SH and ORCL:OE.

It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR.

It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR.

It skips only indexes that exist in both ORCL:SH and TESTDB:HR.

Question 11

Which three statements are true about roles?

Options:

Roles must be password protected.

Roles may be granted to other roles.

The SET ROLE statement can enable one or more roles for a session.

Object privileges may not be granted to roles.

All roles granted to a user are set on default when the user logs in.

The SET ROLE statement can disable one or more roles for a session.

Answer:

B, C, F

Explanation:

Roles in Oracle manage privileges efficiently. Let’s dive into each option:

A. Roles must be password protected.

Explanation:False. Roles can be password-protected (e.g., CREATE ROLE mgr IDENTIFIED BY secret), but it’s optional. Non-protected roles (default) are enabled automatically if granted, requiring no password.

Mechanics:Password-protected roles need SET ROLE mgr IDENTIFIED BY secret, enhancing security for sensitive privileges.

B. Roles may be granted to other roles.

Explanation:True. Roles can form hierarchies (e.g., GRANT clerk TO mgr), allowing nested privilege management.

Mechanics:A user with mgr inherits clerk privileges indirectly. Revoking clerk from mgr cascades appropriately.

Practical Use:Simplifies complex privilege structures in large organizations.

C. The SET ROLE statement can enable one or more roles for a session.

Explanation:True. SET ROLE role1, role2; activates specified roles for the session, assuming they’re granted and not password-protected (or password is provided).

Mechanics:Enabled roles grant their privileges immediately within the session scope.

D. Object privileges may not be granted to roles.

Explanation:False. Object privileges (e.g., GRANT SELECT ON emp TO clerk) are a primary use of roles, making this statement incorrect.

Why Incorrect:Roles are designed for this purpose, contradicting the option.

E. All roles granted to a user are set on default when the user logs in.

Explanation:False. Only roles marked as DEFAULT ROLE (via ALTER USER ... DEFAULT ROLE role1) are enabled at login. Non-default roles require SET ROLE.

Mechanics:Check via SELECT * FROM DBA_ROLE_PRIVS WHERE DEFAULT_ROLE='YES'.

F. The SET ROLE statement can disable one or more roles for a session.

Explanation:True. SET ROLE NONE disables all roles, or SET ROLE role1 implicitly disables others not listed, providing granular control.

Practical Use:Useful for testing or restricting privileges temporarily.

[References:Oracle Database Security Guide 23ai, "Managing Roles"; Oracle Database SQL Language Reference 23ai, "SET ROLE.", , ]

Question 12

You have connected to the CDB root as a common user with the CREATE PLUGGABLE DATABASE system privilege and issued the following command: SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER admin1 IDENTIFIED BY p1 ROLES = (CONNECT) FILE_NAME_CONVERT = ('PDB$SEEDdir', 'PDB1dir'); Which three are results of the CREATE command?

Options:

It creates new default schemas for the PDB.

It creates tablespaces to store metadata.

It creates a new local user ADMIN with SYSDBA privileges.

The PDB must be opened Read Only to complete the integration of the PDB into the CDB.

After the PDB is created, it is automatically opened Read/Write.

It creates a new local user ADMIN with restricted privileges.

Special Summer Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Database 23ai Administration Associate Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

CompTIA

Fortinet

Microsoft

Salesforce