多选题A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）Aincrease the size of redo log filesBincrease the size of the undo tablespaceCincrease the size of the Database Buffer CacheDincrease the size of the default temporary tablespaceEenable the retention guarantee for the undo tablespace

考题 You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.

查看答案

考题 Which of the following statements about authentication responses and conditions is true? （）(Choosetwo.)A、When a router receives a failure response, it stops querying authentication methods.B、When a router receives an error response, it stops querying authentication methods.C、If the router receives a failure response from an authentication method, it queries the next method.D、The router does not differentiate between failure and error responses; the authentication process is always interrupted.E、If it receives no response from the authentication method, a router will determine the error condition On its own; the router also has the option to proceed to the next method in a list if configured accordingly.

查看答案

考题 You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader（　）You need to execute a method named DoWork（　） that takes one second to run while the SQL query is executing. DoWork（　） must run as many times as possible while the SQL query is executing. Which code segment should you use?（）A、While ar.AsyncWaitHandle Is Nothing DoWork()End Whiledr = cmd.EndExecuteReader(ar)B、While Not ar.IsCompleted DoWork()End Whiledr = cmd.EndExecuteReader(ar)C、While T hread.CurrentThread.ThreadState = ThreadState.Running DoWork()End Whiledr = cmd.EndExecuteReader(ar)D、While Not ar.AsyncWaitHandle.WaitOne() DoWork()End Whiledr = cmd.EndExecuteReader(ar)

查看答案

考题 The user HR receives the following error while inserting data into the TTK table： ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon investigation， you find that SMD is a small file tablespace. Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

查看答案

考题 Which of the following statements about authentication responses and conditions is true?（）(Choose two.)A、When a router receives a failure response, it stops querying authentication methods.B、When a router receives an error response, it stops querying authentication methods.C、If the router receives a failure response from an authentication method, it queries the next method.D、The router does not differentiate between failure and error responses; the authentication process is always interrupted.E、If it receives no response from the authentication method, a router will determine the error condition on its own; the router also has the option to proceed to the next method in a list if configured accordingly.

查看答案

考题 Given the following output： prompt myapp [1]+ Stopped myapp prompt Which of the following commands will resume executing the stopped process while allowing the user to continue to type commands at the command prompt？（）A、 bg myappB、 continue myappC、 exec myappD、 fg myappE、 myapp

查看答案

考题 An administrator receives a call from an end user reporting that the application they are using keeps giving them an error on port 23. Which of the following is being used？（）A、SSHB、Remote Desktop ConnectionC、TelnetD、VPN

查看答案

考题 While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）A、ARCnB、CKPTC、DBWnD、LGWRE、PMONF、SMON

查看答案

考题 A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）A、increase the size of redo log filesB、increase the size of the undo tablespaceC、increase the size of the Database Buffer CacheD、increase the size of the default temporary tablespaceE、enable the retention guarantee for the undo tablespace

查看答案

考题 Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally， but will be slower

查看答案

考题 The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic

查看答案

考题单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A The queries that are currently executing will abort and an error message will be returned to the user.B The queries that are currently executing will execute normally but future queries will not executed.C Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D The currently executing and future queries will execute normally， but will be slower

查看答案

考题单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）A Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

查看答案

考题单选题A user executes a query on the EMP table， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal * ERROR at line 1： ORA/x7f01157： cannot identify/lock data file 201 /x7f see DBWR trace file ORA/x7f01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）A The tempfile belonging to the default temporary tablespace is missing.B The database is opened in restricted mode， so queries are not allowed.C The default temporary tablespace required to execute the query is offline.D The default temporary tablespace required to execute the query is dropped.E The default temporary tablespace required to execute the query is readonly.

查看答案

考题单选题A user executes a query on the EMPtable， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL SELECT ename FROM emp WHERE deptno=10 ORDER BY sal； SELECT ename FROM emp WHERE deptno=10 ORDER BY sal ERROR at line 1： ORA-01157： cannot identify/lock data file 201 - see DBWR trace file ORA-01110： data file 201：’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）A The tempfile belonging to the default temporary tablespace is missing.B The database is opened in restricted mode， so queries are not allowedC The default temporary tablespace required to execute the query is offline.D The default temporary tablespace required to execute the query is dropped.E The default temporary tablespace required to execute the query is read-only.

查看答案

考题单选题While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）A ARCnB CKPTC DBWnD LGWRE PMONF SMON

查看答案

考题多选题The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock. two statements are true regarding the session of SCOTT in this scenario（）AThe session is terminated after receiving the error and JIM can continue with his transaction.BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.CThe session is rolled back after receiving the error and JIM can continue with his transaction.DSCOTT has to reexecute the last command in the transaction after he commits the transaction.

查看答案

考题单选题You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A The tablespace TBS1 is full.B The user is not the owner of the SYSTEM tablespace.C The user does not have quota on the TBS1 tablespace.D The user does not have sufficient system privileges to create table in the TBS1 tablespace.E The user does not have sufficient privileges to create table on the default permanent tablespace.

查看答案

考题单选题You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（　）;You need to execute a method named Do Work（　） that takes one second to run while the SQL query is executing. DoWork（　） must run as many times as possible while the SQL query is executing. Which code segment should you use? （）A while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；B while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；C while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；D while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

查看答案

考题单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）A Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.B Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.C Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.D Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.

查看答案

考题单选题You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）A The database instance is not available.B The ALTER TABLE command does not have WAIT optionC The table or a row in the table is currently locked by another user session.D The database instance is busy processing other user sessions commands.E The CUSTOMERS table has no long running query active at the time when this request is made.F The server process executing the ALTER TABLE command is busy with another command execution

查看答案

考题单选题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？（）A Modify the profile assigned to the user.B Modify the roles assigned to the users.C Modify the object privileges assigned to the user.D Modify the system privileges assigned to the users.E Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

查看答案

考题单选题Given the following output： prompt myapp [1]+ Stopped myapp prompt Which of the following commands will resume executing the stopped process while allowing the user to continue to type commands at the command prompt？（）A bg myappB continue myappC exec myappD fg myappE myapp

查看答案

考题多选题The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario（）AThe session is terminated after receiving the error and JIM can continue with his transaction.BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.CThe session is rolled back after receiving the error and JIM can continue with his transaction.DSCOTT has to reexecute the last command in the transaction after he commits the transaction.

查看答案

考题单选题A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t，（select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）A GRANT SELECT ANY TRANSACTION TO ARRENB GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARRENC GRANT SELECT_ANY_TRANSACTION TO ARREND GRANT FLASHBACK TO ARRENE GRANT SELECT ANY VIEW TO ARREN

查看答案

考题单选题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 onto 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？（）A Modify the profile assigned to the user.B Modify the roles assigned to the users.C Modify the object privileges assigned to the user.D Modify the system privileges assigned to the users.E Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：