网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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;


参考答案

参考解析
解析: 暂无解析
更多 “单选题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 susanIDENTIFIED by blue;F CREATE OR REPLACE USER susan IDENTIFIED BY blue;” 相关考题
考题 Which statement creates a new user? () A. CREATIVE USER susan;B. CREATIVE OR REPLACE USER susan;C. CREATE NEW USER susan DEFAULTD. CREATE USER susan IDENTIFIED BY blue;E. CREATE NEW USER susan IDENTIFIED BY blue;F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;

考题 USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methodswould you use to achieve this?()A. Use Data Pump to transfer the existing data to a new encrypted tablespaceB. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted

考题 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.

考题 Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?() A.B.C.D.

考题 Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?() A.B.C.D.

考题 Given the following expression about TextField which use a proportional pitch font.  TextField t = new TextField("they are good",40);     Which statement is true?() A、 The displayed string can use multiple fonts.B、 The maximum number of characters in a line will be 40.C、 The displayed width is exactly 40 characters.D、 The user can edit the characters.

考题 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 susanIDENTIFIED by blue;F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;

考题 Which statement is true about the database and database-user used during installation of IMS Server?()A、A preexisting database user may be used but a new database has to be created during installation.B、A preexisting database may be used but a new database user has to be created during installation.C、A preexisting database and user may be used or a new database and user are created during installation.D、A preexisting database and user cannot be used; a new database and user are created during  installation.

考题 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.

考题 You navigate to "UAC" "Infranet Enforcer" "Auth Table Mapping" in the admin GUI. You see one policy, which is the unmodified, original default policy.Which statement is true?()A、Dynamic auth table mapping is not enabled.B、A successful authentication attempt will result in a new authentication table entry, which will be delivered only to the Junos enforcer protecting the network from which the user has authenticated.C、To create a static auth table mapping, you must delete the default policy.D、The default policy applies only to the factory-default role User.

考题 Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()  A、 The SGA Tuning AdvisorB、 The SQL Access AdvisorC、 The SQL Tuning AdvisorD、 The Memory Advisor

考题 Examine the following steps performed on a database instance: 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed()A、The table created by SKD is not accessible and SKD cannot create new tables.B、The tables created by SKD and HR remain, but both cannot create new tables.C、The table created by HR remains and HR still has the CREATE TABLE system privilege.D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

考题 The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?()A、DISPATCHER B、USER C、SERVER D、LGWR E、 DBW0

考题 单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()A The SGA Tuning AdvisorB The SQL Access AdvisorC The SQL Tuning AdvisorD The Memory Advisor

考题 单选题Examine the following steps performed on a database instance:  1:The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2:The SKD usercreates a table.  3:The SKD user grants theCREATETABLE system privilege to the HR user.  4:The HR user creates a table.  5:The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed()A The table created by SKD isnot accessibleand SKD cannot create new tables.B The tables created by SKD and HR remain, but both cannot create new tables.C The table created by HR remains and HR still has the CREATE TABLE system privilege.D The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

考题 单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A Alice onlyB Alice and ReenaC Alice, Reena, and TimberD Sue, Alice, Reena, and Timber

考题 单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()A  The SGA Tuning AdvisorB  The SQL Access AdvisorC  The SQL Tuning AdvisorD  The Memory Advisor

考题 单选题Which statement creates a new user? ()A CREATIVE USER susan;B CREATIVE OR REPLACE USER susan;C CREATE NEW USER susan DEFAULTD CREATE USER susan IDENTIFIED BY blue;E CREATE NEW USER susan IDENTIFIED BY blue;F CREATE OR REPLACE USER susan IDENTIFIED BY blue;

考题 单选题The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?()A DISPATCHER B USER C SERVER D LGWR E  DBW0

考题 单选题You navigate to "UAC" "Infranet Enforcer" "Auth Table Mapping" in the admin GUI. You see one policy, which is the unmodified, original default policy.Which statement is true?()A Dynamic auth table mapping is not enabled.B A successful authentication attempt will result in a new authentication table entry, which will be delivered only to the Junos enforcer protecting the network from which the user has authenticated.C To create a static auth table mapping, you must delete the default policy.D The default policy applies only to the factory-default role User.

考题 单选题Given the following expression about TextField which use a proportional pitch font.  TextField t = new TextField("they are good",40);     Which statement is true?()A  The displayed string can use multiple fonts.B  The maximum number of characters in a line will be 40.C  The displayed width is exactly 40 characters.D  The user can edit the characters.

考题 单选题You issue this SQL statement:  ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’;  What does this SQL statement do?()A It updates the control file with the new location of the data file. B It updates only the data dictionary with the new location of the data file. C It changes the location of the user_data01.dbf file in the operating system. D It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.

考题 单选题Which statement is true about the database and database-user used during installation of IMS Server?()A A preexisting database user may be used but a new database has to be created during installation.B A preexisting database may be used but a new database user has to be created during installation.C A preexisting database and user may be used or a new database and user are created during installation.D A preexisting database and user cannot be used; a new database and user are created during  installation.

考题 单选题Examine the following steps performed on a database instance: 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed()A The table created by SKD is not accessible and SKD cannot create new tables.B The tables created by SKD and HR remain, but both cannot create new tables.C The table created by HR remains and HR still has the CREATE TABLE system privilege.D The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

考题 多选题Given the following code fragment:     public void create() {     Vector myVect;     myVect = new Vector();      }  Which of the following statements are true?()AThe declaration on line 2 does not allocate memory space for the variable myVect.BThe declaration on line 2 allocates memory space for a reference to a Vector object.CThe statement on line 2 creates an object of class Vector.DThe statement on line 3 creates an object of class Vector.EThe statement on line 3 allocates memory space for an object of class Vector.

考题 单选题Your network contains an Active Directory forest.   You set the Windows PowerShell execution policy to allow unsigned scripts on a domain controller in the  network.  You create a Windows PowerShell script named new-users.ps1 that contains the following lines:  new-aduser user1  new-aduser user2  new-aduser user3  new-aduser user4  new-aduser user5  On the domain controller, you double-click the script and the script runs. You discover that the script fails to create the user accounts.   You need to ensure that the script creates the user accounts.   Which cmdlet should you add to the script()A Import-ModuleB Register-ObjectEventC Set-ADDomainD Set-ADUser

考题 多选题USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?()AUse Data Pump to transfer the existing data to a new encrypted tablespaceBUse ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceCUse CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceDEnable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceEEncrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted

考题 单选题Given that the current directory is empty, and that the user has read and write privileges to the current directory, 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.