You are working on&#...

单项选择题You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）

A.Perform point-in-time recovery to 2： 00 p.m.
B.Use Flashback Table feature to revert the changes.
C.Restore the entire database from the recent backup and open it.
D.Issue the rollback statement with system change number （SCN）.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Your test database is running in NOARCHIVELOG mode. What are the implications of this？（）

A.You can perform open database backups.
B.You can perform closed database backups.
C.You cannot perform schema-level logical backups.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.

点击查看答案

2.单项选择题The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task？（）

A.implementing value-based auditing by using triggers
B.implementing fine-grained auditing with audit condition and event handler
C.performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
D.performing standard database auditing to audit SQL statements with granularity level set to ACCESS

点击查看答案

3.单项选择题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 script
B.PL/SQL script
C.Operating System （OS） script
D.Enterprise Manager （EM） script
E.Recovery Manager （RMAN） script

点击查看答案

4.单项选择题 You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis.
How would you achieve this？（）

A.by using triggers
B.by using external tables
C.by using anonymous PL/SQL blocks
D.by auditing all DML operations on the table

点击查看答案

5.单项选择题As a result of performance analysis， you created an index on the prod_name column of the prod_det table， 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.

点击查看答案

6.多项选择题Which two statements about Flashback Query are true？（）

A.It is generated by using the redo log files.
B.It helps in row-level recovery from user errors.
C.It can be performed to recover ALTER TABLE statements
D.It fails when undo data pertaining to the transaction is overwritten.
E.The database has to be opened with the resetlogs option after performing Flashback Query.

点击查看答案

7.单项选择题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

A.configure the database to run in ARCHIVELOG mode
B.configure the Flash Recovery Area to enable automatic database backup
C.schedule the database backup using DBMS_JOB package after creating the database
D.schedule the database backup using Recovery Manager （RMAN）commands after creating the database
E.schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

点击查看答案

8.单项选择题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 on to the database to continue his work. ORA-02392： exceeded session limit on CPU usage， you are being logged off Which action would you take to increase the session limit on CPU usage？（）

A.Modify the profile assigned to the user.
B.Modify the roles assigned to the users.
C.Modify the object privileges assigned to the user.
D.Modify the system privileges assigned to the users.
E.Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

点击查看答案

9.单项选择题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）

A.Configure Java Pool to cache the java objects.
B.Configure Streams Pool to enable parallel processing.
C.Increase Shared Pool size to cache more PL/SQL objects.
D.Increase Database Buffer Cache size to increase cache hits.
E.Configure Large Pool to be used by RMAN and shared server.
F.Increase the total System Global Area （SGA） size to increase memory hits.

点击查看答案

10.单项选择题Which is the correct description of the significance of the ORACLE_HOME environmental variable？（）

A.It specifies the directory containing the Oracle software.
B.It specifies the directory containing the Oracle-Managed Files.
C.It specifies the directory for database files， if not specified explicitly.
D.It specifies the base directory of Optimal Flexible Architecture （OFA） .

点击查看答案