ITPub博客

请大家加QQ群：314447206获取相应的课程链接和口令.课程结束后，更新此文档，上传相关资料.

使用数据库重放功能，您可在将系统更改应用于生产系统前，通过在测试系统上重放实际工作量来测试系统更改带来的影响。记录下在某个令人感兴趣的时段（例如高峰时段）之内数据库服务器的生产工作量（包括事务处理并发和依赖性）。使用记录下的数据，在经过适当配置的测试系统上重放工作量。通过将几乎与生产工...

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

1. 时间模型 ?2. Top Wait Events ?3. 动态性能视图和表 ?4. 预警日志 ?5. 跟踪文件 ?6. EM页面 ?7. Statspack  

（117）View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three.) A. LOG_BUFFER B. SORT_AREA_SIZE C. JAVA_POOL_SIZE D. STREAMS_POOL_SIZE E. DB_16K_CACHE_SIZE F. DB_KEE...

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