当前分类: 1Z0-042
问题:单选题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 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 work as a database administrator for Certkiller .com. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metr...
问题:多选题You work as a database administrator for Certkiller .com. Your listener process, L1,is currently listening to three databases:CertK INDB04,Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant (DBCA) you create one more database,C...
问题:单选题Which two operations can be flashed back using the Flashback technology? ()A DROP USER SMITH;B DROP TABLE EMPLOYEES;C DROP TABLESPACE USERS;D ALTER TABLE SALES_REP DROP PARTITION P1;E ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;...
问题:单选题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 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?()...
问题:In your database, UNDO_RETENTION has been set to 600 sec and...
问题:单选题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 ...
问题:You want to move all the objects of the APPS user in the tes...
问题:多选题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...
问题:多选题In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()AThe database instance aborts.BThe database operation temporarily h...
问题:单选题The operating system file cratab in the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file?()A OracleSIDsonlyB Oracle homes onlyC Oracle install timestampD ...
问题:单选题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...
问题:You work as a database administrator for Supportcenter.cn. Y...
问题:多选题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...
问题:Your boss at Certkiller .com wants you to clarify Oracle 10g...
问题:多选题Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file?()Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespac...
问题:单选题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...
问题:单选题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...