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 regarding indexes? (Choose three.)

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

Comment: *

Name: *

Email: *

Verification: *

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

• A.input files
• B.bad files
• C.password files
• D.dump files
• E.control files

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the PMON background process? (Choose two.)

• A.It registers database services with all local and remote listeners known to the database instance
• B.It frees resources held by abnormally terminated processes
• C.It records checkpoint information in the control file
• D.It frees unused temporary segments
• E.It kills sessions that exceed idle time

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning logical and physical database structures? (Choose three.)

• A.A segment's blocks can be of different sizes
• B.Segments can span multiple tablespsaces
• C.A segment can span multiple data files in some tablespaces
• D.The extents of a segment must always reside in the same datafile
• E.All tablespaces may have one or more data files
• F.A segment might have only one extent
• G.A smallfile tablespace might be bigger than a bigfile tablespace

Comment: *

Name: *

Email: *

Verification: *