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

题目

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.

参考答案和解析

正确答案:A

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）

A. A template needs to be associated with the task.

B.A workload needs to be associated with the task.

C. The partial or complete workload scope needs to be associated with the task.

D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.

参考答案：B

第2题：

You are troubleshooting a WAN connection for TestKing, and on the router you execute the, "debug ppp authentication" command, and view the following output:What kind of handshake was used for the PPP authentication?（）

A. one-way

B. two-way

C. three-way

D. No handshakes required during authentication

E. None of the above

参考答案：C

第3题：

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?（）

参考答案：B

第4题：

You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John： SQL>GRANT SYSDBA TO john； However， you receive the following error： ORA-01996： GRANT failed： password file ’c：/oracle/ora9i/dbs/testdb.pwd’ is full Which action should you take to add the user john to the password file without removing any of the existing users？（）

A、 Create another password file and then re-execute the GRANT statement.
B、 Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.
C、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.
D、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.

正确答案:B

第5题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？（）

A、 when you change the name of a datafile
B、 when you drop a table from the database
C、 when you take an export of the database
D、 when you back up the database using OS utilities
E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

第6题：

is NOT a concept of White Box Testing.

A．You should execute all logical decisions on their tree and false sides.

B．You should execute all independent paths within a module at least once.

C．You should execute all loops at their boundary conditions.

D．You should execute all interfaces at their boundary conditions.

正确答案：D

第7题：

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

正确答案:B,E

第8题：

View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()

A. 4

B. 8

C. 7

D. 0

参考答案：A

第9题：

You issued the following statement： SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）

A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
C、 The command will execute successfully and resumable space will be allocated at the session level.
D、 The command will execute successfully and resumable space will be allocated at the instance level.

正确答案:B

第10题：

You execute the following command to start an Automatic Storage Management （ASM） instance： SQL>STARTUP； In which of the following modes will the ASM instance start？（）

A、 OPEN
B、 MOUNT
C、 NORMAL
D、 NOMOUNT

正确答案:B

You execute the following comma

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容