问题：单选题The user SCOTT executes the following command successfully to increase the salary values in one of his sessions： SQL UPDATE emp SET sal=sal*1.15 WHERE deptno=20； Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes ...
查看答案
问题：单选题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...
问题：多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode， no operation on the tablespace will generat...
问题：单选题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...
问题：单选题In your database， the users SYS and SYSTEM have been assigned the profiles， ADMIN_PROF1 and ADMIN_PROF2， respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3. You create a profile， USER_PROF， and assign it to the a...
问题：Two database users， Jack and Bill， are accessing the Certkil...
问题：单选题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？（）...
问题：单选题You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use...
问题：单选题You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A Information about each Oracle Net connection.B Inform...
问题：单选题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...
问题：单选题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 have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for g...
问题：单选题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...
问题：单选题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 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...
问题：单选题One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A uses undo data for roll forwardB uses Flashback Log for recoveryC uses online redo logs to roll backD uses undo data to ro...
问题：多选题When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.co...
问题：多选题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...
