ITPub博客

（166）View the Exhibit and examine the setting for a table.Which statement is true about the PCTFREE setting for the table?A. It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.B. It sets the minimum percentage of a data block to be res...

（165）You have an ORDERS table with the following structure:The table has data in the ODATE column for all rows. Many orders are placed in a single day.You need to ensure that the ODATE column must contain data for every order in future.Which method would serve the purpose?A. Mod...

（164）Examine the command that is used to create a table:SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oamt NUMBER(10,2)) TABLESPACE users;Which two statements are true about the effect of the above command? (Choose two.)A. A CHECK constraint is created...

（163）You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.Which data type would you use for the new column?A. CLOBB. BLOBC. BFILED. LONG RAW答案：（C）...

（162）You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile.Some user sessions are currently connected to the database instance and are using the APP_USER profile.This command is used to drop the profile:SQL> DROP PROFILE app_user; Whi...

（161）In your database instance, the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users:1: The user account must be locked after four unsuccessful login attempts.2: The user must be prompted to change the password...

（160）View the Exhibit to observe the roles assigned to the SLP_REP user.Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REP user?A. The user must enable the role explicitly.B. The user can grant the role to other users.C. The user cannot use...

（159）View the Exhibit and examine the user information.The user has been granted CONNECT and RESOURCE roles and no individual system privileges.The SL_REP user executes this command to create a table:SQL> CREATE TABLE orders(oid number(6), odate date, ccode number(4), oamt number(10,2)) ...

（158）You want to create a role to meet these requirements:1: The role is to be protected from unauthorized usage.2: The password of the role is not to be embedded in the application source code or stored in a table.Which method would you use to restrict enabling of such roles?A. Cre...

（157）Examine the commands executed in the following sequence:1: SQL> CREATE ROLE mgrrole;2: SQL> GRANT create user,select any table,connect,resource TO mgrrole;3: SQL> GRANT select,update ON sh.sales TO mgrrole;4: SQL> CREATE ROLE ceo IDENTIFIED BY boss;5: SQL> GRANT mgrrole,dro...

（156）Examine the following steps performed on a database instance:1: The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.2: The SKD user creates a table.3: The SKD user grants the CREATE TABLE system privilege to the HR user.4: The HR user creates a ta...

（155）The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION;The user SCOTT executes this command to grant privileges to the user JIM: SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO...

（154）View the Exhibit and examine the privileges granted to the MGR_ROLE role.The user SKD has been granted the CONNECT and RESOURCE roles only.The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command:SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;Which...

（153）The database instance has the following parameter setting:OS_AUTHENT_PREFIX = OPS$OS_ROLES = FALSEREMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSETIMED_OS_STATISTICS = 0You have a local operating system user SKD. You create a database user OPS$SKD, and then assign exter...

（152）Examine the command:SQL> ALTER USER skd ACCOUNT LOCK;Which two statements are true after the command is executed? (Choose two.)A.The SKD user cannot log in to the database instance.B.The objects owned by the SKD user are not accessible to any user.C.The other users can acce...

（151）View the Exhibit1, which shows the options that are selected to create the user SL_REP.View the Exhibit2 and examine the contents of DATABASE_PROPERTIES.  Which two statements are true regarding this user? (Choose two.)A.The user is authenticated by the operating syste...