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 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: *

Which two statements are true about the DUAL table? (Choose two.)

• A.It can be accessed only by the SYS user
• B.It can display multiple rows and columns
• C.It can be used to display only constants or pseudo columns
• D.It can be accessed by any user who has the SELECT privilege in any schema
• E.It can display multiple rows but only a single column
• F.It consists of a single row and single column of VARCHAR2 data type

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about smallfile tablespaces?

• A.Segments can span multiple tablespaces.
• B.Segments can span multiple data files.
• C.The number of data files is constrained only by the size of the storage array.
• D.Extent location metadata is stored in the data dictionary by default.
• E.Maximum file size can be set to unlimited only if the logical volume manager supports striping.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding indexes? (Choose three.)

• A.A UNIQUE index can be altered to be non-unique
• B.A table belonging to one user can have an index that belongs to a different user
• C.A SELECT statement can access one or more indices without accessing any tables
• D.An update to a table can result in updates to any or all of the table's indexes
• E.An update to a table can result in no updates to any of the table's indexes
• F.When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

Comment: *

Name: *

Email: *

Verification: *