ITPub博客

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

（130）Which two statements are true regarding listeners? (Choose two.)A.Listeners use only the TCP/IP protocol.B.Multiple listener processes can run simultaneously on a host.C.Multiple database instances can be registered with a single listener.D.The listener-related errors can be tr...

（129）A database user SMITH tries to query the V$SESSION view and fails to access it as follows:SQL> connect smith/smithConnected.SQL> SELECT * FROM v$session;SELECT * FROM v$session*ERROR at line 1...

（128）Note the points about data dictionary views and dynamic performance views:1)   These are stored in the SYSTEM tablespace.2)   These are the based on the virtual tables.3)   These are owned by the SYS user.4)   These can be queried by a no...

（127）Identify the two situations in which the alert log file is updated with details. (Choose two.)A.Running a query on a table returns "ORA-600: Internal Error."B.Inserting a value in a table returns "ORA-01722: invalid number."C.Creating a table returns "ORA-00955: name is already use...

（126）Identify the two situations in which you use the alert log file in your database to check the details. (Choose two.)A.Running a query on a table returns "ORA-600: Internal Error."B.Inserting a value in a table returns "ORA-01722: invalid number."C.Creating a table returns "ORA-0095...

（124）You executed the following commands to find the location of the alert log file:SQL> SHOW PARAMETER BACKGROUND_DUMP_DESTNAME                 TYPE     VALUE...

（123）You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occur when a database instance is started and database is opened:1: SGA is allocated.2: Control file is read.3: Redo log files are opened.4: Instance recovery is started.5: Backgr...

（122）View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running.You used the following steps to start the database instance and open the database:Which file is used to start the instance in this case?A.init.oraB.spfile.oraC...

（121）After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:SQL> ALTER DATABASE OPEN;Which two statements are true? (Choose two.)A.The online redo log files and online data files are opened....

（120）For which database operation would you need the database to be in the MOUNT state? A.renaming the control files B.re-creating the control files C.dropping a user in your database D.dropping a tablespace in your database E.configuring the database instance to operate in the ARCHIVELOG or...

（119）View the Exhibit and examine the output of the query. What do you infer from this? A.The SGA_TARGET is a static parameter. B.The instance is started, but the database is not yet open. C.The server parameter file (SPFILE) was used to start the instance. D.The  SGA_TARGET  par...

（118）Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.) A .An SPFILE is a binary file. B. An SPFILE cannot reside on a client. C. An SPFILE cannot contain static parameters. D. An SPFILE can store changes persistently across instance restarts. E. An...

（116）Your database instance is started using the server  parameter  file  (SPFILE).  You executed a command to change the value of the LOG_BUFFER initialization parameter:ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;What would be the outcome of this command?A.The c...

（115）View the Exhibit.You are creating an additional database by using the Database Configuration Assistant (DBCA).You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled. What could be the reason for this?A.You have...