Oracle认证 - 自考题库

出自:Oracle认证

The STUDENT_GRADES table has these columns:

The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?（）
A:

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。
A:identify the segments that you should shrink
B:modify the storage parameters for the tablespace
C:automatically shrink the segments with unused space
D:check the alerts generated for the tablespace that is running low on space

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）
A: V$FLASHBACK_DATABASE_LOG
B: V$FLASHBACK_DATABASE_STAT
C: V$DATABASE
D: V$UNDOSTAT

Given：

What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:An instance of Forest is serialized.
D:An instance of Forest and an instance of Tree are both serialized.

用于在启动实例时配置数据库，确定Oracle 11g的运行环境文件是（）。
A:参数文件
B:数据文件
C:可执行文件
D:控制文件

描述用户、角色和权限的概念和三者之间的关系。

You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）
A:V$SESSION
B:V$SYSSTAT
C:DBA_SEGMENTS
D:V$SORT_USAGE

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?（）
A:stored scripts in the recovery catalog
B:backups that can be deleted from disk
C:backup sets and image copies are obsolete
D:backups that do not have the AVAILABLE status in the RMAN repository RMAN

Your end users will need to change values in a REF lookup field in the form application you create. To facilitate choosing a new appropriate value, your provide them with? （）
A:An LOV for REFS.
B:A list item for REFs.
C:A radio group for REFs.
D:A hierarchical tree for REFS

You work as a database administrator for Certkiller .com. Your listener process， L1，is currently listening to three databases：CertK INDB04，Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant （DBCA） you create one more database，Certkiller DB07，and enable dynamic registration. Which two commands of Listener Control Utility （lsnrct1） would you use to determine whether the dynamic registration occurred for the database， Certkiller DB07， with the L1 listener process？（）
A:SHOW L1
B:SPAWN L1
C:STATUS L1
D:SERVICES L1
E:STATUS LISTENER
F:SERVICES LISTENER
G:SHOWcurrent_listener

（）不带WHERE子句，它返回被连接的两个表所有数据行的笛卡尔积，返回到结果集合中的数据行数等于第一个表中符合查询条件的数据行数乘以第二个表中符合查询条件的数据行数。
A:交叉连接
B:外连接
C:内连接
D:自然连接

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file. 2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?（）
A:8，1，3，2，4，5，7，6
B:1，8，3，4，2，5，7，6
C:1，3，4，2，8，5，6，7
D:1，3，2，4，6，5，7，8

The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery（）
A:Inactive and current redo log files are required to accomplish recovery.
B:Online and archived redo log files are required to accomplish instance recovery.
C:All redo log entries after the last checkpoint are applied from redo log files to data files.
D:All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files

You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands： CONFIGURE DEFAULT DEVICE TYPE TO sbt； CONFIGURE BACKUP OPTIMIZATION ON； CONFIGURE RETENTION POLICY TO REDUNDANCY 3； From Monday to Saturday， you performed the following actions： Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed？（）
A: The backup will not be performed at all.
B: three times
C: four times
D: six times

Given:

What is the result?（）
A:[1, 2, 3, 5]
B:[2, 1, 3, 5]
C:[2, 5, 3, 1]
D:[5, 3, 2, 1]
E:[1, 3, 5, 2]
F:Compilation fails.
G:An exception is thrown at runtime.

You want to perform a backup of your database to tape. Which backup format can you use？（）
A:backup set only
B:image copy only
C:only user-managed backup
D:both image copy and backup set
E:only incremental image copy backup

Your test database is running in NOARCHIVELOG mode. What are the implications of this？（）
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.

When is an implicit anchor created?（）
A:When an object is enclosed by another object.
B:When a page break after pagination property is enabled.
C:When a link is created between two objects.
D:When a keep with anchoring object pagination property is enabled.

Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?（）
A:The data file is checked for physical corruption and backed up if found clean.
B:The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C:The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D:The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

在数据库启动后，用户权限、数据库对象的定义等信息，被存放在下列哪个区域（）
A:库缓冲区
B:数据字典缓冲区
C:数据缓冲区
D:重做日志缓冲区

Identify the three predefined server-generated alerts. （）
A: Drop User
B: Tablespace Space Usage
C: Resumable Session Suspended
D: Recovery Area Low On Free Space
E: SYSTEM Tablespace Size Increment

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?（）
A:Mount the container database (CDB) and restore the control file from the control file auto backup.
B:Recover and open the CDB in NORMAL mode.
C:Mount the CDB and then recover and open the database, with the RESETLOGS option.
D:Open all the pluggable databases.
E:Recover each pluggable database.
F:Start the database instance in the nomount stage and restore the control file from control file auto backup.

You have two tables with referential integrity enforced between them. You need to insert data to thechild table first because it is going to be a long transaction and data for the parent table will be available ina later stage， which can be inserted as part of the same transaction. View the Exhibit to examine the commands used to create tables.

Which action would you take to delay the referential integrity checking until the end of the transaction（）
A:Set the constraint to deferred before starting the transaction.
B:Alter the constraint to NOVALIDATE state before starting the transaction.
C:Enable the resumable mode for the session before starting the transaction.
D:Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction.

User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）
A:It fails with a "Resource Busy" error.
B:It deletes the rows successfully because the table is locked in SHARE mode.
C:It fails to delete the records because the table is locked in EXCLUSIVE mode.
D:It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）
A:CLOB
B:BLOB
C:BFILE
D:LONG RAW

You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）
A:You must shut down the database instance to perform the backups.
B:You must configure the Flash Recovery Area （FRA） for the database.
C:You can perform complete database backups without closing the database.
D:All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）
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 tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

Identify two situations in which the block header grows in a data block. （）
A:when row directories need more row entries
B:when there is row migration in the data block
C:when there is an increase in the PCTFREE value for the data block
D:when more transaction slots are required than are initially configured

You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）； Which statement is true？（）
A:When a file is created in DGROUP1 with the template， it would have three-way mirroring.
B:When a file is created in DGROUP1， the MY_TEMP template becomes the default template.
C:When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.
D:When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.
E:When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file Striping.

You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources， respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan， the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources， and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group， MKT_CLERKS， receive， if the DSS_PLAN subplan does NOT consume any CPU resources？（）
A: 45.5
B: 65
C: 70
D: 100

首页 <上一页 131 132 133 134 135 下一页> 尾页