Oracle认证考试章节练习(2020.01.15)

单项选择题
Given：11.String test = "This is a test"；12.String[] tokens = test.split（"\s"）；13.System.out.println（tokens.length）；What is the result？（）
A.0
B.1
C.4
D.Compilation fails.
单项选择题
Consider the following:Which statement best describes the meaning of the value for the key_len column?（）
A.It shows the total size of the index row
B.It shows how many columns in the index are examined
C.It shows the number of characters indexed in the key
D.It shows how many bytes will be used from each index row
多项选择题
Which three statements are true about persistent configuration?（）
A. A user cannot set privileges on the persistent lightweight jobs
B. Persistent lightweight jobs generate a large amount of metadata
C. It is possible to create fully self-contained persistent lightweight jobs
D. The use of a template is mandatory to create persistent lightweight jobs
E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
单项选择题
如果需要同时执行多个语句，可是使用（）命令定义一组要执行的语句。
A.BAT
B.GROUP
C.RUN
D.EXECUTE
单项选择题
In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）
A.Nothing happens
B.Oracle will automatically switch redo logs when detected
C.Oracle eventually won't allow new records to be added to the database
D.The instance crashes
单项选择题
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
多项选择题
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）
A.archival
B.log writer
C.database writer
D.system monitor
E.process monitor
F.change tracking writer
单项选择题
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）
A. You obtain the results retrieved from the public synonym HR created by the database administrator.
B. You obtain the results retrieved from the HR table that belongs to your schema.
C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
多项选择题
Given： 12. NumberFormat nf = NumberFormat.getInstance（）； 13. nf.setMaximumFractionDigits（4）； 14. nf.setMinimumFractionDigits（2）； 15. String a = nf.format（3.1415926）； 16. String b = nf.format（2）； Which two statements are true about the result if the default locale is Locale.US？（）
A. The value of b is 2.00.
B. The value of a is 3.141.
C. The value of a is 3.14.
D. The value of b is 2.0000.
E. The value of a is 3.1415.
F. The value of a is 3.1416.
G. The value of b is 2.
单项选择题
Which statement is true about the Manageability Monitor （MMON） background process（）
A.It transfers statistics from memory to disk at regular intervals.
B.It coordinates the rebalance activity for disk groups when ASM is used.
C.It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.
D.It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

首页

题库

网课

在线模考

桌面端

Oracle认证考试章节练习(2020.01.15)

Given：11.String test = "This is a test"；12.String[] tokens = test.split（"\s"）；13.System.out.println（tokens.length）；What is the result？（）

Consider the following:Which statement best describes the meaning of the value for the key_len column?（）

Which three statements are true about persistent configuration?（）

如果需要同时执行多个语句，可是使用（）命令定义一组要执行的语句。

In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

Which statement is true about the Manageability Monitor （MMON） background process（）

Oracle认证考试章节练习(2020.01.15)

Given：11.String test = "This is a test"；12.String[] tokens = test.split（"\s"）；13.System.out.println（tokens.length）；What is the result？（）

Consider the following:Which statement best describes the meaning of the value for the key_len column?（）

Which three statements are true about persistent configuration?（）

如果需要同时执行多个语句，可是使用（）命令定义一组要执行的语句。

In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

Which statement is true about the Manageability Monitor （MMON） background process（）

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）