当前分类： Oracle认证考试
问题：You need to perform certain data...
查看答案
问题：Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement e...
问题：You support Oracle Database 12c...
问题：假设用户user1的temp1表分区为PART1、PART2和P...
问题：当ORACLE9.2数据库服务器安装后，将自动创建两个具有超级权限的用户，并且要求设定这两个用户的口令，这两个用户是（）A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER...
问题：声明%TPYE类型的变量时，服务器将会做什么操作？（）A、为该变量检索数据库列的数据类型B、复制一个变量C、检索数据库中的数据D、为该变量检索列的数据类型和值...
问题：Which is the c...
问题：The SQL Tuning Advisor configur...
问题：Records from theQ...
问题：You configured automa...
问题：You notice a performance change...
问题：Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold fo...
问题：Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database...
问题：Examine the details of the Top 5...
问题：Which two statements are true ab...
问题：The online redo̳...
问题：What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with t...
问题：A data manipulation language sta...
问题：In your test d...
问题：对于以下SQL语句说法正确的是（） SELECT ename ...
