-
Which two roles or privileges must you have to export tables owned by another user?()
A . CREATE USER
B . CREATE SESSION
C . CREATE ANY TABLE
D . IMP_FULL_DATABASE
E . EXP_FULL_DATABASE
-
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 want to check the EMP table in the user, Scott’s schema for block corruption. You also want to fix the corrupted blocks, if any. How will you accomplish the required task?()
A . by using the ANALYZE utility
B . by using the DBVERIFY utility
C . by using the DB_BLOCK_CHECKING parameter
D . by using the DBMS_REPAIR package
-
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);
A . to undo the changes made to the EMP table since the specified time
B . to restore the EMP table that was wrongly dropped from the database
C . to view the transactions that have modified the EMP table since the specified time
D . to view the changes made to the EMP table for one or more rows since the specified time
-
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?()
A . Initiate an incomplete recovery operation using RMAN.
B . Copy the table from a development database.
C . Advise the user to rekey the data.
D . Perform a Flashback Drop operation.
E . Perform a Flashback Recovery operation.
-
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?()
A . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
B . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
C . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
D . CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno))
-
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);
A . to undo the changes made to the EMP table since the specified time
B . to restore the EMP table that was wrongly dropped from the database
C . to view the transactions that have modified the EMP table since the specified time
D . to view the changes made to the EMP table for one or more rows since the specified time
E . to recover the EMP table to a point in time in the past by restoring the most recent backu
-
You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct?()
A . The FLASHBACK TABLE statement will not be written to the alert log file.
B . The changes made to the EMP table since the specified time will be undone.
C . The EMP table that was dropped by mistake from the database will be restored.
D . The FLASHBACK TABLE statement will be executed within a single transaction.
E . The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
F . The list of transactions that have modified the EMP table since the specified time will be displayed.
-
You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?()
A . table
B . transactional trigger
C . stored procedure
D . FROM clause query
-
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?()
A . DROP emp_dept_uv;
B . DELETE emp_dept_uv;
C . REMOVE emp_dept_uv;
D . DROP VIEW emp_dept_uv;
E . DELETE VIEW emp_dept_uv;
F . REMOVE VIEW emp_dept_uv
-
In which two scenarios should you issue the following command?() FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE;
A . when the schema of the user, SCOTT, was deleted by mistake 15 minutes ago
B . when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
C . when some rows of the table, EMP, in the SCOTT schema were deleted by mistake 15 minutes ago
D . when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
E . never, because FLASHBACK TABLE is not a valid command in Oracle 10g.
-
You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()
A . You must enable the row movement on the SCOTT.EMP table.
B . You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
C . You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
D . You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
-
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);
A . to undo the changes made to the EMP table since the specified time
B . to restore the EMP table that was wrongly dropped from the database
C . to view the transactions that have modified the EMP table since the specified time
D . to view the changes made to the EMP table for one or more rows since the specified time
E . to recover the EMP table to a point in time in the past by restoring the most recent backu
-
You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?()
A . LogMiner
B . The DBNEWID utility
C . The DBVERIFY utility
D . The ANALYZE command
E . The RMAN REPORT command
F . The RMAN CROSSCHECK command.
G . The RMAN BLOCKRECOVER command.
-
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()
A . You must enable the block change tracking feature.
B . You must have enable the flashback feature.
C . You must use the OMF in your database.
D . You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
-
You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct? ()
A . The FLASHBACK TABLE statement will not be written to the alert log file.
B . The EMP table that was dropped by mistake from the database will be restored.
C . The changes made to the EMP table since the specified time will be undone.
D . The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
E . The FLASHBACK TABLE statement will be executed within a single transaction.
F . The list of transactions that have modified the EMP table since the specified time will be displayed.
-
As our foreign teachers’ suggest, when you deliver a speech, you’d better use your own personal experiences to show your own opinions.____________
-
You’re at a table in a restaurant for a business dinner. Midway through the meal, you’re called to the telephone. What do you do with your napkin?
-
In international air cargo transportation, a freightforwarder offering a consolidation service will issue its own air waybill.Thisis called().
A.MAWB
B.HAWB
C.IATA
D.TACT
-
In reality, the so-called "free trade agreements" may actually create their own barriers to a free market.
-
Tips are generally not required at cafeterias where you serve yourself and you are expecteTips are generally not required at cafeterias where you serve yourself and you are expected to clear your own table of dishes and utensils, and discard your trash in the garbage cans.
-
Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) NOT NULLSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID columnof the DEPARTMENTS tableYou need to create a view called EMP_VU that allows the users to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the users to insert rows?()
A.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
B.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, department_id FROM employees WHERE mgr_id IN (102, 120);
C.CREATE VIEW emp_vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_id;
D.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;
-
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema.What happens when you execute this query?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135882/b1559080aa448ecf1a5fe7380a121c8c.jpg' />
A. You obtain the results retrieved from the public synonym HR created by the database administrator.
B. You obtain the results retrieved from the HR table that belongs to your schema.
C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
-
If you own a car, you are probably considering buying some kind of car insurance(保险)
If you own a car, you are probably considering buying some kind of car insurance(保险). However, when you are actually purchasing car insurance, it can be difficult for you to decide which is your best choice. The ideal buying process is to first research and decide, then purchase.
Research first
Before buying car insurance, you should find out the purpose of your purchase and how the insurance meets your needs.
Decide on suitable Car Insurance Policies(保单)
A neglected part of car insurance is the part which covers medical bills. Medical payments can add up very quickly in an accident situation, and the insurance should cover the bills incurred (招致) both by you and by the passengers in your car. Make sure you know the full value that your insurance covers.
Purchase the best Car Insurance for your needs
You have a number of choices when it comes to the actual purchase of the car insurance. Each has advantages and disadvantages, and these may be influenced by your individual taste and previous buying experience. Insurance companies may offer you good advice, but prices on the Internet are often better.
1. According to the first paragraph, when buying car insurance, one should first ___________.
A. decide on the number of policies to purchase
B. do careful research on the different choices
C. choose the best insurance company
D. look for the lowest insurance rate
2. The purpose of research is to find out whether the car insurance _____________ .
A. includes all the advantages
B. best meets your needs
C. offers the best rate
D. is easy to purchase
3. When buying car insurance, people often neglect________________ .
A. the damage to the car
B. the bills paid by the passengers
C. the part covering the medical bills
D. the background of the insurance company
4. According to the last paragraph, your choice of car insurance may also be influenced by _________________.
A. your driving habits
B. the kind of car to be insured
C. the attitude of your family members
D. your own taste and buying experience
5. Which of the following might be the best title of the passage?
A. Medical Bills Covered in Car Insurance
B. Importance of Buying Car Insurance
C. Advice on Buying Car Insurance
D. Advantages of Car Insurance