随笔分类 - ocp-其他
摘要：A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable
阅读全文
摘要：You execute this command to drop the ITEM table, which has the primary key referred in the ORDERtable:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS P
阅读全文
摘要：Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)A.The corresponding indexes for the table ar
阅读全文
摘要：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
阅读全文
摘要：You have an ORDERS table with the following structure:Name Null? Type OID NUMBER(6)ODATE DATECCODE NUMBER(6)OAMT NUMBER(10,2)The table has data in the
阅读全文
摘要：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)
阅读全文
摘要：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 achie
阅读全文
摘要：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
阅读全文
摘要：In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for thes
阅读全文
摘要：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 th
阅读全文
摘要：View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCE roles and no individual system privileges. The SL_RE
阅读全文
摘要：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 e
阅读全文
摘要：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 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
阅读全文
摘要：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 datab
阅读全文
摘要：The database instance has the following parameter setting:OS_AUTHENT_PREFIX = OPS$OS_ROLES = FALSEREMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSETIME
阅读全文
摘要：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_PROPERT
阅读全文
摘要：The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in ta
阅读全文
摘要：You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100MSEGMENT SPACE MANAGEME
阅读全文
摘要：View the Exhibit. Which statements are true regarding the USERS tablespace? (Choose all that apply.)A.A bitmap is used to record free extents.B.Free e
阅读全文
浙公网安备 33010602011771号