出自:Oracle认证

Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS.  The database is still running.  Which answer properly describes the rder of the steps that you would use to recover from this error?()   a. Shut down the database.  b. Take the users_01.dbf datafile offline with the alter database command.  c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database.  h. Bring the users_01.dbf datafile online with the alter database command. 
A:a, c, f, g
B:b, c, f, h
C:a, b, c, f, g
D:a, b, c, f, g, h
E:b, c, f, e, g
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them? ()
A:The two statements produce identical results.
B:The second statement returns a syntax error.
C:There is no need to specify DESC because the results are sorted in descending order by default.
D:The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?()
A:SELECT ename, salary*12 'Annual Salary' FROM employees;
B:SELECT ename, salary*12 "Annual Salary" FROM employees;
C:SELECT ename, salary*12 AS Annual Salary FROM employees;
D:SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()
A:increase the undo retention
B:create more undo segments
C:create another undo tablespace
D:increase the size of the undo tablespace
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?()  
A: SQL Access Advisor recommendations are automatically implemented.
B: Individual SQL Access Advisor recommendations can be scheduled for implementation.
C: All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D: SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
E: None of the above.
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:  SGA_TARGET= 10GB  SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario? ()
A: A maximum of 3 GB can be allocated to shared pool
B: The value for SGA_TARGET can be increased up to a maximum of 15 GB
C: A total of 14 GB memory will be allocated to the automatically tuned memory components.
D: Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE
E: Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F: Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()
A: You must use automatic undo management in the database.
B: You must configure OMF in your database.
C: You must configure ASM for storing the datafiles.
D: You must multiplex the online redo log file.
The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?()
A:WHERE lower(country_address) = "france"
B:WHERE lower(country_address) = 'france'
C:WHERE lower(country_address) IS 'france'
D:WHERE lower(country_address) = '%france%'
E:WHERE lower(country_address) LIKE %france%
You suspect unauthorized data manipulation language (DML) operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis.  How would you achieve this()
A:by using triggers
B:by using Data Pump
C:by using external tables
D:by using anonymous PL/SQL blocks
The database instance is currently using SPFILE. View the Exhibit and examine the error that youreceived while running the DB Structure Integrity check.    Given below are the steps to recover from the error in random order:  1: Shut down the instance, if not already done.  2: Copy one of the remaining control files to a new location.  3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.  4: Start up the database instance to the NOMOUNT stage.  5: Recover the database to the point of failure of the control file.  6: Open the database.  Identify the correct sequence of steps( ) 
A:1,2,4,3,5,6
B:2,4,3,5,6;1 not required
C:4,5,6,2,3;1 not required
D:5,2,3,4;1 and 6 not required
You work as a database administrator for Certkiller .com. As a result of performance analysis, you created an index on theprod_namecolumn of the  Certkiller prodtable, which contains about ten thousand rows. Later, you updated a product name in the table.  How does this change affect the index?()
A:A leaf will be marked as invalid.
B:An update in a leaf row takes place.
C:The index will be updated automatically at commit.
D:A leaf row in the index will be deleted and inserted.
E:The index becomes invalid when you make any updates
The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?()
A:Minimum widow records. 
B:Column mode. 
C:Spacing 
D:Print direction. 
E:Source F maximum records per page. 
F:Maximum records per page.
At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group deleted?()
A:When the user navigates to the HOTEL item. 
B:When the form module successfully compiles. 
C:After Form Builder validates the SELECT statement and dismisses the New Record Group dialog box. 
D:When the user enters data in the HOTEL item, and the Validate from List property for the HOTEL item is set to YES.
When backing up a replication slave, which three should also be backed up in addition to data?()
A:The master.info and relay.info files
B:The relay log files
C:The relay index file
D:Mysql.slave_master_info table
E:Mysql.slave_relay_log_info table
F:Mysql.slave_worker_info table
Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?()
A: PLSQL_BLOCK
B: JAVA_STORED_PROCEDURE
C: STORED_PROCEDURE
D: EXECUTABLE
E: None of the above are invalid settings.
Given: Which is true?()
A:If line 10 is removed, the compilation succeeds.
B:If line 11 is removed, the compilation succeeds.
C:If line 12 is removed, the compilation succeeds.
D:If line 13 is removed, the compilation succeeds.
E:More than one line must be removed for compilation to succeed.
An application that needs to use a shared library has a deployment descriptor that only specifies the Specification-Version and Extension-Name of the shared library. When the application is deployed, which shared library will be used?()
A:The application will go into an ADMIN state and fail to deploy because the Implementation- Version is required.
B:The application will be deployed but the classes in the shared library will not be available.
C:If you are using the WebLogic Admin Console, you will be prompted for the version you want to  use; otherwise, the application will fail to deploy.
D:If there are multiple versions of the shared library deployed, WebLogic will use the one with the highest Implementation-Version.
E:If there are multiple versions of the shared library deployed, WebLogic will use the one that was  deployed most recently.
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? ()
A:INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
B:INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
C:INSERT INTO employees VALUES ( '1000', 'John', NULL);
D:INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
E:INSERT INTO employees (employee_id) VALUES (1000);
F:INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
Which three menu item types are valid in a menu module?()
A:Magic 
B:Plain 
C:Check 
D:List item 
E:Divider
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?()
A:Use the DESCRIBE command in the EMP_DEPT VU view.
B:Use the DEFINE VIEW command on the EMP_DEPT VU view.
C:Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
D:Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
E:Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
F:Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
ou have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog? ()
A:synch catalog 
B:resync catalog
C:replicate catalog 
D:update catalog  
E:restore catalog
In which scenario will you perform a cancel-based recovery?()
A: when a tablespace is dropped and you have only RMAN-based backup of the database
B: when a table is dropped and stored in the Recycle Bin
C: when you are required to recover an existing table to its previous state
D: when a tablespace is dropped and you have only a user-managed full backup of the database
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation?()
A:The databases configured to use the ASM instance are mounted
B:The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
C:ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
D:ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
A customer needs to analyze an application that was developed for Oracle Application Server 10gR2 or 10gR3 (OC4J) in order to prepare to upgrade the infrastructure to WebLogic 12c. The customer wants understand the changes required to be made to the application and how to configure WebLogic in to support the newly upgraded application.    Which three actions would you recommend for upgrading the customer's application and server configuration?()
A:Use Oracle Upgrade Manager to create a new WebLogic domain template from an OAS/OC4J  installation and redeploy the application.  
B:Use SmartUpgrade to analyze the OAS/OC4J server configuration and create WebLogic  configuration files.  
C:Use SmartUpgrade to analyze the application archive (EAR/WAR/JAR) Source Directory or IDeveloper project and generate a report that describes the areas of the application that need to be updated.  
D:Use the Configuration Wizard to extend an existing WebLogic domain with OAS/OC4J support  libraries and redeploy the application.  
E:Use SmartUpgrade to generate application artifacts and deployment descriptors that can be deployed to WebLogic.
Given: What is the result?()
A:Compilation fails.
B:An exception is thrown at runtime.
C:The attribute id in the ItemTest object remains unchanged.
D:The attribute id in the ItemTest object is modified to the new value.
E:A new ItemTest object is created with the preferred value in the id attribute.
You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body.  Whichstatement is true after you recompile the EMP_ADMIN package body()
A:The USE_P procedure remains valid.
B:The USE_P procedure becomes invalid.
C:The SHOW_DETAIL procedure becomes invalid.
D:The EMP_ADMIN package specification becomes invalid and needs to be recompiled
In what order would you execute the following steps to create a recovery catalog?() a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the recovery-catalog user.  e.Issue the register database command from the target database.
A:a,b,c,d,e
B:b,a,d,c,e
C:b,c,d,a,e
D:b,c,d,e,a
E:b,d,c,a,e
ORACLE网络侦听器位于()
A:ORACLE客户端
B:ORACLE服务器端
C:ORACLE客户端和服务器端
D:ORACLE的中间层服务器端
E:以上所述都不正确
You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use?()  
A: alter tablespace MY_DATA begin backup
B: alter tablespace MY_DATA start backup
C: alter tablespace MY_DATA backup begin
D: alter MY_DATA begin backup
E: You cannot back up individual tablespaces
Matthew has recently joined NetFx Corporation as a junior-level Database Administrator (DBA). He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database.   What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks?() 
A: datafile
B: alert log
C: dynamic views
D: control file script