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

题目内容 (请给出正确答案)
单选题
You issued the following statement in your SQL*Plus session:   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()
A

 creating a table in your schema and you exceed your allocated space quota on the tablespace

B

 executing a long query that involves a sort operation and the statement runs out of temporary space

C

 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

D

 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error


参考答案

参考解析
解析: 暂无解析
更多 “单选题You issued the following statement in your SQL*Plus session:   SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()A  creating a table in your schema and you exceed your allocated space quota on the tablespaceB  executing a long query that involves a sort operation and the statement runs out of temporary spaceC  loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD  creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error” 相关考题
考题 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 processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)

考题 From SQL*Plus, you issue this SELECT statement:You use this statement to retrieve data from a data table for()。 A. UpdatingB. ViewingC. DeletingD. InsertingE. Truncating

考题 You issued the following statement:   SQL ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1;   Which parameter is NOT overridden by using the above statement?()  A、 the value of the NLS_LANGUAGE variableB、 the value of the NLS_TERRITORY variableC、 the value of the NLS_CURRENCY variableD、the character encoding scheme used by the client application

考题 You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?()A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued

考题 From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for ().A、UpdatingB、ViewingC、DeletingD、InsertingE、Truncating

考题 You issued the following statement:  SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  What will be the result of issuing the statement?()  A、 The control file will be multiplexed.B、 The control file will be recreated.C、The script containing the CREATE CONTROLFILE statement will be created.D、 The binary backup of the control file will be created.

考题 You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?()A、All data along with the table structure is deleted B、The pending transaction in the session is committed C、All indexes on the table will remain but they are invalidated D、All views and synonyms will remain but they are invalidated E、All data in the table are deleted but the table structure will remain

考题 You issued the following statement in your SQL*Plus session:   SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()A、 creating a table in your schema and you exceed your allocated space quota on the tablespaceB、 executing a long query that involves a sort operation and the statement runs out of temporary spaceC、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

考题 You issued the following statement:   SQLALTER 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.

考题 Examine the following commands executed in your database: SQL ALTER SESSION RECYCLEBIN=ON; Session altered  SQL  CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;  Table created.  Further, you executed the following command to drop the table:  SQL DROP TABLE emp;Table dropped.  What happens in this scenario?()A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.

考题 You issued the following statement to monitor the usage of the index:        SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE;   Which view will you query to ensure that the index is being monitored?()  A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE

考题 You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? ()(Choose three.)A、Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.B、A resumable statement is suspended only if an out of space error occurs.C、When a resumable statement is suspended, the transaction that contains the statement is also suspended.D、A resumable statement can only be suspended and resumed once during the execution of the statement.E、You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session

考题 You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table:  SQL FLASHBACK TABLE ORDERS TO SCN 771513;   What is the prerequisite to perform Flashback Table?()A、 You must configure OMF in your database.B、 You must enable block change tracking feature in your database.C、 You must enable ROW MOVEMENT feature on the ORDERS table.D、 You must use the Flashback Version Query before using the Flashback Table feature.

考题 TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal?()A、In SQL Server Management Studio, open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.B、In SQL Server Management Studio,open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.C、In SQL Server Management Studio, open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.D、In SQL Server Management Studio, open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.

考题 单选题Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement:   SQL ALTER DATABASE SET TIME_ZONE =’Europe/London’;   What will be the result of issuing the above statement?()A  The statement will be executed successfully, and a new time zone will be set for the database.B  The statement will be executed successfully, but a new time zone will not be set for the database.C  The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D  The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

考题 单选题You issued the following statement:   SQLALTER 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.

考题 单选题You issued the following statement:   SQL ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1;   Which parameter is NOT overridden by using the above statement?()A  the value of the NLS_LANGUAGE variableB  the value of the NLS_TERRITORY variableC  the value of the NLS_CURRENCY variableD the character encoding scheme used by the client application

考题 单选题You issued the following statement:  SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  What will be the result of issuing the statement?()A  The control file will be multiplexed.B  The control file will be recreated.C The script containing the CREATE CONTROLFILE statement will be created.D  The binary backup of the control file will be created.

考题 单选题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 processB  Server processC  System Monitor (SMON)D  Process Monitor (PMON)E  Checkpoint process (CKPT)

考题 单选题You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table:  SQL FLASHBACK TABLE ORDERS TO SCN 771513;   What is the prerequisite to perform Flashback Table?()A  You must configure OMF in your database.B  You must enable block change tracking feature in your database.C  You must enable ROW MOVEMENT feature on the ORDERS table.D  You must use the Flashback Version Query before using the Flashback Table feature.

考题 单选题You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?()A The backup will terminate because the FORMAT clause was not configured for the channelB It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

考题 单选题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 processB Server processC System Monitor (SMON)D Process Monitor (PMON)E Checkpoint process (CKPT)

考题 单选题You issued the following statement in your SQL*Plus session:   SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()A  creating a table in your schema and you exceed your allocated space quota on the tablespaceB  executing a long query that involves a sort operation and the statement runs out of temporary spaceC  loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD  creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

考题 多选题You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?()AAll data along with the table structure is deletedBThe pending transaction in the session is committedCAll indexes on the table will remain but they are invalidatedDAll views and synonyms will remain but they are invalidatedEAll data in the table are deleted but the table structure will remain

考题 单选题You created the ORDERS table in your database by using the following code:   SQL CREATE TABLE ORDERS (ORDER_DATE TIMESTAMP(0) WITH TIME ZONE);   Then, you inserted data in the ORDERS table and saved it by issuing the following statements:SQL INSERT INTO ORDERS VALUES(’18-AUG-00 10:26:44 PM America/New_York’);   SQL INSERT INTO ORDERS VALUES(’23-AUG-02 12:46:34 PM America/New_York’);   SQL COMMIT;   Next, you issued the following statement to change the time zone for the database:   SQL ALTER DATABASE SET TIME_ZONE=’Europe/London’;   What will be the result of executing the above statement?()A  The statement will fail.B  The statement will be executed successfully, and the new time zone will be set for the database.C  The statement will be executed successfully, but the new time zone will be set for the current session.D The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.

考题 单选题You issued the following statement to monitor the usage of the index:        SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE;   Which view will you query to ensure that the index is being monitored?()A  INDEX_STATSB  DBA_INDEXESC  DBA_IND_COLUMNSD  V$OBJECT_USAGE

考题 多选题TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal?()AIn SQL Server Management Studio, open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.BIn SQL Server Management Studio,open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.CIn SQL Server Management Studio, open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.DIn SQL Server Management Studio, open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.

考题 多选题From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for ().AUpdatingBViewingCDeletingDInsertingETruncating