当前分类： Oracle认证考试
问题：层次查询是针对数据之间的层次关系提供的一种查询机制。Oracle Database 10g提供了层次查询的功能，用户可以利用层次查询，检索层次结构数据。为了执行层次查询，需要在select语句中添加（）。A、JOIN子句B、START WITH子句和CONNECT BY子句C、GROUP BY子句D、ORDER BY子句...
查看答案
问题：下列关于PL/SQL的说法正确的是（）A、PL/SQL是应用于各种数据库上的通用语言B、PL/SQL是过程化的SQL语言C、PL/SQL是只能在SQL*PLUS中运行D、在PL/SQL可以直接执行所有的SQL操作...
问题：Which statement describes the RO...
问题：当需要描述一个表table1对象结构时，可以使用（）。A、DES table1B、DESC table1C、DESCR table1D、DESCRIB table1...
问题：根据不同的需要，可对数据库服务器进行相应的启动方式，当以STAR...
问题：In user-managed back...
问题：Users are performing&...
问题：Given the following directory st...
问题：You are working̳...
问题：Note the points about data dictionary views and dynamic performance views： 1.These are stored in the SYSTEM tablespace. 2.These are the based on the virtual tables. 3.These are owned by the SYSuser. 4.These can be queried by a normal user only if O7_D...
问题：The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER (4) NOT NULL CUSTOMER_NAME VARCHAR2 (100) NOT NULL STREET_ADDRESS VARCHAR2 (150) CITY_ADDRESS VARHCAR2 (50) STATE_ADDRESS VARCHAR2 (50) PROVINCE_ADDRESS VARCHAR2 (50) COUNTRY_ADDRESS VARCHAR2 (50) ...
问题：How would you ...
问题：In WebLogic 10.3.6&#...
问题：数据库必须拥有至少几个控制文件（）A、1B、2C、3D、4E、由初始参数指定...
问题：You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA f...
问题：Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）A、An error is generated.B、You will have two identical tables in the HR schema with different names.C、You create a table called employees in the HR sc...
问题：You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A、Information about each Oracle Net connection.B、Informati...
问题：Evaluate this SQL statement: SE...
问题：Which of the f...
问题：You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February ...
