出自:Oracle认证

Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（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 OID columnin the SYSTEM tablespace.
Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）
A: ALTER DATABASE DROP LOGFILE GROUP 1
B: ALTER DATABASE CLEAR LOGFILE GROUP 1
C: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
D: ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
In the area of Performance Management and Diagnostics, which feature is supported in Oracle  Enterprise Manager 12C?（）
A:Search information in logs across multiple domains
B:View different log information in single console location
C:Save current performance data as baseline to be used in comparison with future data
D:Provides single dashboard across multi-tier composite application
How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed？（）  
A: Issue the ALTER DISKGROUP ... ADD DISK command.
B: Issue the ALTER DISKGROUP ... UNDROP DISKS command.
C: Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.
D: Retrieve the disk from the Recycle Bin after the operation completes.
Which statement is true about the log-output variable?（）
A:It is a static variable and can be set only at MySQL server startup
B:It enables and starts the General Query Log
C:It sets the target location for the binary logs generated by the MySQL sever
D:It specifies output destinations for the slow and General Query logs
You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）
A: BACKUP AS BACKUPSET
B: BACKUP AS COPY
C: BACKUP AS COMPRESSED BACKUPSET
D: BACKUP INCREMENTAL LEVEL n CUMULATIVE
Given: What is the result when method testIfA is invoked?（）
A:True
B:Not true
C:An exception is thrown at runtime.
D:Compilation fails because of an error at line 12.
E:Compilation fails because of an error at line 19.
DRAG DROP Click the Task button.
Given：   12. System.out.format（"Pi is approximately %d."， Math.PI）；   What is the result？（）
A: An exception is thrown at runtime.
B: Pi is approximately 3.
C: Pi is approximately 3.141593.
D: Compilation fails.
The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt.  With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）
A:time­based recovery
B:log sequence recovery
C:cancel­based recovery
D:change­based recovery
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？（）
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
To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）
A:It contains only the plan for the SQL statement executed by the user.
B:It contains the SQL text executed by the user and the bind variables used with it.
C:It contains the plan and statistics associated with the SQL statement executed by the user.
D:It contains the plan for the SQL statement executed by the user and the bind variables used with it.
Which  kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
A:Failure when no standby database is configured
B:Failure because a data file is renamed accidentally
C:Failure that requires no archive logs to be applied for recovery
D:Failure due to loss of connectivity-for example， an unplugged disk cable
对于Check约束，下面说法错误的是（）。
A:在CHECK约束的表达式中必须引用到表中的一个或多个字段，并且表达式的计算结果必须是一个布尔值。
B:可以在表级定义CHECK约束
C:不能在字段级定义CHECK约束
D:对同一个字段可以定义多个CHECK约束，同时也可以定义NOT NULL约束
Click the Exhibit button. What is the output of the program shown in the exhibit？（）
A:300-100-100-100-100
B:300-300-100-100-100
C:300-300-300-100-100
D:300-300-300-300-100
在PL/SQL中定义一个可以存放雇员表（EMP）的员工名称（ENAME）的PL/SQL表类型，应该（）
A:type array arr_type[emp.ename%type] index by binary_integer;
B:type table arr_type[emp.ename%type] index by binary_integer;
C:type arr_type is table of emp.ename%type index by binary_integer;
D:type arr_type is pl_sql table of emp.ename%type index by binary_integer;
You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）
A: creating a table in your schema and you exceed your allocated space quota on the tablespace
B: executing a long query that involves a sort operation and the statement runs out of temporary space
C: loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
D: creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
Evaluate the SQL statement: TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
A:It releases the storage space used by the table.
B:It does not release the storage space used by the table.
C:You can roll back the deletion of rows after the statement executes.
D:You can NOT roll back the deletion of rows after the statement executes.
E:An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F:You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.
Given: What is the result?（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:[608, 609, 610, 612] [608, 610]
D:[608, 609, 610, 612] [608, 609, 610]
E:[606, 608, 609, 610, 612] [608, 610]
F:[606, 608, 609, 610, 612] [608, 609, 610]
You are creating a new form for the Order Entry application. You define a record group that will be created when the form is executing this built in: CREATE_GROUP(rg_emplist, global_scope) Which form(s) in the application will have access to this record group?（）
A:All forms in the application. 
B:Any forms opened by the user who initiated the record group. 
C:Only the form issuing the CREATE_GROUP built-in. 
D:Any forms referenced by the form that contains the procedure.
Which two statements are true about Oracle Real Applications Insight ？（）
A: it provides enhanced visibility across the entire application infrastructure 
B: it provides a set of management tools that enable automation of configuraion
C: it significantly increases the performance of Web-based applications with no code change
D: it dramatically reduces costs associated with diagnostics， configuration， and deployment on production servers 
In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead.  What kind of database structure would you use to reduce the response time of the query？（） 
A:hash clusters
B:index clusters
C:partitioned tables
D:index-organized table （IOT）
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?（）
A:The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
B:Setting the target tablespace to read-only
C:The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
D:Setting the target tablespace offline
E:The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）
A: RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
B: RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
C: RMAN would relocate all the database files to an ASM disk group.
D: RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）
A:Take the USERS tablespace offline and re-create the lost data file.
B:Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
C:Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
D:Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  
A: You cannot perform the TSPITR with the constraints enabled.
B: You must perform the TSPITR recovery of both tablespaces for it to be successful.
C: You can perform TSPITR only on the USERS tablespace.
D: RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.
E: The TSPITR will only be successful if the constraint is enabled.
在SQL*PLUS环境中，若想通过执行PL/SQL代码来显示指定的字符串，应该首先做哪项设置（）
A:set echo on
B:set output on
C:set serveroutput on
D:set dbms_output on
E:set server_output on
You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）
A:You get an error because of a primary key violation.
B:The data and structure of the EMPLOYEES table are deleted.
C:The data in the EMPLOYEES table is deleted but not the structure.
D:You get an error because the statement is not syntactically correct.
A common approach to solve application performance issues is to add more hardware. Which two  reasons describe why this alone does not always solve performance problems?（）
A:There may be a bottleneck in the application that additional hardware would not solve.
B:Adding more hardware is costly and time consuming.
C:Adding hardware at the application layer may place additional load on an already overloaded database, network appliance, or storage system.
D:Adding more hardware may introduce new configuration requirements that need to be tested.
You decided to change the location of the flash recovery area. You executed the following command：   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；   Which statement is true？（）
A: The location can be changed only if the flash recovery area is empty.
B: After executing the command， all new flash recovery area files will be created in the new location.
C: The command will generate an error because you cannot change the flash recovery area while the database is open.
D: All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.
首页 <上一页 85 86 87 88 89 下一页> 尾页