问题:单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?()A The user must be granted the database administrator (DBA) privilege.B The user must be listed in the password file for the authentication....
查看答案
问题:You work as a database administrator for Certkiller .com. Yo...
问题:Your database is in the NOARCHIVELOG mode. Since last night’...
问题:单选题The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in().A user tablesB view segmentC table segmentD data dictionaryE object segmentF ...
问题:单选题You want to set up the Oracle Database 10g installation to follow the French language, with France as the territory, and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective?()...
问题:单选题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 fo...
问题:单选题The user SCOTT executes the following command successfully to increase the salary values in one of his sessions: SQL UPDATE emp SET sal=sal*1.15 WHERE deptno=20; Before SCOTT ends the transaction, user HR who has the privileges on EMP table executes ...
问题:多选题Which two statements are true about a bitmap index? ()AIt is recommended for the columns that have unique values.BIt can be converted to a B-tree index by using the ALTER INDEX command.CIt has a bitmap segment for each distinct value in the key column,...
问题:多选题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 work as a database administrator for Certkiller .com. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()AA backup of the target database when it is mountedBA back...
问题:多选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()AA backup of the target database when it is mountedBA back...
问题:单选题The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance ...
问题:单选题In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?()A flash back the databaseB perform point-in-time recoveryC perform a full ...
问题:多选题You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait t...
问题:单选题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situ...
问题:Which two statements about Automatic Storage Management (ASM...
问题:多选题What are the consequences of executing the SHUTDOWN ABORT command? ()AThe database files are synchronized.BUncommitted changes are not rolled back.CThe database is closed, but the instance is still started.DDatabase buffers and redo buffers are not wri...
问题:You are using flat files as the data source for one of your ...
问题:单选题As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead?()A Coalesce the applicat...
问题:多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configur...