The questions are about Oracle Database Management. True or False: A foreign key table can have multiple parents.

D. It specifies the location of inventory used by the Oracle Universal Installer (OUI) 

7.Which view would you query to determine direct grants of system privileges?

A. DBA_SYS_PRIVS.

B. DBA_TAB_PRIVS.

C. SESSION_PRIVS.

D. ALL_PROC_PRIVS. 

8.When one is using shared servers, what may happen if more concurrent requests are received than there are shared server processes?

A. Sessions may receive errors.

B. Statements may be queued.

C. No more shared servers may be started automatically.

D. The shared servers may execute several requests in parallel. 

9.What attributes of a user account can you specify with the CREATE USER command?

A. Default role(s)

B. Tablespace for storing all the user's temporary data

C. Privilege

D. All of the above 

10.If a tablespace is made read-only, what can still be done to objects within it?

A. Insertions into a table will work, as long as there is free space within the segment and so no new extents need to be allocated.

B. Operations that are transparent to applications and users (such as creating indexes) can be done in the tablespace, but no DML commands can be executed against tables within it.

C. Objects in the tablespace can be dropped but not created.

D. No SQL commands can be executed against any objects in a read-only tablespace except SELECT statements. 

11.Which view is best used for finding datafiles info in mount mode?

A. DBA_DATA_FILES

B. DBA_TABLESPACES

C. V$DATABASE

D. V$DATAFILE 

12.What is the effect on established sessions of shutting down the database listener?

A.No impact on any session.

B.Dedicated server sessions will be terminated.

C.Shared server sessions connected through a dispatcher will survive; dedicated server sessions will hang until the listener is restarted.

D. All sessions will be terminated. 

13.If a deadlock occurs, how does it get resolved?

A. Both transactions are rolled back.

B. One transaction is rolled back.

C. Both statements are rolled back.

D. One of the statements is rolled back. 

14.

Create tablespace g1_tabs datafile 'u01/oradata/g1_tabs_01.dbf' Size 1000m autoextend on next 100m maxsize 2000m;

If the critical alert for tablespace usage is set to 90 percent, when will the alert be raised?

A.When the space used by segments that have not been dropped reaches 900MB

B.When the space used by segments that have not been dropped and segments in the recycle bin reaches 900MB

C. When the space used by segments that have not been dropped reaches 1,800MB

D. When the space used by segments that have not been dropped and segments in the recycle bin reaches 1,800MB