出自:Oracle认证

For which of the following can you use Segment Shrink？（）
A: Heap tables
B: Tables with function-based indexes
C: Indexes
D: Partitions and subpartitions
E: None of the above
What are three benefits of using ASM？（） 
A: Ease of disk administration and maintenance
B: Load balancing across physical disks
C: Software RAID-1 data redundancy with double or triple mirrors
D: Automatic recovery of failed disks
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（） (Choose all that apply.)
A:Backup retention policy
B:Default backup device type
C:Default destinations for backups
D:Multiple backup device types for single backup
E:Default section size for backups
A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）
A:increase the size of redo log files
B:increase the size of the undo tablespace
C:increase the size of the Database Buffer Cache
D:increase the size of the default temporary tablespace
E:enable the retention guarantee for the undo tablespace
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
A:Because row IDs may change during the flashback operation
B:Because the object number changes after the flashback operation
C:Because the rows are retrieved from the recycle bin during the flashback operation
D:Because the table is moved forward and back to a temporary during the flashback operation
To view the results of a manual SQL Tuning Advisor task， which steps should the DBA take？（）  
A: From the Advisor Central home page，select the tuning task from the Advisor Tasks section 
B: From Advisor Central，choose SQL Advisors，SQL Tuning Advisors，Manual Tuning Task Results
C: From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task Results
D: Either B or C
在Oracle中，下面关于簇的描述不正确的是（）。
A:簇是一组表，这些表拥有公共列，并且经常一起使用
B:与每个表及其索引单独存储相比，簇能够提高INSERT语句的性能
C:由于簇表中的所有行都使用相同的列作为公共主键，因此这些列仅为所有表存储一次，从而节省了存储空间
D:经常更新的列不应选作簇键
A team of programmers is involved in reviewing a proposed design for a new utility class. After some discussion, they realize that the current design allows other classes to access methods in the utility class that should be accessible only to methods within the utility class itself. What design issue has the team discovered?（）
A:Tight coupling
B:Low cohesion
C:High cohesion
D:Loose coupling
E:Weak encapsulation
F:Strong encapsulation
What is the default value for the ENABLED attribute of a job or program when it is created? （）
A:TRUE
B:FALSE
C:There is no default. It must be defined at creation time.
D:PENDING
E:NULL
You execute the following command to enable a session in resumable mode： SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended？（）
A:The statements remain suspended for at least 60 seconds.
B:The statements are suspended for 60 seconds and then they are executed.
C:The suspended statements error out if the problem is not rectified within 60 seconds.
D:The statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.
（）程序包用于读写操作系统文本文件。
A:Dbms_output
B:Dbms_lob（图片，电影）
C:Dbms_random
D:Utl_file
View the following SQL statements: You want to back out transaction T2. Which option would you use?（）
A:It is possible, but transaction T3 also backs out.
B:It is possible with the NOCASCADE_FORCE option.
C:It is possible with the NONCONFLICT_ONLY option.
D:It is not possible because it has conflicts with transaction T3.
You are connecting to an Oracle database server from a client by using the following connect string：  SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb  Which naming method is being used in this case？（）
A:Local Naming
B:Easy Connect
C:External Naming
D:Directory Naming
回滚段存放在哪类文件中（）
A:数据文件
B:控制文件
C:重做日志文件
D:归档日志文件
E:警告文件
Which describes the default behavior when you create a table?（）
A:The table is accessible to all users.
B:Tables are created in the public schema.
C:Tables are created in your schema.
D:Tables are created in the DBA schema.
E:You must specify the schema when the table is created.
Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
A:You need to perform the restore and recover operations manually, because the backup was made manually. 
B:First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
C:First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
D:You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 
Which three components does the Scheduler use for managing tasks within the Oracle environment? （）(Choose three.)
A:a job
B:a program
C:a schedule
D:a PL/SQL procedure
Which DBMS_SCHEDULER procedures can be used to enable a program？（）
A: ENABLE
B: ENABLE_PROGRAM
C: VALIDATE_PROGRAM
D: SET_ATTRIBUTE
E: SET_ENABLED
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?（）
A:NLS_LANG
B:NLS_COMP
C:NLS_SORT
D:None of the above
Which two statements regarding the control file and Recover Manager are true？ （）
A:The control file can grow in size.
B:The control file can store RMAN scripts.
C:CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.
D:The RMAN catalog can exist solely in the control file of the target database.
With dynamic service registration， which process registers instance information with the listener？（）
A:SMON
B:PMON
C:shared server
D:dedicated server
Examine the following RMAN command: Which two statements are true regarding the backup taken by using the above RMAN command?（）
A:Only data files and the control file are backed up.
B:Archived redo logs are backed up only I f the database is open during the backup.
C:The backup is deleted after one day, regardless of the default retention policy settings.
D:The backup becomes obsolete after one day, regardless of the default retention policy settings.
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects.  Which statement is true in this scenario（）
A:The statistics collection continues until all objects are processed.
B:The job is terminated and the statistics collected are restored to a time before the job started.
C:This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
D:The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.
如果要设置SQL*PLUS每页打印的数值，则可以使用如下哪个命令（）。
A:SET PAGE
B:PAGESIZE
C:SET PAGESIZE
D:SIZE
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）
A:ASM_POWER_LIMIT
B:ASM_DISKSTRING
C:ASM_DISKGROUPS
D:INSTANCE_TYPE
Which two statements are true regarding the default behavior of the ORDER BY clause? （）
A:Null values are left out of the sort.
B:Character values are displayed from Z to A
C:Date values are displayed with the earliest value first.
D:Null values are displayed last for descending sequences.
E:Numeric values are displayed with the lowest values first.
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables. You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
A:SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B:SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C:SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);
D:You cannot find the information because there is no common column between the two tables.
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）
A:12; only top-level statements and stored procedure events are logged
B:111; top-level statements and all lower-level statements are logged
C:3; only the top-level statements are logged
D:102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
You are managing an ASM instance. You previously issued the following statements：   ALTER DISKGROUP dg1 DROP DISK disk2；  ALTER DISKGROUP dg1 DROP DISK disk3；  ALTER DISKGROUP dg1 DROP DISK disk5；   You want to cancel the disk drops that are pending for the DG1 disk group.  Which statement should you issue？（）  
A: ALTER DISKGROUP dg1 UNDROP disk2，disk3，disk5
B: ALTER DISKGROUP dg1 UNDROP
C: ALTER DISKGROUP dg1 UNDROP DISKS
D: You cannot cancel the pending disk drops
Which two statements about subqueries are true? （）
A:A subquery should retrieve only one row.
B:A subquery can retrieve zero or more rows.
C:A subquery can be used only in SQL query statements.
D:Subqueries CANNOT be nested by more than two levels.
E:A subquery CANNOT be used in an SQL query statement that uses group functions.
F:When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
首页 <上一页 51 52 53 54 55 下一页> 尾页