多选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started?()ACreating the parse tree of the statementBWriting the modified data blocks to the data filesCWriting the modified data to the archived redo log filesDUpdating the control file to indicate the most recent checkpointEUpdating the data file header to indicate the most recent checkpointFReading the blocks to database buffer cache if they are not already there
多选题
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started?()
A
Creating the parse tree of the statement
B
Writing the modified data blocks to the data files
C
Writing the modified data to the archived redo log files
D
Updating the control file to indicate the most recent checkpoint
E
Updating the data file header to indicate the most recent checkpoint
F
Reading the blocks to database buffer cache if they are not already there
参考解析
解析:
暂无解析
相关考题:
单选题You work as a database administrator for Certkiller .com. As a result of performance analysis, you created an index on theprod_namecolumn of the Certkiller prodtable, which contains about ten thousand rows. Later, you updated a product name in the table. How does this change affect the index?()AA leaf will be marked as invalid.BAn update in a leaf row takes place.CThe index will be updated automatically at commit.DA leaf row in the index will be deleted and inserted.EThe index becomes invalid when you make any updates
单选题You are using the following command to clear the log file group: ALTER DATABASE CLEAR LOFFILE GROUP 2; In which case would the command be successful?()AGroup 2 is the active group.BGroup 2 is the current group.CDatabase is in the MOUNT state.DGroup 2 has been already archived.
多选题You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?()Asnmp.oraBnames.oraCspfile.oraDsqlnet.oraElistener.oraFtnsnames.ora
单选题A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392: exceeded session limit on CPU usage, you are being logged off Which action would you take to increase the session limit on CPU usage?()AModify the profile assigned to the user.BModify the roles assigned to the users.CModify the object privileges assigned to the user.DModify the system privileges assigned to the users.EModify the value for the RESOURCE_LIMIT parameter in the parameter file.
多选题Which two statements about Flashback Query are true?()AIt is generated by using the redo log files.BIt helps in row-level recovery from user errors.CIt can be performed to recover ALTER TABLE statementsDIt fails when undo data pertaining to the transaction is overwritten.EThe database has to be opened with the resetlogs option after performing Flashback Query.