ocp考試052最新考試題庫原題-10-20xx0810【整理版】-文庫吧
2025-03-09 05:01 本頁面
【正文】 stance. B) User1 can create in the EXAMPLE tablespace. C) User1 must change the password at ?rst login.D) User1 can grant the CREATE SESSION privilege to other users.
E) User1 can grant the CREATE TABLE privilege to other users.
F) User1 can REVOKE the CREATE TABLE privilege from users that were granted the
privilege by SYS .G) User1 can REVOKE the CREATE SESSION privilege from users that were granted the
privilege by SYS .Answer: ABEF52. IN one of your databases。The database default tablespace is EXAMPLE.
DEFERRED_SEGMENT_CREATION IS FALES.
Examine these mands。SQL.CREATE USER user1 IDENTIFIED BY oracle_4U
password expire。 User created.
SQLALTER USER user1 ACCOUUNT UNLOCK。
User altered.SQLGRANT CREATE SEAAION TO user1。
Grant succeeded。SQLGRANT CREATE TABLE TO user1 WITH ADMIN OPTION。
Grant succeeded.Which three are true?A) USER1 can create indexes in EXAMPLE tablespace
B) USER1 can grant the CREATE TABLE privilege to other users
C) USER1 can log into the database instanceD) USER1 must change it’s password at ?rst loginE) USER1 can create tables in the EXAMPLE tablespace Answer：BCD53. IN one of your databases。? The database default tablespace is EXAMPLE.
? DEFERRED_SEGMENT_CREATION IS FALSE.
Examine these mands。SQL CREATE USER user1 IDENTIFIED BY oracle_4U。 User
created.SQLGRANT CREATE SESSION TO user1。
User alteredWhich two are true?A) USER1 can create tables in EXAMPLE tablespace
B) USER1 must change their password at ?rst login
C) USER1 can create tables in the EXAMPLE tablespace
D) USER1 can be granted access to tables in other schemas
E) USER1 can log in to the database instance.
Answer：DE54. You have decided to implement the principle of least privilege and
separation of duties. Which two actions must you take?
A) Grant SYSOPER to application schema owners.
B) Grant access to the Oracle software owner O/S account to all database
administrators. C) Assign the OSOPER and OSDBA groups to the Oracle software owner
O/S account. D) Assign different O/S groups to the OSOPER and OSDBA credentials.
E) Assign the DBA role to application schema owners.Answer：CD55. Examine these facts about a database:1. USERS is the database default tablespace.2. USER1 and USER2 have the CREATE SESSION privilege.3. They also have UNLIMITED QUOTA on the USERS tablespace.
Examine these mands:SQL conn / as sysdba Connected.SQL GRANT CREATE TABLE TO USER1 WITH ADMIN OPTION。 Grant
succeeded.SQL GRANT CREATE VIEW TO USER1 WITH ADMIN OPTION。 Grant
succeeded.SQL GRANT CREATE MATERIALIZED VIEW TO USER1 WITH ADMIN OPTION。 Grant succeeded. SQL GRANT CREATE MATERIALIZED VIEW TO USER2 WITH ADMIN OPTION。 Grant succeeded. SQL conn user1/oracleConnected.SQL GRANT CREATE TABLE TO USER2 WITH ADMIN OPTION。
Grant succeeded.SQL GRANT CREATE VIEW TO USER2 WITH ADMIN OPTION。
Grant succeeded. SQL conn / as sysdba Connec
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號-1