-
Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）
A . The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
B . The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
C . Referential integrity constraint cannot be set on the invisible column.
D . The invisible column cannot be made visible and can only be marked as unused.
E . A primary key constraint can be added on the invisible column.
-
When configuring an interface using SMIT and Further Configuration with an IP address and netmask， which of the following outcomes indicates how the routing tables will be affected？（）
A . A subnet route is automatically added
B . A default route is automatically added
C . All other routes are automatically added
D . The routing table is not affected
-
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
A . The EMPLOYEES table will be changed to read-only mode during the shrink operation.
B . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
C . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
D . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
-
The datum from which the predicted heights of tides are reckoned in the tide tables is（）.
A . mean low water
B . the same as that used for the charts of the locality
C . the highest possible level
D . given in table three of the tide table
-
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this？（）
A . owner
B . touser
C . attach
D . remap_schema
-
You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）
A . The target database must be in the MOUNT mode to ensure restoration of the datafiles.
B . You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
C . The control file must be recreated.
D . The database must be opened with the RESETLOGS option.
-
Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）
A . Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B . Using the statement RESET PERFORMANCE CACHE
C . Using the statement FLUSH PERFORMANCE CACHE
D . Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E . Disabling and re-enabling all instruments
F . Restarting Mysql
-
Which two statements are true regarding the USING clause in table joins?（）
A . It can be used to join a maximum of three tables
B . It can be used to restrict the number of columns used in a NATURAL join
C . It can be used to access data from tables through equijoins as well as nonequijoins
D . It can be used to join tables that have columns with the same name and compatible data type
-
Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）
A . Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
B . Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
C . Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
D . Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
-
You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based？（）
A . column sizes
B . column data types
C . PCTFREE
D . projected number of row
E . PCTUSED
-
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
A . the DBNEWID utility
B . the ANALYZE command
C . the RMAN LIST command
D . the RMAN REPORT command
E . the RMAN CROSSCHECK command
F . the RMAN BLOCKRECOVER command
-
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
A . The data in the segment will be compacted but the high water mark will not be adjusted
B . The EMPLOYEES table will be changed to read-only mode during the shrink operation
C . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
D . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation
E . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operatio
-
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
-
In the west, round tables are the standard.
-
When thing in the language,you are using the language in an active way.
-
11. To predict the actual depth of water using the Tide Tables，the number obtained from the Tide Tables is _____.
-
Either of the boys may take their bags in the front of the table.
-
Which of the f0llowing is the p0ssible risk in using nano—materials mentioned in the passage？
A．They may cause some damage to the body cells．
B．They are harmful materials themselves．
C．They may store in the body．
D．They may behave differently in the body and the environment．
-
Using the figure in the Special window, The critical path is:
A . A-B-G
B . C-G
C . C-D
D . E-F
E . A-B-G and C-D
-
●Using the problem stated in the Special window, Calculate the expected value of duration
● Using the problem stated in the Special window, Calculate the expected value of duration (in days) using the PERT concept of the expected duration of a task
A 8
B 8.8
C 9.1
D 9.7
E 10.5
-
Questions 33－36Complete the table using NO MORE THAN THREE WORDS for each answer. 【33】
Questions 33-36
Complete the table using NO MORE THAN THREE WORDS for each answer.
<img src='https://img2.soutiyun.com/shangxueba/ask/11019001-11022000/11020376/ct_ei_007(20095).jpg' />
【33】
-
The initial cost of your project is $25,000, which will save the company $6,000 per year for the next four years. Using the above table If your company wants a 12% ROI, what is the NPV of the project？
A.-$1,000
B._$6,772
C.+$1,758
D.+$6,772
-
With American table manners, you hold the folk in your right hand and the knife in you
是
否
-
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.
You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use？（）<img src='https://img2.soutiyun.com/shangxueba/ask/18264001-18267000/18266966/2018080111484519157.jpg' />
A. SELECT last_name, department_name FROM employees NATURAL JOIN departments;
B. SELECT last_name, department_name FROM employees JOIN departments ;
C. SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E. SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
F . SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id)
