出自:Oracle认证

Examine the following commands and their output: SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 1050 QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES'; 1 row updated. SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 2310 View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?（）
A:Flashback logging is not enabled for the database.
B:The changes made to the table are not committed.
C:Supplemental logging is not enabled for the database.
D:The database is not configured in ARCHIVELOG mode.
Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)
A:A single SQL statement provided by a user
B:An existing SQL Tuning Set (STS)
C:A preprocessed Database Replay workload
D:A schema name
E:SQL statement identified in EM as using excessive resources
Automatic data conversion will occur if which of the following happens?（）
A:The client and server have different NLS_LANGUAGE settings.
B:The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
C:The client and server are in different time zones.
D:The client requests automatic data conversion.
E:The AUTO_CONVERT initialization parameter is set to TRUE.
You want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）
A:NLSLANG
B:NLSLENGTHSEMANTICS
C:NLSTERRITORY
D:NLSLANGUAGE
E:NLSCHARACTERSET
F:NLSDATELANGUAGE
G:NLSNCHARCHARACTERSET
Which built-in do you use to determine which timer in form module has expired?（）
A:FIND_TIMER 
B:GET_TIMER_PROPERTY
C:GET_APPLICATION_PROPERTY 
D:GET_CUSTOM_ITEM_EVENT_PROPERTY
A developer is creating a class Book, that needs to access class Paper. The Paper class is deployed in a JAR named myLib.jar. Which three, taken independently, will allow the developer to use the Paper class while compiling the Book class?（）
A:The JAR file is located at $JAVA_HOME/jre/classes/myLib.jar.
B:The JAR file is located at $JAVA_HOME/jre/lib/ext/myLib.jar..
C:The JAR file is located at /foo/myLib.jar and a classpath environment variable is set that includes /foo/myLib.jar/Paper.class.
D:The JAR file is located at /foo/myLib.jar and a classpath environment variable is set that includes /foo/myLib.jar.
E:The JAR file is located at /foo/myLib.jar and the Book class is compiled using javac -cp /foo/myLib.jar/Paper Book.java.
F:The JAR file is located at /foo/myLib.jar and the Book class is compiled using javac -d /foo/myLib.jar Book.java
G:The JAR file is located at /foo/myLib.jar and the Book class is compiled using javac -classpath /foo/myLib.jar Book.java
You are using Resource Manager to manage system resources. While creating a new database user， you observe that the user is a member of DEFAULT_CONSUMER_GROUP by default. What would be the implications of this？（）
A:The Resource Manager plan does not affect the user.
B:There must be a plan directive in any of the plans of the group to control the resources.
C:The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.
D:The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.
E:The members of this group can change their group without the database administrator’s intervention.
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）
A: Recovery catalog
B: Oracle Enterprise Manager Repository
C: Automatic Workload Repository （AWR）
D: Oracle 10g Enterprise Manager Grid Control
E: Automatic Database Diagnostic Monitor （ADDM）
You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）
A:The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
B: The command will not execute successfully because resumable space allocation is enabled at the session level.
C: The command will execute successfully and resumable space will be allocated at the session level.
D: The command will execute successfully and resumable space will be allocated at the instance level.
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
A:The database will open, and the tablespace automatically comes out of the backup mode
B:The database will be mounted, and recovery must be performed on the USERS tablespace.
C:The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
D:The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
在Oracle中，下列哪种标量类型不能保存到数据库表中（）。
A:CHAR
B:RAW
C:DATE
D:BOOLEAN
Which object privileges can be granted on a view? （）
A:none
B:DELETE, INSERT,SELECT
C:ALTER, DELETE, INSERT, SELECT
D:DELETE, INSERT, SELECT, UPDATE
You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）
A:control file
B:password file
C:listener controller file
D:control file and password file
如果创建的表其主键可以自动编号，则应该为主键创建的索引是（）索引。
A:反向索引
B:B树索引
C:位图索引
D:基于函数的索引
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
A:uses undo data for roll forward
B:uses Flashback Log for recovery
C:uses online redo logs to roll back
D:uses undo data to roll back the transaction
E:uses Recovery Manager （RMAN） to roll back
F:uses the System Monitor （SMON） background process to perform instance recovery
You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） to perform backups in your databases.  Which four backup operations can be performed using RMAN？（）
A:A backup of the target database when it is mounted
B:A backup of online redo log files when the database is open
C:A backup of only used data blocks in the file beingbeingbackup up
D:A backup of online， read/write data files when the database is open
E:A backup of only those data blocks that have changed since a previous backup
F:A backup of online， read/write data files when the database is in the NOMOUNT state.
Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）
A:The database opens normally.
B:The database prompts for a database recovery.
C:The database writer writes to a trace file， indicating that the temporary file is not found.
D:The database gets mounted and throws an error indicating that the temporary file requires recovery.
在Oracle中，可用于提取日期时间类型特定部分（如年、月、日、时、分、秒）的函数有（）。
A:DATEPART
B:EXTRACT
C:TO_CHAR
D:TRUNC
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed? （）
A:0
B:1
C:0.00
D:An error statement
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（）
A:Alert log file
B:Archived redo log files
C:Control file autobackups
D:Server Parameter file (SPFILE)
E:Recovery Manager (RMAN) backup piece
You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover？（）
A: all the datafiles in the database
B: the datafiles associated with the SYSTEM tablespace
C: the datafiles associated with the DATA1 tablespace
D: all the datafiles in the database except those associated with the DATA1 tablespace
Which two outcomes result when a domain is created in development mode?（）
A:WebLogic server starts automatically upon the restarting of the machine
B:each new cluster will automatically be created with two managed servers
C:boot.properties file automatically stored  
D:creation of an auto deploy folder used for the application to deploy automatically
E:Node Manager will be automatically configured
Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion？（）
A: The database must be in read-write mode.
B: The database must have no external files.
C: The database must open in read-only mode.
D: The database must be mounted but not opened.
Examine the command：  SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）
A:Automatic statistics collection is stopped for the CUSTOMERS table.
B:Statistics for the CUSTOMERS table are locked and cannot be overwritten.
C:Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
D:Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.
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
Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）
A:As ASM instance mounts an ASM control file
B:An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C:Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
D:An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
Given： 10. interface Jumper { public void jump（）； } ...   20. class Animal {} ...   30. class Dog extends Animal {   31. Tail tail；   32. }   ...   40. class Beagle extends Dog implements Jumper{   41. public void jump（） {}  42. }   ...   50. class Cat implements Jumper{   51. public void jump（） {}   52. }. Which three are true？（）
A: Cat is-a Jumper
B: Cat is-a Animal
C: Dog is-a Jumper
D: Dog is-a Animal
E: Beagle has-a Jumper
F: Cat has-a Animal
G: Beagle has-a Tail
What does the TRUNCATE statement do?（）
A:Removes the table
B:Removes all rows from a table
C:Shortens the table to 10 rows
D:Removes all columns from a table
E:Removes foreign keys from a table
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
A:FORMS_DDL 
B:DO_SQL 
C:FORM_SUCCESS 
D:FORM_NOT_SUCCESS
E:DBMS.ERROR_CODE
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）
A:It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
B:It fails because no SQL *Loader data file location is specified.
C:It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
D:It fails because no SQL *Loader control file location is specified.
首页 <上一页 26 27 28 29 30 下一页> 尾页