ITPub博客

（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...

（150）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 d...

（149）You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100MSEGMENT SPACE MANAGEMENT AUTO;Which two statements are true about the SALES_DATA tablespace? (Choose two.)A. The database automatically determines the...

（148）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 extents information is managed within the tablespace.C. Free extents information is managed in the SYSAUX tablespace.D. The dat...

（147）View the Exhibit.You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage 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 all...

（146）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 segments with data in itC.when the tablespace is a default permanent tablespace for the databaseD.when the tablespace contains ...

（145）Examine the commands executed in a DBA session:CREATE BIGFILE TABLESPACE MRKT  DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;Tabl...

（144）You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effect of the command? (Choose all that apply.)A. The tablespace would require recovery to go back online.B. A checkpoint is taken on al...

（143）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 statement is true about this command?A. The command must be issued in MOUNT state.B. The command succeeds only if the data file...

（142）The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:SQL> INSERT INTO cust VALUES(101, 'JACK');1 row created.SQL> INSERT INTO cust VALUES(102, 'SMITH');1  row created.As a DBA, you ex...

（141）Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)A. Undo tablespaceB. USERS tablespaceC. SYSAUX tablespaceD. SYSTEM tablespaceE. Temporary  tablespace答案：（C、D）

（140） Identify two situations in which the block header grows in a data block. (Choose two.)A. when row directories need more row entriesB. when there is row migration in the data blockC. when there is an increase in the PCTFREE value for the data blockD. when more transaction slots ar...

（139）Which two statements are true regarding a tablespace? (Choose two.)A. It can span multiple databases.B. It can consist of multiple data files.C. It can contain blocks of different sizes.D. It can contain segments of different sizes.E. It can contain a part of a nonpartitioned...

（138）Your database is configured in shared server mode.However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users.What could be the reason for this?A. to limit the User Global Area (UGA) memory allocated to a session from the SGAB. to ...

（137）Your database instance is currently configured to support 1,500 connections.The Web application that uses the database allows a large number of users to work with the database simultaneously.Some users of the Web application do not interact with the server all the time.You want to ...