Your database is configured in shared server mode. However, your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.
What could be the reason for this()
A.to limit the User Global Area (UGA) memory allocated to a session from the SGA
B.to limit the amount of memory to be used for the dispatcher queue of a session in SGA
C.to limit the amount of memory to be used for the request pool in System Global Area (SGA)
D.to control the amount of memory allocated in SGA for the local variables for each shared server process
您可能感兴趣的试卷
你可能感兴趣的试题
Your database instance is currently configured to support 1,500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.
You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA,
which configuration would you set to support more than 1,500 connections at a time()
A.You would configure more listeners for the database.
B.You would configure the database in shared server mode to use the connection pooling feature.
C.You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
D.You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable
information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification.
Which schema object enables the user to access the information from the remote database()
A.Cluster
B.Database link
C.Mapping table
D.Materialized view
A.when multiple databases are to be registered with the listener
B.when DBAs need to connect remotely to start up the database instance
C.when users need to connect the database instance using the host naming method
D.when the database instance that is to be registered with the listener is configured in shared server mode
View the Exhibit and examine the output.
Which two statements are true regarding the LISTENER2 listener()
A.The ORCL instance is registered dynamically with the listener.
B.The ORCL instance is registered statically in the listener.ora file.
C.The number of current client connections handled by the service handler is two.
D.The total number of client connections handled so far by the service handler is two.
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command:
LSNRCTL> STOP
What happens to the sessions that are presently connected to the database instance()
A.The sessions are able to perform only queries.
B.The sessions are not affected and continue to function normally.
C.The sessions are terminated and the active transactions are rolled back.
D.The sessions are not allowed to perform any operations till the listener is started.
What could be the reason for this()
A.The listener is not running on the database node.
B.The TNS_ADMIN environmental variable is set to a wrong value.
C.The orcl.oracle.com database service is not registered with the listener.
D.The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client
while connecting to the database instance from a remote machine()
A.host naming method
B.local naming method
C.external naming method
D.directory naming method
A.Listeners use only the TCP/IP protocol.
B.Multiple listener processes can run simultaneously on a host.
C.Multiple database instances can be registered with a single listener.
D.The listener-related errors can be traced only at the administrative level.
E.Only one database instance can be registered with a single listener at any time.
A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL> connect smith/smith
Connected.
SQL> SELECT * FROM v$session;
SELECT * FROM v$session *
ERROR at line 1:
ORA-00942: table or view does not exist
Which are the two possible solutions to enable SMITH to query the data in V$SESSION()
A.granting SELECT privilege to SMITH on V$SESSION
B.granting SELECT privilege to SMITH on V_$SESSION
C.asking the user SMITH to run the catalog.sql script
D.granting SELECT privilege to SMITH on V$FIXED_TABLES
E.setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
F.creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
Note the points about data dictionary views and dynamic performance views:
1.These are stored in the SYSTEM tablespace.
2.These are the based on the virtual tables.
3.These are owned by the SYSuser.
4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE.
5.V$FIXED_TABLE view can be queried to list the names of these views.
Which statements listed describe the data dictionary views()
A.1 and 3
B.2,3,and 5
C.1,2,and 3
D.2,3,4,and 5
最新试题
Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a tablethat has an associated Bitmap index()
You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effect of the command()
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions:SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’;3 rows deleted.The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands()
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95Which background process is responsible for issuing alerts when the threshold is crossed()
You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted()
Which statements are correct about temporary tables()
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output()
Which statements are true regarding a tablespace()
The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace.Which three action would allow the user to insert data()