A.FGA is possible on SELECT statements only.
B.The audit trail for FGA is stored in the FGA_LOG$ table.
C.The audit trail for FGA is stored in the AUD_LOG$ table.
D.FGA enables a SQL predicate to define when to audit an event.
E.FGA audits DELETE statements only when audit columns are specified.
F.FGA includes the SQL statement used by the user as part of the audit event entry.
您可能感兴趣的试卷
你可能感兴趣的试题
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the yearend tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator.
Which method would you suggest to the bank for achieving this task?()
A.implementing valuebased auditing by using triggers
B.implementing finegrained auditing with audit condition and event handler
C.performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
D.performing standard database auditing to audit SQL statements with granularity level set to ACCESS
You execute the following command to audit the database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?()
A.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B.One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C.One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E.One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.
Which action would you consider to overcome the performance degradation?()
A.Configure Java Pool to cache the java objects.
B.Configure Streams Pool to enable parallel processing.
C.Increase Shared Pool size to cache more PL/SQL objects.
D.Increase Database Buffer Cache size to increase cache hits.
E.Configure Large Pool to be used by RMAN and shared server.
F.Increase the total System Global Area (SGA) size to increase memory hits.
A.Each segment contains one or more extents.
B.Multiple tablespaces can share single data file.
C.A data block is the smallest unit of I/O for data files.
D.It is possible to have tablespaces of different block sizes in a database.
E.Each data block in the database always corresponds to one OS block.
A.This clause is not valid for a temporary or undo tablespace.
B.If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.
C.The tablespace will be in the NOLOGGING mode by default, if not specified while creating a tablespace.
D.The tablespacelevel logging attribute can be overridden by logging specifications at the table, index, materialized view, materialized view log, and partition levels.
A.average row size
B.last analyzed date
C.size of table in bytes
D.size of table in database blocks
E.number of free blocks in the free list
F.number of extents present in the table
The following are the details of your database:
Instance name:test
Host name:tech1.us.oracle.com
IP address:145.33.230.186
Enterprise Manager Console HTTP Port number:5500
You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control?()
A.http://145.33.230.186:5500/em
B.http://www.145.33.230.186:5500/em
C.http://tech1.us.oracle.com:5500/em
D.http://test.145.33.230.186:5500/em
E.http://test.tech1.us.oracle.com:5500
F.http://www.tech1.us.oracle.com:5500/em
G.http://test.tech1.us.oracle.com:5500/em
A.create baseline metrics for today’s performance
B.write the current database metrics to a database table and create a trigger to compare with future database statistics
C.write the current database metrics to a flat file and create an operating script to compare with future database statistics
D.write the current database metrics to a database table and create a procedure to compare with future database statistics
E.write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
A.guarantee undo retention
B.add one more redo log group
C.size the redo log files appropriately
D.size the UNDO tablespace appropriately
E.size the SYSTEM tablespace appropriately
F.configure an appropriate undo retention interval
G.change automatic undo management to manual
When you try to open your database, you receive the following error: ORA-00205: error in identifying control file
Where would you find the details required to resolve this error?()
A.audit trail
B.alert log file
C.user trace file
D.online trace file
E.background trace file
F.operating system event viewer
最新试题
One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions, and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority. Which method would you use to overcome this problem?()
In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()
You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.Which action would you consider to overcome the performance degradation?()
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this?()
Which two are valid locking levels that are used by transactions in an Oracle database?()
The following are the details of your database: Instance name:test Host name:tech1.us.oracle.com IP address:145.33.230.186 Enterprise Manager Console HTTP Port number:5500 You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control?()
When you try to open your database, you receive the following error: ORA-00205: error in identifying control file Where would you find the details required to resolve this error?()
Which three statements are true regarding the finegrained auditing (FGA)?()
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the yearend tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task?()
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct?()