Oracle认证考试
单选题Examine the following commands and their output: SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 1050 QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES'; 1 row updated. SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 2310 View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?()
单选题What view might you use to try to determine how long a particular backup will take?()
单选题Which statement is true regarding subqueries?()
单选题Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?()
单选题Evaluate the following block of code: What is the outcome of the above code?()
单选题Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?()
单选题What is the outcome of this block of code?()
单选题You want to set the following initialization parameters for your database instance: Identify the statement that correctly describes this setting.()
单选题Your archive-log destination directory runs out of space. What is the impact of this on the database?()
单选题Which statement about recovering from the loss of a redo log group is true?()
多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
多选题Which Scheduler view(s) can be queried to see which jobs are currently executing? ()
单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()
单选题An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?()
单选题After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?()
单选题Case-insensitive sorts are always accent insensitive by default.()
单选题Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()
单选题A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: What happens when the whole CONTROLLER1 Failure group is damaged?()
单选题On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? ()
当前列表仅展示前20条试题,搜“题王”小程序查看更多考题~