随笔分类 - OCP
OCP考试学习
摘要:Which statements listed below describe the data dictionary views?1. These are stored in the SYSTEM tablespace2. These are the based on the virtual tab
阅读全文
摘要: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
阅读全文
摘要:You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location
阅读全文
摘要:You executed the following commands to find the location of the alert log file:SQL> SHOW PARAMETER BACKGROUND_DUMP_DESTNAME TYPE VALUE background_dump
阅读全文
摘要: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
阅读全文
摘要: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 sta
阅读全文
摘要: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:SQ
阅读全文
摘要:For which database operation would you need the database to be in the MOUNT state?A.renaming the control filesB.re-creating the control filesC.droppin
阅读全文
摘要: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, bu
阅读全文
摘要: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 o
阅读全文
摘要:View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not autom
阅读全文
摘要:Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initializatio
阅读全文
摘要:View the Exhibit. You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose
阅读全文
摘要:You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the
阅读全文
摘要:You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on
阅读全文
摘要:View the Exhibit. What would happen if Oracle Home is not empty?A.The installation will not be continued until the location is empty.B.The installatio
阅读全文
摘要:Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation? A.Run the root.sh scrip
阅读全文
摘要:In a new installation of Oracle Database 11g, you perform these activities:1: Organize software and data on different subdirectories to avoid poor per
阅读全文
摘要:You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the i
阅读全文
摘要:Note the following points describing various utilities in Oracle Database 11g:1: It enables the transfer of data from one database to another.2: It pr
阅读全文
浙公网安备 33010602011771号