ITPub博客

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

（136）You have two database servers SEMP and SACCT.The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information.The employees submit the expense reports to the accounts payable department.A user of the ...

（135）In which situation would you use static database registration for a listener?A.  when multiple databases are to be registered with the listenerB.  when DBAs need to connect remotely to start up the database instanceC.  when users need to connect the database instance...

答案：（B、D）

（133）Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command:LSNRCTL> STOPWhat happens to the sessions that are presently connected to the database instance?A.The sessions are able to perform only queries.B.The se...

（132）The tnsnames.ora file has an entry for the service alias ORCL as follows:ORCL =( DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl.oracle.com)))The TNSPING command executes successfully when ...

（131）Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?A. host naming methodB. local naming methodC. external naming methodD. directory naming method答案：（B）...