The DBA issues this SQL command:
CREATE USER scott
IDENTIFIES by tiger;
What privileges does the user Scott have at this point? （）
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS;
What is the outcome of this command?（）
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?（）
Refer to the exhibit. Given the output for this command, if the router ID has not been manually set, what router ID will OSPF use for this RouterD?（）
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Which statement is true?（）
You have a login-path named "adamlocal" that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command:
$mysql_config_editor print –login-path=adamlocal What is the expected output of this command?（）
Examine the structure of the STUDENTS table:
You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）
You plan to execute the following command to perform a Flashback Database operation in your database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);
Which two statements are true about this?（）
Evaluate the following command:
SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';
What is the impact of this setting on the usage of SecureFiles?（）
You issued the following RMAN command：
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；
What is NOT an impact of using the above command？（）
Evaluate the following command：
SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’；
What is the impact of this setting on the usage of SecureFiles？（）
You issued the following command at the UNIX environment：
% setenv ORA_SDTZ ’OZ_TZ’
What will be the impact of issuing the above command？（）
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.
You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）
A Cisco router has been configured, and the copy running-config startup-config command has been issued. When the router is power cycled, the router prompts with:
"Would you like to enter the initial configuration dialog? [yes/no]"
Why has this occurred?（）
Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?（）
As an experienced technician, you are responsible for Technical Support in your company. One of the trainees is asking you in what might happen if he issues the logging trap information command.
Which of the following statement will answer his quest
on?（）
On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true?（）
You opened the encryption wallet and then issued the following command:
Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?（）
From SQL*Plus, you issue this SELECT statement:
SELECT*
FROM order;
You use this statement to retrieve data from a data table for （）.
The DBA issues this SQL command:
CREATE USER scott
IDENTIFIES by tiger;
What privileges does the user Scott have at this point? （）
You executed the following command to drop a user:
DROP USER scott CASCADE;
Which two statements regarding the above command are correct?（）
Scott issues the SQL statements:
CREATE TABLE dept
(deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13)};
GRANT SELECT
ON DEPT
T0 SUE;
If Sue needs to select from Scott's DEPT table, which command should she use?（）
The DBA issues this SQL command:
What privileges does the user Scott have at this point?（）
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:
SQL> SELECT * FROM sales;
Which process would retrieve the result from the database and return it to the client program?（）
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?（）
免费的网站请分享给朋友吧