第1题:
第2题:
第3题:
第4题:
On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()
第5题:
Which two are true about aggregate functions? ()
第6题:
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()
第7题:
Which two statements about subqueries are true?()
第8题:
Which two statements about subqueries are true? ()
第9题:
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? ()
第10题:
You are designing an application that will use Windows Azure Table storage to store millions of data points each day. The application must retain each day’s data for only one week. You need to recommend an approach for minimizing storage transactions. What should you recommend?()
第11题:
Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.
You can flash back a dropped table provided row movement has been enabled on the table.
If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.
When you execute the DROP TABLESPACE? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.
When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.
If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.
第12题:
A single row subquery can retrieve data from only one table.
A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
A single row subquery can retrieve data from more than one table.
A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
第13题:
第14题:
第15题:
What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?()
第16题:
You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?()
第17题:
You issued the following command: SQL> DROP TABLE MYTABLE; SQL> SHOW RECYCLEBIN The following output is returned: ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ------------- ------------------------------ --------------- -------------------- MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE 2005-01-13:20:11:31 You want to drop the table, MYTABLE, from the Recycle Bin. Which two commands can you issue to accomplish the desired task?()
第18题:
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?()
第19题:
Which two statements are correct regarding the Oracle Flashback Drop feature? ()
第20题:
You work as a database administrator for Supportcenter.cn. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows: ERROR at Line 1: ORA-10635: Invalid segment or tablespace type What could be the reason? ()
第21题:
You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? ()
第22题:
The table is partitioned
The table name is wrong.
It is an index-Organized table (IOT)
The table is stored in locally managedtablespace.
The table is stored in atablespacewhere segment space is managed manually.
第23题:
UPDATE TABLE
CREATE CLUSTER
TRUNCATE TABLE
ALTER TABLE MOVE
INSERT INTO···VALUES
ALTER TABLE···DROP COLUMN
ALTER TABLE···DROP PARTITION