oracle 11g exam questions

the EMPLOYEES_HISTORY table is accidentally deleted? Even worse, what happens when the EMPLOYEES table is deleted? The simple answer to these questions is that if these things happen, I have to explain to the customer why the delta data in the EMPLOYEES_HISTORY table is lost. Use flash back data archiving to achieve "Full Oracle revocation" If I have Oracle 11 G

consider Setting this parameter to? true. This saves disk space and minimizes install time. fromOracle 11g Release 2start, add adeferred_segment_creationparameter, the default value istruerepresents the time when the newly created table is assignedextent, the distribution is only started when the data is insertedextent. In a regular environment, the tables are not immediately assigned because they are createdextent, save space, reduce creation time

buffer are written to the data file, which is a mechanism for ensuring data integrity. However, after the checkpoint is complete, the CKPT process is responsible for updating the data file and controlling the header information of the file, and saving the checkpoint information to ensure the synchronization of the database log files and data files. The principle is that when the database is restored, only the last checkpoint saved by Ckpt can be found, and then the log information will be re-ex

back up as a script file An example of how to back up a binary file: Before you back up the control file, check that there are several control files in the current system Backup control filesModify System Parameters FileORA-00214 error is reported after database has been shut down since the control file version inconsistency is responsible for The Control01.ctl control file version is 817, and the Control02.ctl version is 806.Use Control01.ctl to overwrite the control03.ctl, so that the control

EMPLOYEES_HISTORY table is accidentally deleted? Even worse, what happens when the EMPLOYEES table is deleted? The simple answer to these questions is that if these things happen, I have to explain to the customer why the delta data in the EMPLOYEES_HISTORY table is lost. Use flash back data archiving to achieve "Full Oracle revocation" If I have Oracle 11 GB, I

Tom user permission to create a tableCreate AA TableTo test whether Tom users can insert records into a table, insert a record.Revoke permissionsView the permissions that Tom users currently haveRevoke a Tom user's CREATE TABLE permissionTest Tom users to see the EMP table under the Scott userConnect to database using SYS userPermissions for Tom users to authorize the EMP table under Select Scott UsersConnect to a database by using a Tom userIf you have any

cache now has an HR user access to the Scott.emp table, and the role of the DataBuffer cache is to transfer the block into memory from disk or storage and buffer cache.Example:The first time a user accesses scott.emp contentSql> Set Timing onSql> select * from scott.emp; Execute SQL statement for the first time14 rows have been selected.Time used: 00:00:00.05Sql>/Time to execute the previous command again is 00:00:00.0014 rows have been selected.Time used: 00:00:00.00Summary: Buffer cache Cache

For the first time, I was able to perform Oracle distributed transaction processing, and I was beaten by a storm. After two and a half days in a row, I finally completed the transaction. During this period, I encountered various problems, and I was tired of Google, at first, I was still confident that the last new error message was a bit desperate. Then I put my energy into an article so that future generations could not take a detour. During this per

consistency. The checkpoint is actually a background process that guarantees that all modified database buffers are written to the data file.The more frequent the checkpoint event, the less data in the redo log that requires data recovery (since the data in the redo log before the recovery checkpoint does not have to be checked when recovering), as soon as the database fails, reducing the recovery time of the instance.Forces a log switchover and forces a checkpoint event to occur.Force Log Swit

Oracle OCP 11G 053 (1-200) Answer resolution directory 　 V13.02 version, 711 questions File version:3.2,200 problem version:5.4 1 http://blog.csdn.net/rlhua/article/details/16369867 490 2 http://blog.csdn.net/rlhua/article/details/16527169 491 3 http://blog.csdn.net

the target database with the SYS user as SYSDBA, and then execute the archivelog List command to view the database archive mode:Close the database and start the database to Mount stateUse the ALTER DATABASE Archivelog command to set the database to archive mode and verify that the archive mode of the database has changedGet archived log informationThe data dictionary view helps you get database configuration information. Users get archived log information by using the V$archive_dest and V$archi

database files, and disk groups need to be consistent with the RAC Disk group for easy restore#磁盘分区fdisk/dev/sd*N-p-1-w#安装asmYum install-y kmod-oracleasm-2.0.8-13.el6_8.x86_64.rpm oracleasmlib-2.0.4-1.el6.x86_64.rpm oracleasm-support-2.1.8-1.el6.x86_64.rpm#创建asm磁盘--------------------------------------------------------------------------------------------------------------- -------------# oracleasm Status# oracleasm Configure-iConfiguring the Oracle A

reference) "I know the results rowid would be sorted by"-No, they is not. The rows would be returned in any order the database thinks are the most efficient. There is no, absolutely no, guarantee this rows is returned in any specific order unless your specify an ORDER BY . The only-to-get-a specific order is ORDER BY -to-use. Http://stackoverflow.com/questions/20186673/in-oracle-

system set LOCAL_ The LISTENER=ORCL is equivalent.Registering an instance with the Listener1 aboveSql>alter system Set local_listener= "(ADDRESS = (PROTOCOL = TCP) (host= orclsrv) (PORT = 1522)";You cannot connect to the instance by using the default listener at this time.To modify a file in a Tnsnames.oraSql>alter system setlocal_listener=listener2;The system has changed.See which listener the instance is registered to: Show parameter local;If you have any

normal. Path:d:\app\administrator\product\11.2.0\client_1;d:\app\administrator\product\11.2.0\dbhome_1\bin; ... The fourth is Oracle_sid (ORCL instance name, which is the name of the database at installation time) Oracle_sid:orcl The fifth one is oracle_home. Oracle_home: You can not set, if the settings must be correct, otherwise can not be used. If you forget the instance name at Oracle installation, you can open the registration view, as sho

able to log on. It is also suggested that the system may not be compatible after modifying the connection parameters, resulting in the inability to gain monitoring. I go to ... Finally, I can only download oracle10g, in the process of unloading, it is the life ah, in the process of unloading products, in addition to the directory, All other one by one tick delete. I'm going to take a walk, and in the process of checking, you can experience the pain and bitterness. 5. Finally attach the CREATE

1. After installing the database server, there is aClicking on a button after opening will call you to log in, the username is system, the password is the password set at the time of installation (the password I set is root).。2. On the operating system "run" enter Sqlplus then enter the user name password, the user name is system, the password is installed when the password is set (I set the password is root), and then can execute the SQL statement.3.Oracle