出自:Oracle认证

Given: What is the result?（）
A:test
B:null
C:An exception is thrown at runtime.
D:Compilation fails because of an error in line 1.
E:Compilation fails because of an error in line 4.
F:Compilation fails because of an error in line 5.
Which three statements describe the functionality of the DO_KEY built-in?（）
A:It accepts both a built-in and a key name as argument. 
B:If no key trigger is defined, the specified built-in executes. 
C:Its parameter must be specified in upper case, enclosed in single quotation marks. 
D:It performs the same task as if you pressed the function key associated with the specified argument. 
E:It executes the key trigger that corresponds to the built-in specified as its parameter. 
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.  The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.  How would you create these jobs？（）
A: Create both jobs by using events raised by the scheduler
B: Create both jobs by using events raised by the application
C: Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D: Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）
A: RMAN would use the current operating system location to place the backup.
B: RMAN would use the control file of the target database to maintain the backup.
C: RMAN would use the recovery catalog of the target database to maintain the backup.
D: RMAN would use the control file of the target database to maintain the backup metadata.
E: RMAN would use the recovery catalog of the target database to maintain the backup metadata.
You issued the following command to mount the DATA disk group in restricted mode：   ALTER DISKGROUP data MOUNT RESTRICT；   What is the implication of this command？（）
A: The client RDBMS instance can access the file as a read-only file.
B: A new disk cannot be added to a disk group.
C: A disk in a disk group can be taken offline.
D: The client RDBMS instance cannot access the files in the disk group.
Which statement correctly describes SQL and /SQL*Plus?（）
A:Both SQL and /SQL*plus allow manipulation of values in the database.
B:/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
C:/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
D:/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
Given: What is the result? （）
A:three
B:other
C:An exception is thrown at runtime.
D:Compilation fails because of an error on line 12.
E:Compilation fails because of an error on line 13.
F:Compilation fails because of an error on line 15.
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（）
A:Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.
B:Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
C:Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
D:Take the USERDATA tablespace offline in ACCOUNTS_PDb.
In which scenarios would you rebuild an index？（）
A: when you need to disable the index usage
B: when you need to change storage options
C: when you need to enable index monitoring
D: when you need to move the index to another tablespace
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）
A: control file
B: all datafiles
C: password file
D: online redo log file
E: archive redo log file
F: server parameter file
G: only the SYSTEM datafile
CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set? （）
A:The DESCRIBE DEPT statement displays the structure of the DEPT table.
B:The ROLLBACK statement frees the storage space occupies by the DEPT table.
C:The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D:The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
Your database initialization parameter file has the following entry：   SEC_MAX_FAILED_LOGIN_ATTEMPTS=3   Which statement is true regarding this setting？（）
A: It drops the connection after the specified number of login attempts fail for any user.
B: It is enforced only if the password profile is enabled for the user.
C: It locks the user account after the specified number of attempts.
D: It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
Given： Which statement is true if a ResourceException is thrown on line 86？（）
A:Line 92 will not execute.
B:The connection will not be retrieved in line 85.
C:The resource connection will not be closed on line 88.
D:The enclosing method will throw an exception to its caller.
You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）
A:The database must be opened in restricted mode.
B:The database must be configured to run in ARCHIVELOG mode.
C:The tablespaces are required to be in backup mode before taking the backup.
D:The tablespaces are required to be in read-only mode before taking the backup
Note the following functionalities of various background processes：  1：Record the checkpoint information in data file headers. CKPT  2：Perform recovery at instance startup. SMON  3：Cleanup unused temporary segments. SMON  4：Free the resources used by a user process when it fails.  5：Dynamically register database services with listeners.  6：Monitor sessions for idle session timeout.  Which option has the correct functionalities listed for a background process（）
A:Archiver Process （ARCn）：1， 2，5
B:System Monitor Process （SMON）：1，4，5
C:Process Monitor Process （PMON）：4，5，6
D:Database Writer Process （DBWn）：1，3，4
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor 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
Evaluate the following code：   SQL>VARIABLE task_name VARCHAR2（255）； SQL>VARIABLE sql_stmt VARCHAR2（4000）； SQL>BEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers  WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’；  DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，  ：task_name， ：sql_stmt）；  END；   What is the outcome of this block of code？（）  
A: It creates a task and workload， and executes the task.
B: It creates a task and workload but does not execute the task.
C: It produces an error because a template has not been created.
D: It produces an error because the SQL Tuning Set has not been created.
在Oracle中，约束可以在DML语句执行之后立即生效，也可以延迟到事务处理提交时才生效。（）语句可以让用户在事务处理中设置延迟约束的强制模式。
A:set constraint
B:set transaction
C:take constraint
D:take transaction
Note the functionalities of various background processes：  1：Perform recovery at instance startup. SMON  2：Free the resources used by a user process when it fails. PMON  3：Cleanup the database buffer cache when a process fails. PMON  4：Dynamically register database services with listeners. PMON  5：Monitor sessions for idle session timeout. PMON  6：Cleanup unused temporary segments. SMON  7：Record the checkpoint information in control file. CKPT  Which option has the correct functionalities listed for a background process（）
A:Checkpoint （CKPT）： 1， 2， 5
B:System Monitor （SMON）： 1， 6
C:Process Monitor （PMON）： 4， 6， 7
D:Database Writer （DBWR）： 1， 3， 4
When an ASM instance receives a SHUTDOWN NORMAL command，what command does it pass on to all database instances that rely on the ASM instances disk groups？（）
A: TRANSACTIONAL
B: IMMEDIATE
C: ABORT
D: NORMAL
View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instanceis already running. You used the following steps to start the database instance and open the database：   Which file is used to start the instance in this case（）
A:init.ora
B:spfile.ora
C:initorcl.ora
D:spfile+ASM.ora
Which two statements are true when row archival management is enabled?（）
A:The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
B:The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
C:The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
D:The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
E:The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）
A: The target database must be in the MOUNT mode to ensure restoration of the datafiles.
B: You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
C: The control file must be recreated.
D: The database must be opened with the RESETLOGS option.
Which two are characteristics of user-managed backup and recovery operations？（）
A:Recovery is initiated using SQL*Plus.
B:Database files are backed up using SQL commands.
C:Database files are backed up with Recovery Manager.
D:Database files are restored using Recovery Manager.
E:Database files are backed up using operating system commands.
Which are DML statements? （）
A:COMMIT…
B:MERGE…
C:UPDATE…
D:DELETE…
E:CREATE…
F:DROP…
Which statement creates a new user? （）
A:CREATIVE USER susan;
B:CREATIVE OR REPLACE USER susan;
C:CREATE NEW USER susan DEFAULT
D:CREATE USER susan IDENTIFIED BY blue;
E:CREATE NEW USER susan IDENTIFIED BY blue;
F:CREATE OR REPLACE USER susan IDENTIFIED BY blue;
Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database：   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case？（）
A:a， b， e， c
B:b， e， d
C:a， b， d， c
D:b， g， c， f
E:a， b， d， f
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables. You want to retrieve all employees' last names, along with their managers' last names and their department names. Which query would you use?（）
A:SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN departments d ON (e.department_id = d.department_id);
B:SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
C:SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id); 
D:SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E:SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
F:SELECT last_name, manager_id, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id) ;
Examine the structure of the EMPLOYEES table: You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?（）
A:CREATE INDEX NAME_IDX (first_name, last_name);
B:CREATE INDEX NAME_IDX (first_name AND last_name);
C:CREATE INDEX NAME_IDX   ON (first_name, last_name);
D:CREATE INDEX NAME_IDX   ON employees (first_name AND last_name);
E:CREATE INDEX NAME_IDX   ON employees(first_name, last_name);
F:CREATE INDEX NAME_IDX   FOR employees(first_name, last_name);
Which statements are true regarding system-partitioned tables？（）  
A: Only a single partitioning key column can be specified.
B: All DML statements must use partition-extended syntax.
C: The same physical attributes must be specified for each partition.
D: Unique local indexes cannot be created on a system-partitioned table.
E: Traditional partition pruning and partitionwise joins are not supported on these tables.
首页 <上一页 144 145 146 147 148 下一页> 尾页