Oracle认证 - 自考题库

出自:Oracle认证

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?（）
A:Enable supplemental logging for the database.
B:Specify undo retention guarantee for the database
C:Create Flashback Data Archive in the tablespace where the tables are stored.
D:Create Flashback Data Archive and enable Flashback Data Archive for specific tables

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）
A:You cannot roll back this statement.
B:All pending transactions are committed.
C:All views based on the DEPT table are deleted.
D:All indexes based on the DEPT table are dropped.
E:All data in the table is deleted, and the table structure is also deleted.
F:All data in the table is deleted, but the structure of the table is retained.
G:All synonyms based on the DEPT table are deleted.

Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data. This requires the following config file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I/O overhead. What three changes will reduce disk I/O overheads?（）
A:Use of soft links for database directories on the same physical disk
B:Use of delay_key_write=ON for batch index update
C:Allocation of RAM to the buffer pool such that more of the data can fit in RAM
D:Placement of InnoDB log files and datadir on separate physical disks
E:Use of separate directories on the same physical disk for log files and data files

Evaluate these two SQL statements: SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them? （）
A:The two statements produce identical results.
B:The second statement returns a syntax error.
C:There is no need to specify DESC because the results are sorted in descending order by default.
D:The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

You are installing Oracle Database 11g on a machine. When you run the installer， the OracleUniversal Installer （OUI） shows the message that says one of the product-specific prerequisite checkshas failed： Checking available swap space requirements ... Expected result： 1512MB Actual Result： 1018MB Check complete. The overall result of this check is： Failed <<<< Problem： The system does not have the required swap space. What happens to the installation in this situation（）
A:It can be continued.
B:It resizes the swap space automatically when you proceed further.
C:It can be continued， but the instance cannot be started without increasing the swap space.
D:It shows a message saying one or more prerequisite checks have failed and the installation cannotproceed.

What are the three steps you should take to tune a JDBC Connection pool in WebLogic from the initial settings in a production environment?（）
A:Ensure the maximum size is increased to an appropriate setting.
B:Set the minimum and maximum size of the connection pool to the same value.
C:Increase the statement cache size.
D:Add more heap to the JVM.
E:Add more nodes to the cluster.

You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA， a big file tablespace of size 100 TB on tape drive， but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently？（）
A: parallel image copy backup
B: backup with MAXPIECESIZE configured for the channel
C: parallel backup with MAXPIECESIZE configured for the channe
D: intrafile parallel backup

Which of the following are valid settings for the NLS_COMP parameter?（）
A:ASCII
B:ANSI
C:BINARY
D:MONOLINGUAL
E:MULTILINGUAL

在登录到Oracle Enterprise Manager时，要求验证用户的身份。下面不属于可以选择的身份是（）。
A:Normal
B:SYSOPER
C:SYSDBA
D:Administrator

In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）
A: The backup would be retained on the media for 31 days.
B: The backup would be maintained in the recovery catalog for 31 days.
C: The backup metadata would be retained in the control file for 31 days.
D: The backup metadata would be maintained in the recovery catalog for 31 days.
E: Automatic backups of the control file will be retained in the flash recovery area for 31 days.

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）
A:Redo logs
B:Control file
C:The latest backup of only the damaged data file
D:The latest backup of all the data file in the USERS tablespace
E:Temporary files of temporary tablespace
F:Archive Logs since the latest backup to point of failure

用（）语句修改表的一行或多行数据。
A:Update
B:set
C:Select
D:Where

You execute the following command in your Supportcenter.cn production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）
A:The database instance is not available.
B:The ALTER TABLE command does not have WAIT option
C:The table or a row in the table is currently locked by another user session.
D:The database instance is busy processing other user sessions commands.
E:The CUSTOMERS table has no long running query active at the time when this request is made.
F:The server process executing the ALTER TABLE command is busy with another command execution

Identify three key features of ASM.（）
A:file striping
B:allocation unit mirroring
C:automatic disk rebalancing
D:automatic file size increment
E:automatic undo management

Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command）（）
A:A CHECK constraint is created on the OID column.
B:A NOT NULL constraint is created on the OID column.
C:The ORDERS table is the only object created in the USERS tablespace.
D:The ORDERS table and a unique index are created in the USERS tablespace.
E:The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）
A:You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
B:The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
C:The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
D:Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
E:The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
F:The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

在全局存储区SGA中，哪部分内存区域是循环使用的？（）
A:数据缓冲区
B:日志缓冲区
C:共享池
D:大池

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?（）
A:AWR baselines are always created as repeating baselines.
B:AWR baselines can be created on the basis of two time values.
C:AWR baselines are always created with infinite expiration duration.
D:AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

Which statement explicitly names a constraint?（）
A:ALTER TABLE student_grades   ADD   FOREIGN KEY (student_id) REFERENCES students(student_id);
B:ALTER TABLE student_grades   ADD CONSTRAINT NAME = student_id_fk   FOREIGN KEY (student_id) REFERENCES students(student_id);
C:ALTER TABLE student_grades   ADD CONSTRAINT student_id_fk   FOREIGN KEY (student_id) REFERENCES students(student_id);
D:ALTER TABLE student grades   ADD NAMED CONSTRAINT student_id_fk   FOREIGN KEY (student_id) REFERENCES students(student_id);
E:ALTER TABLE student grades   ADD NAME student_id_fk   FOREIGN KEY (student_id) REFERENCES students(student_id);

Given：

What is the result？（）
A:Cat
B:Dog
C:Compilation fails.
D:The code runs with no output.
E:An exception is thrown at runtime.

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?（）
A:COUNT(UPPER(country_address))
B:COUNT(DIFF(UPPER(country_address)))
C:COUNT(UNIQUE(UPPER(country_address)))
D:COUNT DISTINCT UPPER(country_address)
E:COUNT(DISTINCT (UPPER(country_address)))

Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）
A:All database operations performed by the impdp command are logged.
B:Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
C:Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
D:None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

（）是ORACLE最基本的逻辑存储单位。
A:盘区
B:段
C:表空间
D:数据块

Which three statements are true concerning unplugging a pluggable database (PDB)?（）
A:The PDB must be open in read only mode.
B:The PDB must be dosed.
C:The unplugged PDB becomes a non-cdb.
D:The unplugged PDB can be plugged into the same multitenant container database (CDB)
E:The unplugged PDB can be plugged into another cdb.
F:The PDB data files are automatically removed from disk.

For which two tasks would it be best NOT to use the utility SQL*Loader？（）
A:When loading selected rows into each table.
B:When loading data from an export dump file.
C:When loading data from disk， tape， or named pipes.
D:When your data is NOT being inserted from a flat file.
E:When using a record management system to access data files.

Your database instance is configured with automatic undo management and the UNDO_RETENTIONparameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this command have onthe database（）
A:The extents in the undo tablespace retain data until the next full database backup.
B:The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.
C:The extents containing committed data in the undo tablespace are not overwritten until the instance is shutdown.
D:The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:

Which is the recommended sequence of operations you need to perform for the query successfully?（）
A:Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B:Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
C:Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D:Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
A:set the CPU time per call in the users profile
B:set the CPU time per session in the users profiles
C:set the CPU levels for the users’ group using Resource Manager
D:set the TIMED_STATISTICS parameter to TRUE in the parameter file

View the Exhibit to observe the roles assigned to the SLP_REP user.

Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REPuser（）
A:The user must enable the role explicitly.
B:The user can grant the role to other users.
C:The user cannot use the role until the DBA enables it explicitly.
D:The user can start using the role immediately without any changes.

首页 <上一页 84 85 86 87 88 下一页> 尾页