出自:Oracle认证

（）是一组Oracle进程和SGA。
A:实例
B:数据库
C:表空间
D:实体化视图
Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?（）
A:Define the POWER option while adding or removing the disks
B:Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
C:Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
D:Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
Given： What is the result？（）
A:X， followed by an Exception.
B:No output， and an Exception is thrown.
C:Compilation fails due to an error on line 14.
D:Compilation fails due to an error on line 16.
E:Compilation fails due to an error on line 17.
In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？（）
A:increase the size of the redo log buffer
B:increase the number of redo log groups
C:increase the number of log writer processes
D:increase the number of ARCn processes
E:change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）
A:USER_CONSTRAINTS
B:USER_OBJECTS
C:ALL_CONSTRAINTS
D:USER_CONS_COLUMNS
E:USER_COLUMNS
You received these error messages because the client cannot find the desired database：   ORA-12198： TNS：could not path to destination  ORA-12203： TNS：unable to connect to destination  Which action would be appropriate in helping to resolve the errors？（）
A:A
B:B
C:C
Given： Which code fragment， inserted at line 23， allows the code to compile？（）
A:df = new DateFormat（）；
B:df = Date.getFormat（）；
C:df = date.getFormat（）；
D:df = DateFormat.getFormat（）；
E:df = DateFormat.getInstance（）；
ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）
A:vector 
B:database view 
C:database table 
D:transactional trigger 
E:PL/SQL table of records 
F:multi-dimensional array
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems？（） 
A: ADR diagnostic files
B: all the optimizer statistics
C: initialization parameter settings
D: PL/SQL functions，procedures，and packages
E: the table and index definitions and actual data
Which two statements are true regarding transactions in an Oracle database（）
A:Multiple transactions can use the same undo segment.
B:A transaction is assigned an undo segment when it is started.
C:More than one transaction cannot share the same extent in the undo tablespace.
D:The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
You want to create a role to meet these requirements：  1：The role is to be protected from unauthorized usage.  2：The password of the role is not to be embedded in the application source code or stored in a table.  Which method would you use to restrict enabling of such roles（）
A:Create the role with global authentication.
B:Create the role with external authentication.
C:Create the role as a secure application role.
D:Create the role as a password-protected role.
E:Create a role and use Fine-Grained Access Control （FGAC） to secure the role.
Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）  
A: It executes successfully but partition pruning cannot happen for this partition key.
B: It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C: It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 
D: It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
Given: What is the result?（）
A:0
B:1
C:2
D:3
E:4
F:Compilation fails.
G:An exception is thrown at runtime.
Given: What is the result?（）
A:end
B:Compilation fails.
C:exception end
D:exception test end
E:A Throwable is thrown by main.
F:An Exception is thrown by main.
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: Which two statements are true about redefining the table?（）
A:All the triggers for the table are disabled without changing any of the column names or column types in the table.
B:The primary key constraint on the EMPLOYEES table is disabled during redefinition.
C:VPD policies are copied from the original table to the new table during online redefinition.
D:You must copy the VPD policies manually from the original table to the new table during online redefinition.
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）  
A: Initiate an incomplete recovery operation using RMAN.
B: Copy the table from a development database.
C: Advise the user to rekey the data.
D: Perform a Flashback Drop operation.
E: Perform a Flashback Recovery operation.
You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually.  Which action should you take to enable archiving at instance startup？（）
A:A
B:B
C:C
D:D
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
A:Restore all the data files and open the database
B:Create the data file and perform tablespace recovery
C:No need to restore any file， just recover the database
D:Restore only the system data file and recover the database
E:Restore only lost date file and performtablespacerecovery
To increase the availability of an Advanced Replication environment， you can add a new master to a replication group without quiescing the group. This is achieved（）.
A:Only when the new master site already has existing replication groups. 
B:By issuing a single command to create, populate, and activate the new master. 
C:When the master definition site is not the same for all of the master groups. 
D:Without impacting end users who are executing data manipulation language (DML) commands on the replicated tables.
Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a connection event that has used external authentication?（）
A:The attribute "STATUS" is set to the string EXTERNAL_AUTH
B:The attribute "PRIV_USER" contains the username
C:The event type that is given in the attribute "NAME" is EXTERNAL_AUTH
D:There is no differentiation between native and external authentication events
E:External authentication is managed through external auditing logs
F:The "PROXY_PRIV" user shows a username if external authentication is used
在Oracle中，以下不属于集合操作符的是（）。
A:UNION
B:SUM
C:MINUS
D:INTERSECT
You issue the following RMAN command to set a retention policy on a database：       RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of the above command？（）
A: After two days， the backup will be marked obsolete.
B: After two days， the backup will be deleted from the media.
C: If the RMAN repository has records of two or more recent backups of a file， then the older backup will be deleted from the media.
D: If the RMAN repository has records of two or more recent backups of a file， then the older backup will be marked obsolete.
Which two statements are true about the Automatic Diagnostic Repository (ADR)?（）
A:The ADR base keeps all diagnostic information in binary format
B:SQL*Plus provides the ADRI script, which can be used to work with ADR
C:The ADR can be used for problem diagnosis only when the database is open
D:The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E:The ADR can be used for problem diagnosis even when the database instance is down
F:The ADR base is shared across multiple instances
假设需要在Windows的命令行工具中使用侦听器工具，可以在命令行中输入以下（）命令。
A:LISTNER
B:LSNR
C:LSNRCTL
D:LSTN
When importing a table into a database，the import process performs these tasks：  1. Triggers are imported.  2. Data is imported.  3. New tables are created.  4. Indexes are built.  5. Any bitmap， functional， and/or domain indexes are built.  6. Integrity constraints are enabled on the new tables.  Which option shows the tasks in the order in which they are performed？（）
A:2，3，4，1，6，5
B:3，2，4，1，6，5
C:3，2，6，4，1，5
D:4，2，3，1，5，6
What does the SCN represent?（）
A:The system change number, which is a point in time relative to transactions within a given database. 
B:A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases. 
C:The security change number, which represents the security code that is needed to access any database structure.
D:A conversion factor that converts internal database time to external clock time. 
E:UTC time in the database, providing a standardized way of tracking time in Oracle. 
You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are  notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks.  Which two actions could you take to prevent this locking problem in the future（）
A:Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
B:Use Database Resource Manager to automatically log out sessions that block others and are idle.
C:Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
D:Decrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.（）
A:3，2，1，4
B:2，3，4，1
C:4，1，3，2
D:3，2，4，1
以下关于SQL的说法正确的是（）
A:SQL是一种过程化的语言，可实现各种流程控制
B:SQL是ORACLE所独有数据库操作语言
C:SQL是一种数据库的驱动程序
D:SQL是一种非过程化的语言，也是数据库的工业标准
E:SQL是一种结构化和过程化相结构的语言
Which syntax turns an existing constraint on?（）
A:ALTER TABLE table_name ENABLE constraint_name;
B:ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;
C:ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;
D:ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
首页 <上一页 16 17 18 19 20 下一页> 尾页