更多"[简答题]create procedure xxk2 as"的相关试题:
[简答题] create procedure xxk1
as
begin
select *
from students x,score y
where x.学号=y.学号
end
[简答题]create procedure xxk3
as
begin
select 学号,avg(成绩) as 平均成绩
from score
group by 学号
end
[简答题]create procedure xxk4
(
@a char(8),@b varchar(10),@c numeric(5,2)
)
as
begin
update score
set 成绩=@c
where 学号=@a and 课程名=@b
end
[简答题]create procedure xxk6
(
@a char(8),@b varchar(10)
)
as
begin
delete from score
where 学号=@a and 课程名=@b
end
[简答题]create procedure xxk5
(
@a char(8),@b varchar(10),@c numeric(5,2)
)
as
begin
insert into score
values(@a,@b,@c)
end
[单选题]"在Oracle中,用下列语句定义了一个过程:CREATE PROCEDURE proc(value1 IN VARCHAR2, value2 OUT NUMBER, value3 IN OUT VARCHAR2) IS BEGIN … END; 假定使用的变量v1/v2/v3都已经定义,下面对过程proc的调用语法正确的是" ( )
A. proc('tt', 10, v3 )
B. proc ('tt', v2, v3 )
C. proc ( v1, v2, ‘dd’ )
D. proc ('tt', 10,'dd')
[单选题]对于国内机场的离场程序而言,如果没有另外公布,程序设计梯度(PDG:PROCEDURE DESIGN GRADIENT)规定为
A.0.04
B.0.025
C.0.02
D.0.033
[不定项选择题]Choose the best answer
You want to create a duplicate database
DUP_DB from your production database PROD on the same host. The PROD
Database uses Automatic Storage Management (ASM) for storage.
Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE
DATABASE;
What is a prerequisite for the successful execution of this command
A. RMAN must be connected to the target database instance and the auxiliary
Instance.
B. A most recent backup set of the PROD database must exist.
C. Flashback must be enabled for the PROD database.
D. The target database must be in MOUNT state.
[单选题]下列哪个CREATE TABLE语法是有效的( )
A. CREATE TABLE emp9$# (emp_no NUMBER (4));
B. CREATE TABLE 9emp$# (emp_no NUMBER(4));
C. CREATE TABLE emp*123 (emp_no NUMBER(4));
D. CREATE TABLE emp9$# (emp_no NUMBER(4), date DATE);
[单选题]使用CREATE TABLE语句创建数据表时( )。
A.A. 必须指明数据表的所有者
B.B. 必须指定表所属的数据库
C.C. 指定的所有者和表名称组合起来在数据库中必须唯一
D.D. 省略数据表名称时,则自动创建一个本地临时表
[不定项选择题]choose one You want to create a test database as a replica of your
Production database with minimum intervention from a DBA. Which method
Would you use?
A.
Use DBCA to create a template from the existing database to contain the
Database structure with data files and then use the same template to create the
Database in the new location.
B.
Use Database Configuration Assistant (DBCA) to create a template from the
Existing database to contain the database structure.
C.
Use DBCA to create a template from the existing database to contain the
Database structure and then manually copy the data by using Oracle Data Pump.
D.
Create the database by using the CREATE DATABASE . . . command and
Manually import data by using Data Pump.
[不定项选择题]You plan to create a database by using the Database Configuration
Assistant (DBCA), with the following specifications: Applications will connect
To the database via a middle tier. The number of concurrent user
Connections will be high. The database will have mixed workload, with the
Execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?
A.
a General Purpose database template with default memory allocation
B.
a Data Warehouse database template, with t he dedicated server mode option
And AMM enabled
C.
a General Purpose database template, with t he shared server mode option
And Automatic Memory Management (AMM) enabled
D.
a default database configuration
[不定项选择题]You create a table with the PERIOD FOR clause to enable the use of the
Temporal Validity feature of Oracle Database 12c. Examine the table
Definition: create table employees (empno number, salary number, deptid
Number, name varchar2(100), period for employee_time); Which three
Statements are true concerning the use of the Valid Time Temporal feature
For the EMPLOYEES table?
A. The valid time columns employee_time_start and employee_time_end are
Automatically created.
B.Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusin
Gthe AS OF TIMESTAMP and PERIOD FOR clauses.
C. The valid time columns are not populated by the Oracle Server automatically.
D. The valid time columns are visible by default when the table is described.
E. Setting the session valid time using
DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data
Manipulation language (DML), data definition language (DDL), and queries
Performed by the session.
[不定项选择题]Examine these actions:
1-Create a new database for a recovery catalog.
2-Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3-Configure ARCHIVE LOG mode for the catalog database.
4-Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.
5-Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
6-Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing
The CREATE CATALOG command?
A.
2, 4, 5, 6
B.
1, 2, 3, 4, 5, 6
C.
1, 2, 4, 5
D.
2, 4, 5
E. 1, 3, 4, 5
[简答题]Only by (create)____a clean environment can we truly encourage more tourists to come.(5.0)
[单选题] 默认情况下,root用户CREATE USER创建的用户具有( )权限。
A.PROXY
B.SELECT
C.SHOWDATABASES
D.USAGE
[单选题]"查看下面的语句创建了哪一种索引? CREATE INDEX test index ON student(stuno, sname) TABLESPACE users STORAGE(initial 64k, next 32k);" ( )
A. 全局分区索引
B. 位图索引
C. 复合索引
D. 基于函数的索引
[单选题] CREATE TABLE与( )一起使用可为新表复制已有的表结构。
A.AS
B.IS
C.LIKE
D.以上的答案都不正确
[单选题]执行下面语句:1.create table t1(a int,b int);2.insert into t1 values(1,1);3.commit;4.savepoint s1;4.savepoint s1;
A.两条记录(1,1)和(2,3)
B.一条记录(1,1)
C.一条记录(2,3)
D.没有记录