多項(xiàng)選擇題

Exhibit：
View the Exhibit to see the data in the emp table.
You created a PRIMARY KEY constraint on the empno column of the emp table， and the constraint is not deferred. Which two statements are true in this scenario？（）

A.No index would be created or used in this case.
B.A unique index on the empno column would be created.
C.A CHECK constraint would be enforced on the empno column.
D.A NOT NULL constraint would be enforced on the empno column.
E.A bitmap unique index would be created on the empno column.

你可能感興趣的試題

多項(xiàng)選擇題

You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.
The data should be spread across two data files.
A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）

A.set PCTFREE and PCTUSED to 50
B.specify extent allocation as Uniform
C.specify extent allocation as Automatic
D.create the tablespace as bigfile tablespace
E.create the tablespace as smallfile tablespace
F.set segment space management to Automatic
G.use the RESIZE clause while creating the tablespace

單項(xiàng)選擇題

In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

A.flash back the database
B.perform point-in-time recovery
C.perform a full database recovery
D.drop and re-create the tablespace
E.use Recovery Manager （RMAN） to recover the database

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Exhibit： View the Exhibit to see the data in the emp table. You created a PRIMARY KEY constraint on the empno column of the emp table， and the constraint is not deferred. Which two statements are true in this scenario？ （）

你可能感興趣的試題

In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Exhibit：
View the Exhibit to see the data in the emp table.
You created a PRIMARY KEY constraint on the empno column of the emp table， and the constraint is not deferred. Which two statements are true in this scenario？（）

In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）