Which two statements are true about User Authentication in an Oracle Database?

• A.Operating System authentication may be used for system-privileged administrative users.
• B.REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users.
• C.Password File authentication must be used for system-privileged administrative users.
• D.Password authentication must be used for system-privileged administrative users.
• E.Password File authentication is supported for any type of database user.

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqiidr execution?

• A.It appends data from EMP.DAT TO EMP.
• B.It overwrites all data in emp with data from emp.dat.
• C.It generates a sqi script that it uses to load data from EMP.DAT TO EMP.
• D.It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.
• E.It overwrites the data for Alan and adds data for Curl and Bob

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A.Revoke the CREATE SESSION privilege from other users
• B.Revoke the CREATE SESSION privilege from user HR
• C.Log in to the database instance
• D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• E.Execute DDL statements in the HR schema
• F.Execute DML statements in the HR schema

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about views in an Oracle database? (Choose three.)

• A.Views can be updated without the need to re-grant privileges on the view
• B.Data Manipulation Language (DML) can always be used on views
• C.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• D.Tables in the defining query of a view must always exist in order to create the view
• E.The WITH CHECK clause prevents certain rows from being displayed when querying the view
• F.The WITH CHECK clause prevents certain rows from being updated or inserted
• G.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

Comment: *

Name: *

Email: *

Verification: *

Which two tasks can you perform using DBCA for databases? (Choose two.)

• A.Configure a nonstandard block size for a new database
• B.Register a new database with an available Enterprise Manager Management server
• C.Change the standard block size of an existing database
• D.Configure incremental backups for a new database
• E.Enable flashback database for an existing database

Comment: *

Name: *

Email: *

Verification: *