creating a table in your schema and you exceed your allocated space quota on the tablespace
executing a long query that involves a sort operation and the statement runs out of temporary space
loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
第1题:
You issued the following statement: SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1; Which parameter is NOT overridden by using the above statement?()
第2题:
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for ().
第3题:
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)
第4题:
You issued the following statement: SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()
第5题:
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?()
第6题:
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?()
第7题:
You issued the following statement: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?()
第8题:
A. Updating
B. Viewing
C. Deleting
D. Inserting
E. Truncating
第9题:
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?()
第10题:
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?()