当前位置: Oracle培训中心-> 082考试题库
165
164

新闻中心

  • Oracle OCP 19c 认证1Z0-082考试题库(第25题)2021-07-20
  • Oracle OCP 19c 认证1Z0-082考试题库(第25题)-CUUG内部学员版082题库解析25、Which three instance situations are possible with the Oracle Database server without multi-tenant?(Choose three.)A. two or more instances on separate servers all associated with one databaseB. one instance on one server associated with one databaseC. one instance on one server associated with two or more databases on the ........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第24题)2021-07-20
  • Oracle OCP 19c 认证1Z0-082考试题库(第24题)-CUUG内部学员版082题库解析24、Evaluate these commands which execute successfully:CREATE SEQUENCE ord_seqINCREMENT BY 1START WITH 1MAXVALUE 100000CYCLECACHE 5000;CREATE TABLE ord_items(ord_no NUMBER(4) DEFAULT ord_seq.NEXTVALUE NOT NULL,item_no NUMBER(3),qty NUMBER(3),expiry_date DATE,CONSTRAINT it_pk PRIMARY KEY(ord_no,item_no),CONSTRAINIT ord_fk FOREIGN ........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第23题)2021-07-20
  • Oracle OCP 19c 认证1Z0-082考试题库(第23题)-CUUG内部学员版082题库解析23、Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)A. PCTFREE defaults to 10% for all blocks in all segments for all compression methodsB. ASSM assigns blocks to one of four fullness categories based on what percenta........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第22题)2021-07-20
  • Oracle OCP 19c 认证1Z0-082考试题库(第22题)-CUUG内部学员版082题库解析22、Choose threeWhich three are true about dropping columns from a table?A) A column can be removed only if it contains no data.B) A column drop is implidtly committedC) A column that is referenced by another column in any other table cannot be dropped.D) A column must be set as unused before it is dropped from a table.E A prim........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第21题)2021-07-20
  • Oracle OCP 19c 认证1Z0-082考试题库(第21题)-CUUG内部学员版082题库解析21、Choose threeExamine this description of the PRODUCTS table:Name NULL? TYPE------------------------------------------------------------------------PROD_ID NOT NULL VARCHAR2(6)QUANTITY NUMBER(8,2)PRICE NUMBER(10.2)EXPIRY_DATE DATERows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mo........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第16题)2021-06-22
  • Oracle OCP 19c 认证1Z0-082考试题库(第16题)-CUUG内部学员版082题库解析16.Which three statements are true about dropping and unused columns in an Oracle database?(Choose three.)A. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.B. An UNUSED column’s space is reclaimed automatically when the block containing that column is next quer........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第17题)2021-06-22
  • Oracle OCP 19c 认证1Z0-082考试题库(第17题)-CUUG内部学员版082题库解析17. 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 t he PRODUCTS table?A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the in........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第18题)2021-06-22
  • Oracle OCP 19c 认证1Z0-082考试题库(第18题)-CUUG内部学员版082题库解析18、Evaluate the following ALTER TABLEstatement:ALTER TABLE orders SET UNUSED (order_date);Which statement is true?A. After executing the ALTER TABLEcommand, you can add a new column called ORDER_DATE to the ORDERS table.B. The ORDER_DATE column should be empty for the ALTER TABLE command to execute succsessfully.C. ROLLBACK ........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第19题)2021-06-22
  • Oracle OCP 19c 认证1Z0-082考试题库(第19题)-CUUG内部学员版082题库解析19、choose the best answer Evaluate the following SQL statement:ALTER TABLE hr.empSET UNUSED (mgr_id);Which statement is true regarding the effect of the above SQL statement?A) Any views created on the EMP table that include the MGR_ID column would be automatically modified and remain valid.B) Any constraints defined on the MGR........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第20题)2021-06-22
  • Oracle OCP 19c 认证1Z0-082考试题库(第20题)-CUUG内部学员版082题库解析20、choose two:Examine the structure of the DEPARTMENTS tableName Null? Type------------------------DEPARTMENT NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)MANAGER_ID NUMBER(6)LOCATION_ID NUMBER(4)COUNTRY VARCHAR2(20)You execute the following command:SQL> ALTER TABLE departmentsSET UNUSED (country);Which two statemen........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第14题)2021-05-21
  • Oracle OCP 19c 认证1Z0-082考试题库(第14题)-CUUG内部学员版082题库解析14、choose oneExamine the description of the CUSTOMERS table:name null? type------------------------CUST_ID NOT NULL VARCHAR2(6)FIRST_NAME VARCHAR2(50)LAST_NAME NOT NULL VARCHAR2(50)ADDRESS VARCHAR2(50)CITY VARCHAR2(50)You want to display details of all customers who reside in cities starting with the letter D followed by at le........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第15题)2021-05-21
  • Oracle OCP 19c 认证1Z0-082考试题库(第15题)-CUUG内部学员版082题库解析15.Examine this command:ALTER DATABASEMOVE DATAFILE '/u01/sales1.dbf'TO /u01/sales01.dbf'REUSE;Which two statements are true? (Choose two.)A. DML may be performed on tables with one or more extents in this data file during the execution of this command.B. The tablespace containing SALES1.DBF must be altered READ ONLY before e........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第11题)2021-05-21
  • Oracle OCP 19c 认证1Z0-082考试题库(第11题)-CUUG内部学员版082题库解析11.Which two statements are true about the SET VERIFY ON command? (Choose two.)A. It can be used only in SQL*PlusB. It displays values for variables used only in the WHERE clause of a queryC. It can be used in SQL Developer and SQL*PlusD. It displays values for variables created by the DEFINE commandE. It displays values for ........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第12题)2021-05-21
  • Oracle OCP 19c 认证1Z0-082考试题库(第12题)-CUUG内部学员版082题库解析12.Which three statements are true about a self-join? (Choose three.)A. The ON clause must be usedB. The query must use two different aliases for the tableC. It must be an equi joinD. It must be an inner joinE. The ON clause can be usedF. It can be an outer join.....详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第13题)2021-05-21
  • Oracle OCP 19c 认证1Z0-082考试题库(第13题)-CUUG内部学员版082题库解析13.You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.The variables used in your query are never undefined in your session.Which query can be used?A. SELECT &&col1, &&col2FRO........详情
首页  上一页  12  下一页 尾页 共25条记录 1/2
关闭