更多"What action should y"的相关试题:
[单项选择]GUILLOTINE : EXECUTE ::
A. (A) sword : terrify
B. (B) asylum : persecute
C. (C) cord : censure
D. (D) tomb: inter
E. (E) emblem : demonize
[单项选择]You have applications that have frequently executed queries, and produce small and static result sets.You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?（）
A. to avoid round trips to the server by enabling caching of query results in client memory
B. to improve performance by storing a copy of the data from the private SQL area of the PGA
C. to enhance the query performance by creating a cache in the client memory for sorting operations
D. to avoid the storing of query plans and results in the server by creating a cache in the client memory
[单项选择] You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）
A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
[单项选择] You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: /＞ mysqld – install Mysql56 – defaults – file = C :/my –opts.cnf What is the expected outcome?（）
A. Mysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration file
B. An error message is issued because – install is not a valid option for mysqld
C. A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnf
D. Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file
[单项选择] Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）
A. The database manager will rollback the transaction in both applications.
B. The database manager will rollback the transaction in one of the two applications.
C. Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
D. Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
[多项选择]You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）
A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
C. Data is never redacted for the EMP_V.SAL column.
D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
[单项选择]In order to change the system runlevel and execute /etc/inittab entries based on the new runlevel, which of the following commands should be performed?（）
A. telinit
B. runinit
C. sysinit
D. startinit
[多项选择] You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）
A. It records the usernames and passwords of users when granted the DBA role.
B. It contains the usernames and passwords of users for whom auditing is enabled.
C. Is used by Oracle to authenticate users for remote database administration.
D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
[单项选择] Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback operation
[多项选择] You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）
A. The database must have multiplexed redo log files
B. The database must be in the MOUNT state to execute the command
C. The database must be in the NOMOUNT state to execute the command
D. The database must be opened in RESTRICTED mode before this operation
E. The database must be opened with the RESETLOGS option after the flashback operation
[单项选择]The operator needs to execute a long-running shell script. How can the script be executed so the operator does not have to wait until it is complete to access the command prompt?（）
A. ./script.ksh
B. nohup ./script.ksh
C. run -b ./script.ksh
D. ./script.ksh > nohup.out
[单项选择] A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）
A. The keep pool is not configured.
B. Automatic Workarea Management is not configured.
C. Automatic Shared Memory Management is not enabled.
D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
[多项选择]You execute the following PL/SQL:Which two statements are true?（）
A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
[单项选择] OSPF is enabled on router A. You execute the following command on router A and receive theaccompanying output:RouterA#ping 224.0.0.5 repeat1Type escape sequence to abort.Sending 1, 1 00 - byte ICMP Echos to 224.0.0.5, timeout is 2 seconds:Reply to request 0 from 10.100.100.1, 4 ms10.100.100.1 is the IP address of a loopback interface on router A. What can you conclude about router A?（）
A. Only the router A loopback interface is parti cipating in the OSPF routing process
B. None of the router A interfaces are participating in the OSPF routing process
C. Router A is using the loopback interface IP address as its OSPF router ID
D. Router A does not have any reachable OSPF neighbors
[多项选择]关于Redirect和Transfer以及Execute方法，下列说法正确的是（）。
A. Redirect和Transfer跳转到新网页后，不会再返回原网页，而Execute则会在执行完新网页后，返回原网页继续执行Execute方法后面的语句
B. Redirect的重定向实际发生在客户端，而Execute和Transfer方法的重定向发生在服务器端，效率更高
C. Redirect语句不能把一些环境变量一起传递到新网页中，而Execute和Transfer可以
D. Redirect方法可以转向一个网页或其他网站，而Execute和Transfer方法一般只能转到同一个应用程序的其他文件
[单项选择] You execute the following command to enable a session in resumable mode： SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60； What is the impact of a timeout on the statements being suspended？（）
A. The statements remain suspended for at least 60 seconds.
B. The statements are suspended for 60 seconds and then they are executed.
C. The suspended statements error out if the problem is not rectified within 60 seconds.
D. The statements are automatically suspended 60 seconds after an error is received， and then attempt toexecute normally again.
[多项选择] You execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（）
A. Repair the corrupted blocks. If any. In the backup created
B. Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
C. Back up the database after checking whether array of the files have corrupted blocks
D. Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
E. Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
