Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）
多选题查看答案
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command： LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）
单选题查看答案
You executed the following command to back up your control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； Which initialization parameter is used to specify the location of the trace file？（）
单选题查看答案
On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）
多选题查看答案
The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?（）
单选题查看答案
在Oracle中，通过命令（）可以释放锁。
单选题查看答案
Given: What is the result?（）
单选题查看答案
In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?（）
单选题查看答案
You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist. Which command should you now use to check if any of the files were missing？（）
单选题查看答案
What two are the prerequisites for enabling Flashback Database？（）
多选题查看答案
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）
单选题查看答案
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）
单选题查看答案
ou executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5 ignorecase=N Which statement describes the purpose of the above password file（）
单选题查看答案
What recommendations does the SQL Access Advisor provide for optimizing SQL queries? （）(Choose all that apply.)
多选题查看答案
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid?（）
单选题查看答案
Which of the following options would you choose to implement controlled access using remote authentication for your networks？（）
单选题查看答案
You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value？（）
单选题查看答案
对于系统表的空间，Oracle建议的大小是（）。
单选题查看答案
Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？ （）
多选题查看答案
You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）
单选题查看答案