Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently, the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool, you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do?()
第1题:
在缺省配置下,普通用户登录到Windows 2000 Professional中和Windows 2000 Server中后分别所在的组为()
第2题:
下面哪些可以将john添加到users数组中?()
第3题:
A 4-way x445 server with 2GB of memory running Windows 2003 Server with Exchange 2003 is performing poorly. Users are complaining of slow response times when accessing their email. Which subsystem should be checked first as a potential bottleneck?()
第4题:
You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX: SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE; Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation?()
第5题:
The size of the largest datafile, data1.dbf, in your database is 30MB. You issued the following command: RMAN>CONFIGURE MAXSETSIZE 10MB; What will be the impact of the above setting?()
第6题:
You are the administrator of a Windows 2000 Professional computer. A user named Maria assists you in performing some administrative tasks. Maria is a member of local Administrators group. Users report that Maria has been viewing and changing their files. You want Maria to be able to install programs, perform backups and manage printers, but not to view, change or read other users’ files for which permission has not been granted. You want to set up Maria’s account to have minimal rights and permission. You want to accomplish this with least amount of administrative effort. What should you do? ()
第7题:
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?
第8题:
Increase seek translation
Increase data transfer rate
Decrease rotational latency
Increase rotational latency
第9题:
The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected, but these users must re-execute their queries.
The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected, and their queries execute successfully.
第10题:
demand among users for access to information anytime, anywhere
desire to use the same vender for desktop and server deployments
existing equipment has reached and of life
increasing operational costs of managing data centers
architectures that is inflexible and inefficient
selecting best-performing vendors for each individual component
第11题:
when performing export and import using Oracle Data Pump
when performing backup and recovery operations using Oracle Recovery Manager
when performing batch processing and bulk loading operation in a data warehouse environment
in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time
第12题:
Set a threshold for the default system-defined moving window baseline.
Add directives to the Automatic Database Diagnostic Monitor (ADDM).
Modify the profile for the targeted users for which control needs to be imposed.
Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
第13题:
Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement: SQL>ALTER TABLSPACE temp OFFLINE NORMAL; What is the result of this statement?()
第14题:
What are three common reasons why customers are saying that they need to evolve their datacenter?()
第15题:
A customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations. Which of the following questions will provide the information necessary to design the best performing storage solution?()
第16题:
Which two prerequisites are needed for performing workload capture and replay?()
第17题:
You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()
第18题:
While performing the backup of the datafile,data1.dbf,one backup set is created.
While performing the backup of the datafile,data1.dbf,two backup sets are created.
While performing the backup of the datafile,data1.dbf,three backup sets are created.
While performing the backup of the datafile,data1.dbf,the command for performing a backup of the datafile,data1.dbf,will fail.
第19题:
user managed complete recovery
user managed incomplete recovery
RMAN-based complete recovery
RMAN-based incomplete recovery
第20题:
Leave Maria in the local Administrators group. Limit her rights by using Local Policies.
Leave Maria in the local Administrators group. Change the NTFS provision on other users’ files to deny Maria’s request.
Remove Maria from the local Administrators group. Add her to both the Power Users group and Backup Operators group.
Remove Maria from local Administrators group. Add her to Power User group. Then grant her NTFS Read permission on the files to be backed up.
第21题:
by using triggers
by using external tables
by using anonymous PL/SQL blocks
by auditing all DML operations on the table
第22题:
16 users on the UC540 and 64 users on the UC560
32 users on the UC540 and 64 users on the UC560
32 users on the UC540 and 104 users on the UC560
16 users on the UC540 and 104 users on the UC560
第23题:
You cannot perform the TSPITR with the constraints enabled.
You must perform the TSPITR recovery of both tablespaces for it to be successful.
You can perform TSPITR only on the USERS tablespace.
RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
The TSPITR will only be successful if the constraint is enabled.
第24题:
$users[]=‘john’;
array_add($users,’john’);
array_push($users,‘john’);
$users[“name”]=‘john’;