Oracle认证考试

Which statement creates a new user?()A、CREATE USER susan;B、CREATE 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 B

题目

Which statement creates a new user?()

  • A、CREATE USER susan;
  • B、CREATE 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;
参考答案和解析
正确答案:D
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Given that the current directory is empty, and that the user has read and write privileges to the current, and the following:Which statement is true?()

A.Compilation fails.

B.Nothing is added to the file system.

C.Only a new file is created on the file system.

D.Only a new directory is created on the file system.

E.Both a new file and a new directory are created on the file system.


参考答案:B

第2题:

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?()

A.

B.

C.

D.


参考答案:A

第3题:

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;


参考答案:D

第4题:

Which of the following will begin a new unit of work?()

  • A、The CONNECT statement
  • B、The first FETCH of a cursor
  • C、The BEGIN TRANSACTION statement
  • D、The first executable SQL statement

正确答案:D

第5题:

Which of the following shows the proper rhythmical pattern of the sentence?

A.′Come to ′see us at our ′new a′partment.
B.′Come to ′see us at′our new ′apartment.
C.′Come to ′see us ′at our ′new ′apartment.
D.′Come to ′see us ′at our ′new a′partment.

答案:A
解析:
考查句子重读。一般来说,句子中的实词需要重读,比如名词、动词、形容词、副词、数词等。虚词多数情况下不重读,比如冠词、介词、物主代词(形容词性)、连词、感叹词等。故A项正确。

第6题:

Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?()

A.

B.

C.

D.


参考答案:A

第7题:

Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()

A. SER_NO

B. ORDER_ID

C. STATUS

D. PROD_ID

E. ORD_TOTAL

F. Composite index on ORDER_ID and ORDER_DATE


参考答案:A, F

第8题:

Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?()

A. It collects statistics into the pending area in the data dictionary

B. It creates a virtual hidden column in the CUSTOMERS_OBE table

C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT

D. It creates a histogram to hold skewed information about the data in the columns


参考答案:B

第9题:

The IBM Maximo Asset Management V6.2 administrator creates a new Start Center with updated Key Performance Indicators.  Which application must be used to associate the Start Center to users? ()

  • A、 Users
  • B、 People
  • C、 Organizations
  • D、 Security Groups

正确答案:D

第10题:

Given the following code fragment:     public void create() {     Vector myVect;     myVect = new Vector();      }  Which of the following statements are true?() 

  • A、 The declaration on line 2 does not allocate memory space for the variable myVect.
  • B、 The declaration on line 2 allocates memory space for a reference to a Vector object.
  • C、 The statement on line 2 creates an object of class Vector.
  • D、 The statement on line 3 creates an object of class Vector.
  • E、 The statement on line 3 allocates memory space for an object of class Vector.

正确答案:A,D,E

更多相关问题