摘要：
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 阅读全文
posted @ 2017-12-14 18:35
巴啦啦大魔王
阅读(195)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 18:30
巴啦啦大魔王
阅读(139)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 18:11
巴啦啦大魔王
阅读(110)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 18:05
巴啦啦大魔王
阅读(183)
评论(0)
推荐(0)
摘要：
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) 阅读全文
posted @ 2017-12-14 18:02
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 17:59
巴啦啦大魔王
阅读(133)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 17:56
巴啦啦大魔王
阅读(134)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 17:53
巴啦啦大魔王
阅读(130)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 17:46
巴啦啦大魔王
阅读(135)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 15:54
巴啦啦大魔王
阅读(139)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 15:50
巴啦啦大魔王
阅读(80)
评论(0)
推荐(0)
摘要：
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: 阅读全文
posted @ 2017-12-14 14:57
巴啦啦大魔王
阅读(117)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 14:52
巴啦啦大魔王
阅读(87)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 14:46
巴啦啦大魔王
阅读(113)
评论(0)
推荐(0)
摘要：
The database instance has the following parameter setting:OS_AUTHENT_PREFIX = OPS$OS_ROLES = FALSEREMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSETIME 阅读全文
posted @ 2017-12-14 14:40
巴啦啦大魔王
阅读(180)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 14:31
巴啦啦大魔王
阅读(104)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 14:24
巴啦啦大魔王
阅读(160)
评论(0)
推荐(0)
摘要：
You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100MSEGMENT SPACE MANAGEME 阅读全文
posted @ 2017-12-14 14:14
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-12-14 13:51
巴啦啦大魔王
阅读(110)
评论(0)
推荐(0)
摘要：
View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block s 阅读全文
posted @ 2017-12-14 13:47
巴啦啦大魔王
阅读(157)
评论(0)
推荐(0)
摘要：
Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)A.when the tablespace is onlineB.when the tablespace has 阅读全文
posted @ 2017-12-14 13:41
巴啦啦大魔王
阅读(134)
评论(0)
推荐(0)
摘要：
Examine the commands executed in a DBA session:SQL> CREATE BIGFILE TABLESPACE MRKT2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING3 阅读全文
posted @ 2017-12-14 13:40
巴啦啦大魔王
阅读(96)
评论(0)
推荐(0)
摘要：
You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effec 阅读全文
posted @ 2017-12-14 13:32
巴啦啦大魔王
阅读(154)
评论(0)
推荐(0)
摘要：
You execute a command to resize a data file, sales.dbf, of size 200 MB in your database:ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M;Which 阅读全文
posted @ 2017-12-14 13:27
巴啦啦大魔王
阅读(146)
评论(0)
推荐(0)
摘要：
--关联查询时爆了a.id无效然后测试了一下 --错误 select a.id, b.id, c.id from t1 a ,t2 b left join t3 c on c.id=a.id where a.id=b.id --正确 select a.id, b.id, c.id from t1 a left join t3 c on c.id=a.id , t2 b where a... 阅读全文
posted @ 2017-12-14 10:43
巴啦啦大魔王
阅读(130)
评论(0)
推荐(0)
摘要：
a、row_number() over() row_number()over(partition by col1 order by col2)表示根据col1分组，在分组内部根据col2排序，而此函数计算的值就表示每组内部排序后的顺序编号（组内连续的唯一的）。 与rownum的区别在于：使用rown 阅读全文
posted @ 2017-12-14 09:50
巴啦啦大魔王
阅读(184)
评论(0)
推荐(0)
浙公网安备 33010602011771号