-
Which is a restriction on a list partitioned table？（）
A . You cannot create global range partitioned indexes on the table.
B . The optimizer will not execute partition wise joins on the table’s partitions.
C . You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL.
D . Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.
-
User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）
A . UPDATE pets…
B . SELECT….FROM pets
C . INSERT INTO pets…
D . ALTER TABLE pets&helli
-
Have you got a table for four, Waiter?（）
A . Welcome to our restaurant.
B . Yes, sure. This way, please.
C . We have booked the seats.
D . Here are the menus.
-
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）
A . It fails with the ORA-665610 Invalid DDL statement on history-tracked message
B . The rows in the table are truncated without being archived.
C . The rows in the table are archived, and then truncated.
D . The rows in both the table and the archive are truncated.
-
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition？（）
A . It remains valid.
B . It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
C . It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
D . It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
-
When adjusting a magnetic compass for error，a deviation table should be made（）.
A . before correcting for any deviation
B . after correcting for variation
C . after adjusting the fore-and-aft and athwartships permanent magnets
D . before the quadrantal correctors are placed on the compa
-
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）
A . REFERENCES
B . SELECT
C . UPDATE
D . ALTER
-
Which three statements inserts a row into the table?（）
A . INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);
B . INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);
C . INSERT INTO employees VALUES (‘1000’,‘John’,NULL);
D . INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);
E . INSERT INTO employees (employee_id) VALUES (1000);
F . INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’)
-
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）
A . UPDATE TABLE
B . CREATE CLUSTER
C . TRUNCATE TABLE
D . ALTER TABLE MOVE
E . INSERT INTO···VALUES
F . ALTER TABLE···DROP COLUMN
G . ALTER TABLE···DROP PARTITION
-
Which is a valid CREATE TABLE statement? （）
A . CREATE TABLE EMP9$# AS (empid number(2));
B . CREATE TABLE EMP*123 AS (empid number(2));
C . CREATE TABLE PACKAGE AS (packid number(2));
D . CREATE TABLE 1EMP_TEST AS (empid number(2))
-
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）
A . if a table is not in a cluster
B . if a table has an active trigger
C . if a table has an encrypted
D . if a table has a column of data type LONG defined on it
E . if a table has a referential integrity constraint defined on it
-
1. Plan a table / table a plan: ___________________2. Book a place / place a book: ___________________3. Lift a thumb / thumb a lift: ___________________
-
This is a ______table.
A．brown new Chinese wooden beautiful
B．beautiful new brown Chinese wooden
C．Chinese beautiful new brown wooden
D．wooden new beautiful Chinese brown
-
– Have you got a table for four, Waiter？ – （).
A．A. Welcome to our restaurant
B．B. Yes, sur
C．C. This way, please
D．D. We have booked the seats
E．E. Here are the menus
-
<table><tbody><tr><td>碳酸钠俗称纯碱，碳酸钠属于（）<table><tr><td>A．酸</td><td>B．碱</td><td>C．盐</td><td>D．氧化物</td></tr></table></td></tr></tbody></table></body>
-
<table><tbody><tr><td>四大洋中面积最小的大洋是（）<table><tr><td>A．A</td><td>B．B</td><td>C．C</td><td>D．D</td></tr></table></td></tr></tbody></table>
-
<table><tbody><tr><td>世界上最大半岛上面积最大的国家是（）<table><tr><td>A．埃及</td><td>B．印度</td><td>C．沙特阿拉伯</td><td>D．伊朗</td></tr></table></td></tr></tbody></table>
-
<table><tbody><tr><td>下列不是广州别称的是（）<table><tr><td>A．春城</td><td>B．羊城</td><td>C．花城</td><td>D．穗城</td></tr></table></td></tr></tbody></table>
-
<table><tbody><tr><td>下列不属于三大丘陵的是（）<table><tr><td>A．淮阳丘陵</td><td>B．辽东丘陵</td><td>C．山东丘陵</td><td>D．东南丘陵</td></tr></table></td></tr></tbody></table>
-
<table><tbody><tr><td>A．世界最高的山脉 ①马来群岛
B．世界最高的高原 ②喜马拉雅山脉
C．世界面积最大的大洲 ③青藏高原
D．世界最大的湖泊 ④亚洲
E．世界最深和蓄水量最大淡水湖 ⑤里海
F．世界陆地最低点 ⑥贝加尔湖
G．世界最大的半岛 ⑦死海
H．世界最大的群岛 ⑧阿拉伯半岛．</td></tr></tbody></table></body>
-
<table><tbody><tr><td>食醋的主要成分是（）<table><tr><td>A．乙酸</td><td>B．乙醇</td><td>C．油脂</td><td>D．苯</td></tr></table></td></tr></tbody></table>
-
<table><tbody><tr><td>经线的形状是（）<table><tr><td>A．圆</td><td>B．点</td><td>C．半圆</td><td>D．椭圆</td></tr></table></td></tr></tbody></table>
-
<table><tbody><tr><td>氢氧化钠的俗名是（）<table><tr><td>A．烧碱</td><td>B．纯碱</td><td>C．食盐</td><td>D．小苏打</td></tr></table></td></tr></tbody></table></body>
-
<table><tbody><tr><td>The medicine has a good effect to me</td></tr></tbody></table>
