#322. In your initialization parameter file, the RESOURCE_LIMIT parameter is set to FALSE. The database users have a profile that contains both password and resource restrictions. What is the impact of this parameter setting on the sessions of the database users?
#323. In your database, you observe that a database user is executing a lot of CPU-intensive queries, there by causing the database performance to degrade. You want to restrict the resource utilization of that user without affecting other database users. Which two options can you use? (Choose two.)
#325. You created the password file in your database server as follows: $ orapwd file=$ORACLE_HOME/dbs/orapwdb password=dba entries=2 Further, you granted the SYSDBA privilege to the user SCOTT who has TIGER as the password. What effect would the assigning of this privilege have on Scotts password?
#327. You plan to enable user tracing in your database. You changed the value of the SQL_TRACE parameter to TRUE in the initialization parameter tile and restarted the database. Which statement is true in this scenario?
#328. You installed the Oracle software and want to create a database manually as per the following plan: 1 The database should have 10 tablespaces. 2 The database should use OS authentication. 3 The database should operate in ARCHIVELOG mode. Which files do you need to create before creating the database?
gen. 0.068
Forum
Master braindump