User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第1题:
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?()
A. User process
B. Server process
C. System Monitor (SMON)
D. Process Monitor (PMON)
E. Checkpoint process (CKPT)
第2题:
在Oracle中,用ALTER将scott的口令改为hello,下列哪个是正确的?( )
A.ALTER USER scott IDENTIFIED BY hello
B.ALTER scott USER IDENTIFIED BY hello
C.ALTER USER scott IDENTIFIED AS hello
D.ALTER USER hello IDENTIFIED BY scott
第3题:
在Oracle中,将scott的资源文件改为otherprofile,下列哪个是正确的?( )
A.ALTER PROFILE USER scott otherprofile
B.ALTER otherprofile USER scottPROFILE
C.ALTER USER scott PROFILE otherprofile
D.ALTER scott USER PROFILE otherprofile
第4题:
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
第5题:
For which database operation would you need the database to be in the MOUNT state()
第6题:
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
第7题:
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement: SQL> DROP TABLE SCOTT.EMP PURGE; After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()
第8题:
A. ALTER DATABASE FLASHBACK ON;
B. GRANT SELECT any transaction TO scott;
C. GRANT EXECUTE ON dbms_flashback TO scott;
D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
第9题:
In your database,the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first?()
第10题:
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()