Which of the following constraint states prevents new data (that violates the constraint) from entering into the table, but allows invalid data to exist in the table?

The current password file allows five entries. New DBAs have been hired and five more entries need to be added to the file. How can you increase the allowed number of entries in the password file?

Which of the following constitute the advantages that the server parameter file (SPFILE) provides while managing initialization parameters?

Where is free space managed for a tablespace created with automatic segment-space management?

Which of the following memory areas is used to cache the Data Dictionary Information?

A DBA has issued the following SQL statement: SELECT max_blocks FROM dba_ts_quotas WHERE tablespace_name='USER_TBS' AND username='MARRY'; User Marry has unlimited quota on the USER_TBS tablespace. Which of the following values will the query return?

Which of the following methods is correct for starting an instance to create a database?

You need to drop two columns from a table. Which of the following sequence of SQL statements is used to drop the columns and limit the number of times the rows are updated?

A DBA has issued the following SQL statement: SELECT max_blocks FROM dba_ts_quotas WHERE tablespace_name='USER_TBS' AND username='MARRY'; User Marry has unlimited quota on the USER_TBS tablespace. Which of the following values will the query return?

Which of the following memory areas is used to cache the Data Dictionary Information?

Where is free space managed for a tablespace created with automatic segment-space management?