While planning to manage more than one database in your system, you perform the following activities:
1. Organize different categories of files into independent subdirectories.
2. Use consistent naming convention for database files.
3. Separate administrative information pertaining to each database.
Which option corresponds to the type of activities performed by you?()
A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
您可能感兴趣的试卷
你可能感兴趣的试题
A.Views can be created as read only.
B.Views are data segments like tables.
C.Views can be created on the basis of more than one table.
D.Data manipulation language (DML) operations cannot be performed on views.
A.control file
B.password file
C.listener controller file
D.control file and password file
A.A role can be granted to itself.
B.Roles are owned by the SYS user.
C.Roles can be granted to other roles.
D.A role cannot be assigned external authentication.
E.A role can contain both system and object privileges.
A.Perform point-in-time recovery to 2: 00 p.m.
B.Use Flashback Table feature to revert the changes.
C.Restore the entire database from the recent backup and open it.
D.Issue the rollback statement with system change number (SCN).
A.You can perform open database backups.
B.You can perform closed database backups.
C.You cannot perform schema-level logical backups.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.
A.implementing value-based auditing by using triggers
B.implementing fine-grained 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
A.SQL script
B.PL/SQL script
C.Operating System (OS) script
D.Enterprise Manager (EM) script
E.Recovery Manager (RMAN) script
You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also, you plan to transfer these values to another table for analysis.
How would you achieve this?()
A.by using triggers
B.by using external tables
C.by using anonymous PL/SQL blocks
D.by auditing all DML operations on the table
A.A leaf will be marked as invalid.
B.An update in a leaf row takes place.
C.The index will be updated automatically at commit.
D.A leaf row in the index will be deleted and inserted.
E.The index becomes invalid when you make any updates.
A.It is generated by using the redo log files.
B.It helps in row-level recovery from user errors.
C.It can be performed to recover ALTER TABLE statements
D.It fails when undo data pertaining to the transaction is overwritten.
E.The database has to be opened with the resetlogs option after performing Flashback Query.
最新试题
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, workload profile,and statistics to diagnose the possible causes of the performance degradation?()
While setting up the database for your production environment, you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace, TBS1, if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective?()
According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error: ORA-01081: cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error?()
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance?()
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 logical structure of the Oracle database?()
In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database?()