A.It can span multiple databases.
B.It can consist of multiple data files.
C.It can contain blocks of different sizes.
D.It can contain segments of different sizes.
E.It can contain a part of a nonpartitioned segment.
您可能感兴趣的试卷
你可能感兴趣的试题
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
最新试题
In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()
Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a tablethat has an associated Bitmap index()
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()
Examine the command that is used to create a table:SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamtNUMBER(10,2)) TABLESPACE users;Which two statements are true about the effect of the above command()
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()
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task()
Which kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?()
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database()
Which statements are true regarding the Oracle Data Pump export and import operations()