set the SESSIONS to 1 in the parameter file
grant SINGLE SESSION privilege to all of the users
set the SESSIONS_PER_USER to 1 in the users’ profile
grant RESTRICTED SESSION privilege to all of the database users
create a role with SINGLE SESSION privilege and assign the role to the users
第1题:
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()
第2题:
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance?()
第3题:
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk; it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available?()
第4题:
In a new installation of Oracle Database 11g, you perform these activities: 1:Organize software and data on different subdirectories to avoid poor performance. 2:Use consistent naming conventions for database files. 3:Separate administrative information pertaining to the database in different directories. Which option corresponds to the type of activities you performed()
第5题:
How many web servers will be connected to the database?
How many concurrent applications will run against the database?
How many concurrent users will be accessing the database?
What are the types of transactions run against the database?
第6题:
create baseline metrics for today’s performance
write the current database metrics to a database table and create a trigger to compare with future database statistics
write the current database metrics to a flat file and create an operating script to compare with future database statistics
write the current database metrics to a database table and create a procedure to compare with future database statistics
write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
第7题:
Configure a Linked Server connection to the application database.
Write a query that uses an OPENDATASOURCE command.
Write a query that uses an OPENQUERY command.
Configure a Remote Server connection to the application database.
第8题:
Memory Advisor
Segment Advisor
SQL Tuning Advisor
SQL Access Advisor
Automatic Database Diagnostic Monitor (ADDM)
第9题:
use the external table population
use the Oracle Data Pump export and import utility
use the conventional path data load of SQL*Loader utility
use the direct path data load of Oracle export and import utility
第10题:
Memory Advisor
Segment Advisor
SQL Tuning Advisor
SQL Access Advisor
Automatic Database Diagnostic Monitor (ADDM)
第11题:
You would configure more listeners for the database.
You would configure the database in shared server mode to use the connection pooling feature.
You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
第12题:
CPU,because the database replication process requires a considerable amount of CPU time
Memory,because the buffer cache requires a large amount of memory to maintain the data in system memory
Disk,because it is important to configure a sufficient number of disks to match the CPU processing power
Network,because the data returned to the client from the server can be a large subset of the total database
第13题:
A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log?()
第14题:
You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()
第15题:
The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective? ()
第16题:
Increase the undo return
Create more undo segments
Create another undotablespace
Increase the size of the undotablespace
第17题:
Do nothing.
Restart the database.
Perform recovery on the database.
Restore the alert log from the last backup.
第18题:
Configure Java Pool to cache the java objects.
Configure Streams Pool to enable parallel processing.
Increase Shared Pool size to cache more PL/SQL objects.
Increase Database Buffer Cache size to increase cache hits.
Configure Large Pool to be used by RMAN and shared server.
Increase the total System Global Area (SGA) size to increase memory hits.
第19题:
Oracle Managed Files
Oracle Grid Architecture
Optimal Flexible Architecture
Oracle database architecture
Automatic Storage Management
第20题:
Alias
View
Schema
Trigger
第21题:
How many web servers will be connected to the database?
Will the database be run on a Windows solution?
How many concurrent users will be accessing the database?
What are the types of transactions run against the database?
第22题:
Only bring the tablespace back online.
Only recover the tablespace and then bring the tablespace back online.
Shut down the database, recover the data file and then start up the database.
Issue the ALTER DATABASE RENAME FILE command, recover the tablespace, and then bring the tablespace online.
Recover the tablespace, issue the ALTER DATABASE RENAME FILE command, and then bring the tablespace online.
第23题:
set the SESSIONS to 1 in the parameter file
grant SINGLE SESSION privilege to all of the users
set the SESSIONS_PER_USER to 1 in the users’ profile
grant RESTRICTED SESSION privilege to all of the database users
create a role with SINGLE SESSION privilege and assign the role to the users
第24题:
Oracle Managed Files
Oracle Grid Architecture
Optimal Flexible Architecture
Oracle database architecture
Automatic Storage Management