All database operations performed by the impdp command are logged.
Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
第1题:
Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?()
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
第2题:
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?()
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
第3题:
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?()
A.
B.
C.
D.
第4题:
A. The network is stable
B. There is a flapping link or interface, and router C knows an alternate path to the network
C. There is a flapping link or interf ace, and router C does not know an alternate path to the network
D. EIGRP is not working correctly on router C
E. There is not enough information to make a determination
第5题:
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?()
A. Data files that belong to only the root container
B. Data files that belong to the root container and all the pluggable databases (PDBs)
C. Data files that belong to only the root container and PDB$SEED
D. Data files that belong to the root container and all the PDBs excluding PDB$SEED
第6题:
Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?()
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command
第7题:
Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?()
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
第8题:
A. 4
B. 8
C. 7
D. 0
第9题:
A. Switching loop
B. Broadcast storm
C. IP conflict
D. Routing loop
第10题:
You are a network technician at TestKing, Inc. You are currently troubleshooting a routing issue on the Testking1 router. You issue the show ip route command. The output from the command is displayed in the following exhibit:Which one of the following routes WILL NOT be entered into its neighboring routers routing table?()
A. R 192.168.11.0/24 [120/7] via 192.168.9.1, 00:00:03, Serial1
B. C 192.168.1.0/24 is directly connected, Ethernet0
C. R 192.168.8.0/24 [120/1] via 192.168.2.2, 00:00:10, Serial0
D. R 192.168.5.0/24 [120/15] via 192.168.2.2, 00:00:10, Serial0
E. None of the above