170+ câu trắc nghiệm Cơ sở dữ liệu Oracle có đáp án - Phần 1

LogMiner

Import

Metadata Viewer

Oracle Flashback

The cursor sharing feature can re-use a SQL statement even if the columns in the statement are in a different order or the GROUP BY clause is different

The new columns CPU_COST, IO_COST, and TEMP_SPACE in PLAN_ TABLE help the rule-based optimizer (RBO) to be more accurate

Thậm chí nếu chỉ có 1 sự khác nhau trong câu lệnh SQL là trong giá trị kí tự, câu lệnh SQL có thể ko được tái sử dụng nếu số liệu thống kê trong quá khứ bị xuyên tạc cho cột trong mđề WHERE

The CURSOR_SHARING parameter now supports the SIMILAR and DERIVED values

TRANS_START - TRANS_END

TO_TIMESTAMP(AMOUNT, ‘YY-MM-DD HH:MI:SS’)

TRANS_START + INTERVAL „4‟ DAY

TRANS_START + SHIP_DATE

NLS_CHARACTERSET

NLS_SORT

NLS_NCHAR_CHARACTERSET

NLS_TERRITORY

V$DATABASE

NLS_DATABASE_PARAMETERS

NLS_INSTANCE_PARAMETERS

NLS_SESSION_PARAMETERS

ALTER USER

ALTER ROLE

SET ROLE

SET PRIVILEGE

John is assigned all the roles created in the database

Future roles granted to John will not be default roles

All of John‟s roles are enabled, except the roles with passwords

Tất cả các ROLE của John được bật khi anh ấy kết nối CSDL

ALTER ROLE

ALTER USER

SET ROLE

ALTER SESSION

SYSDBA

CONNECT

IMP_FULL_DATABASE

RESOURCE

GRANT SELECT ON CUSTOMER TO ALL USERS

GRANT ALL ON CUSTOMER TO ALL

GRANT SELECT ON CUSTOMER TO ALL

GRANT SELECT ON CUSTOMER TO PUBLIC

DBA_SYS_PRIVS

DBA_TAB_PRIVS

DBA_PROC_PRIVS

SESSION_PRIVS

SELECT

UPDATE ANY

EXECUTE ANY

CREATE TABLE

WITH GRANT OPTION

WITH ADMIN OPTION

CASCADE

WITH MANAGE OPTION

DBA_SYS_PRIVS

DBA_USER_PRIVS

DBA_ROLE_PRIVS

DBA_TAB_PRIVS

No more rows can be added to the JOBS table.

No blocks can be allocated to the JOBS table.

Không có extent mới có thể cấp phát cho table JOBS.

The table JOBS cannot be accessed

DEFAULT TABLESPACE

UNLIMITED TABLESPACE

QUOTA

PROFILE

DBA_PROFILES

DBA_USERS

DBA_PASSWORDS

V$SESSION

PASSWORD_REUSE_TIME

PASSWORD_REUSE_MAX

PASSWORD_LIFE_TIME

PASSWORD_REUSE_DAYS

CPU_PER_SESSION

CONNECT_TIME

PASSWORD_LOCK_TIME

All the above

Oracle prompts you for a profile name.

No profile is assigned to the user.

Profile DEFAULT đƣợc gán.

The SYSTEM profile is assigned.

1

2

32

Unlimited

Oracle creates a profile named DEFAULT when the database is created

Profiles cannot be renamed

DEFAULT is a valid name for a profile resource

Nguồn SESSIONS_PER_USER trong profile DEFAULT có gtrị khởi tạo là 5

PRIVATE_SGA

CPU_PER_SESSION

CONNECT_TIME

LOGICAL_READS_PER_CALL

ALTER PROFILE

ALTER USER

SET PROFILE

The profile should be specified when creating the user; it cannot be changed

CPU time used

Total time connected to the database

Maximum time a session can be inactive

Thời gian đọc các khối