出自:Oracle认证

As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?（）
A:CKPT
B:SMON
C:MMON
D:DBWR
When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics.  Which two statements describe the implications of this？（）
A: It produces less accurate results of the comparison analysis.
B: It automatically calls the SQL Tuning Advisor for recommendations.
C: It shortens the time of execution and reduces the impact on system resources.
D: Only the changes in the execution plan，and not performance regression，are detected.
Given: What is the result?（）
A:2
B:3
C:4
D:6
E:7
下列哪个不是有效的数据库状态？（）
A:开机
B:关闭
C:启动
D:装载
E:不装载
Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature？（）
A: RSTLNE
B: NLSRTL
C: LISTENER
D: NLSSORT
E: Linguistic sorts
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）
A: Enable Flashback Data Archive for the tables.
B: Specify undo retention guarantee for the database.
C: Enable supplemental logging for the database.
D: Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
E: Create Flashback Data Archive on the tablespace on which the tables are stored.
You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）
A:Assign the DEFAULT profile to the users
B:Set the RESOURCE_LIMIT parameter to TRUE in the parameter file
C:Create a new profile with CPU restrictions and assign it to the users
D:Specify the users as members of the DEFAULT_CONSUMER_GROUP
E:Revoke the DBA role and grant CONNECT and RESOURCE role to the users
You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
A: It would return information regarding only the last committed transaction.
B: It would return only the active transactions in all the undo segments in the database.
C: It would return only the committed transactions in all the undo segments in the database.
D: It would return both active and committed transactions in all the undo segments in the database.
E: It would return information regarding the transactions that began and were committed in the last 30 minutes.
Which three tasks can be performed using a duplicate database？（）
A: Testing the backup and recovery procedures
B: Testing the upgrade of an Oracle database to a new release
C: Testing the effect of an application changes on database performance
D: Continuously updating archive log files from the target database to support failover
Given: What is the result?（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The code executes and prints "running".
D:The code executes and prints "runningrunning".
E:The code executes and prints "runningrunningrunning".
Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?（）
A:It implements High Availability by using the .NET Connector's' load balancing capabilities
B:It is shared-nothing architecture
C:It is provided by means of IP- level disk replication
D:It relies on the shared disk architecture being visible to both servers
Given a method that must ensure that its parameter is not null： What， inserted at line 12， is the appropriate way to handle a null value？（）
A:assert value == null；
B:assert value != null， "value is null"；
C:if （value == null） { throw new AssertionException（"value is null"）； }
D:if （value == null） { throw new IllegalArgumentException（"value is null"）； }
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);
A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output: Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') ' Skip_Counter: 0 Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1 You execute a "SHOW CREATE TABLE mytable" on the slave: CREATE TABLE 'mytable' ( 'ID' int(11) NOT NULL DEFAULT '0', 'name' char(10) DEFAULT NULL, PRIMARY KEY ('ID') ) The table mytable on the slave contains the following: You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?（）
A:SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
B:SET GLOBAL enforce_gtid_consistency=ON
C:SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9"
D:SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
E:SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）
A:ARCn
B:CKPT
C:DBWn
D:LGWR
E:PMON
F:SMON
A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）
A:SYS sessions, regardless of the roles that are set in the session
B:SYSTEM sessions, regardless of the roles that are set in the session
C:SCOTT sessions, only if the MGR role is set in the session
D:SCOTT sessions, only if the MGR role is granted to SCOTT
E:SCOTT sessions, because he is the owner of the table
F:SYSTEM session, only if the MGR role is set in the session
You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）
A:functions
B:packages
C:procedures
D:database triggers
E:anonymous PL/SQL block
Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHIVELOG mode.  Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN> STARTUP MOUNT  2. RMAN> RESTORE DATABASE;  3. RMAN> （）  4. RMAN> ALTER DATABASE OPEN; 
A:RECOVER DATABASE；
B:SWITCH DATAFILE ALL；
C:RESTORE CONTROL FILE；
D:RECOVER DATABASE USING BACKUP CONTROL FILE；
Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?（）
A:Implement RMAN multiplexing
B:Set the DEBUG ON in the RMAN script
C:Specify the command ID in the RMAN script
D:Use a tag with the RMAN BACKUP command
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?（）
A:A
B:B
C:C
D:D
You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）
A:the CONVERT command of RMAN
B:Data Pump Export and Import into the same database
C:conventional export and import into the same database
D:the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
E:the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
每个运行的Oracle数据库都与Oracle实例相联系。当一个数据库服务器上的数据库启动时，Oracle将分配内存区，称为（），启动一个或者多个Oracle进程。
A:程序全局区
B:系统全局区
C:临时表空间
D:回滚表空间
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: /＞ mysqld – install Mysql56 – defaults – file = C :/my –opts.cnf What is the expected outcome?（）
A:Mysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration file
B:An error message is issued because – install is not a valid option for mysqld
C:A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnf
D:Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file
用于删除表中所有数据行的命令是（）。
A:DELETE TABLE
B:TRUNCATE TABLE
C:DROP TABLE
D:ALTER TABLE
You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance， you notice that the system identifier （SID） for the instance is set to ’+ASM’. What is the purpose of this instance？（）
A: This instance is being used to manage the operating system files.
B: This instance is being used to manage the files of other databases.
C: This instance is being used to manage the instances of other databases.
D: This instance is being used to manage the background processes of other instances.
哪一个表空间不能切换为脱机状态（）
A:临时表空间TEMP
B:用户表空间USER
C:索引表空间INDEX
D:系统表空间SYSTEM
Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）
A:PMON
B:SMON
C:CKPT
D:LGWR
E:ARCn
Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）
A:until the last commit
B:cannot be recovered
C:until the last offline backup
D:until the beginning of the last transaction
What does the Fast Connection Failover feature of Active GridLink for RAC provide?（）
A:instant notification of a RAC node failure so applications never have to retry a transaction that was sent to a node that failed during the transaction
B:near-instant notification of the failure of a RAC node failure that minimizes the possibility connection to a failed node being provided to an application
C:application level notification of a failed RAC node such that an application can retry a transaction if required
D:faster failover for Multi Datasources
E:guaranteed transaction high availability when interacting with an Oracle RAC Database
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid? （）
A:DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B:DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
C:DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'
D:DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'
首页 <上一页 80 81 82 83 84 下一页> 尾页