单项选择题
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 reserved as free space before the server prevents inserts into the block.
C.It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
D.It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
多项选择题 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) ()
单项选择题 You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column()
单项选择题 You created a profile APP_USER and assigned it to the users. After a month, you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile: SQL> DROP PROFILE app_user; Which statement describes the result()