多项选择题

A.The user is authenticated by the operating system.B.T……

View the Exhibit1， which shows the options that are selected to create the user SL_REP.

Which two statements are true regarding this user（）

A.The user is authenticated by the operating system.
B.The objects created by the user are placed in the USERS tablespace.
C.The user does not require quota on the TEMP tablespace to perform sort operations.
D.The user is forced to change the password at the first login to the database instance.
E.The objects created by the user in future are unlocked to be accessed by all the users in the database by defa

<上一题目录下一题>

热门试题

多项选择题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 tablespace SMDUpon investigation， you find that SMD is a small file tablespace. Which three action would allow the user to insert data（）

A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

多项选择题You executed the following command to create a tablespace called SALES_DATA： > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）

A.The database automatically determines the extent-sizing policy for the tablespace.
B.The segments are automatically shrunk when the contents are removed from them.
C.The allocation of extents within the tablespace is managed through the dictionary tables.
D.The space utilization description of the data blocks in segments is recorded inbitmapblocks.
E.The space utilization description of the data blocks in segments is managed through free lists.MANUAL

多项选择题Which statements are true regarding the USERS tablespace（）

A.A bitmap is used to record free extents.
B.Free extents information is managed within the tablespace.
C.Free extents information is managed in the SYSAUX tablespace.
D.The data dictionary tables are updated when extents are allocated or deallocated

单项选择题You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB. Which configuration could have enabled the block selection of 16 KB（）

A.choosing the extent allocation type to uniform
B.choosing the Segment Space Management option to manual
C.setting autoextension on for the data file mentioned for the tablespace
D.setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

多项选择题IdentifythreesituationsinwhichyouwouldNOTbeabletodropatablespace.（）

A.when the tablespace is online
B.when the tablespace has segments with data in it
C.when the tablespace is a default permanent tablespace for the database
D.when the tablespace contains a table that is currently being used by transactions
E.when the tablespace contains undo data that is needed to rollback an uncommitted transaction