当前分类: Oracle认证考试
问题:Examine the details of the Top 5...
查看答案
问题:In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?()A、VARCHAR2B、CHARC、NVARCHAR2D、CLOBE、LONG...
问题:当ORACLE9.2数据库服务器安装后,将自动创建两个具有超级权限的用户,并且要求设定这两个用户的口令,这两个用户是()A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER...
问题:How is block-change&...
问题:You would like to display the sy...
问题:You executed the following command in Recovery Manager (RMAN): RMAN REPORT NEED BACKUP days 3; What is the output of this command?() A、 a list of files that require a backup within three daysB、 a list of files requiring more than 3 days of archive lo...
问题:You notice a performance change...
问题:You are performing&#...
问题:Which three statemen...
问题:When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?()A、The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUEB、The job will only be disabled if the value of the AUTO_DROP attr...
问题:You configured automa...
问题:Which two statements are true ab...
问题:In your test d...
问题: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...
问题: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...
问题:使用(),可以将某个SQL语句的执行依赖于另一个查询语句的执行结果。A、内连接查询B、子查询C、外连接查询D、合并查询...
问题:To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance t...
问题:对于以下SQL语句说法正确的是() SELECT ename ...