问题:单选题Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A The database is in mount state.B One of the tablespaces is offline.C One of the tablespaces is read only.D...
查看答案
问题:多选题You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()AAll control files are open...
问题:多选题You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, Certkiller, asks you to retrieve the lost...
问题:单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables...
问题:单选题You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?()A SQL scriptB PL/SQL scriptC Operating System (OS) scriptD Enterprise Manager (EM) scriptE Re...
问题:单选题The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, worklo...
问题:单选题You want to set up the Oracle Database 10g installation to follow the French language, with France as the territory, and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective?()...
问题:单选题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning,media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this sit...
问题:单选题You are connecting to an Oracle database server from a client by using the following connect string: SQL CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb Which naming method is being used in this case?()A Local NamingB Easy ConnectC External NamingD ...
问题:单选题Initially, for the Automatic Workload Repository (AWR) statistics,the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory...
问题:单选题You executed the following command in the lsnrctl utility to stop the listener: lsnrctl STOP L1 What is the effect of this command if L1 is the only listener configured for your database?()A It terminates all user sessions.B It prevents users from log...
问题:多选题You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()AAll control files are ope...
问题:Your database is functional with peak load for one hour. You...
问题:单选题A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work. ORA-02392:exceeded session limit on CPU usage,yo...
问题:You work as a database administrator for Supportcenter.cn. Y...
问题:单选题You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you received the following error: ERROR: ORA-12541:TNS:no_listener You found that the listener is not running on the server, so you issued the f...
问题:Your database is configured in NOARCHIVELOG mode. All the co...
问题:You work as a database administrator for Certkiller .com. Us...
问题:单选题You execute the following command to audit the database activities: SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?()A One audit record is created for the whole session if user SCOTT successfully...
问题:单选题While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software, you are prompted to run orainstRoot.sh script. What does this script accomplish?()A It creates the pointer file.B It creates the base directory.C I...