多项选择题
Which statements are true about logical structures of the Oracle database（）
A.Each segment contains one or more extents.
B.Multiple tablespaces can share a single data file
C.A data block is the smallest unit of input/output （I/O） in data files.
D.It is possible to have tablespaces of different block sizes in a database.
E.Each data block in the database always corresponds to one operating system block
相关考题
-
多项选择题
Whichstatementsregardingtheserverparameterfile（SPFILE）aretrue（）
A.An SPFILE is a binary file.
B.An SPFILE cannot reside on a client.
C.An SPFILE cannot contain static parameters.
D.An SPFILE can store changes persistently across instance restarts.
E.An SPFILE can be read by the database server， but it is not written to by the server.
F.An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database -
单项选择题
Which statement is true about loading data using the conventional path of SQL*Loader（）
A.Redo is not generated while performing conventional path loads.
B.Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
C.No exclusive locks are acquired when the conventional path loads are performed.
D.Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
E.INSERT triggers are disabled before the conventional path load and reenabled at the end of the load -
多项选择题
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）
A.LOCK TABLE emp IN SHARE MODE；
B.LOCK TABLE emp IN EXCLUSIVE MODE；
C.UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
D.INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
E.SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
