当前位置: fljsyy-> 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考试题库(第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考试题库(第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考试题库(第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考试题库(第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........详情
  • 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考试题库(第6题)2021-03-29
  • Oracle OCP 19c 认证1Z0-082考试题库(第6题)-CUUG内部学员版082题库解析You have been tasked to create a table for a banking application.One of the columns must meet three requirements:Be stored in a format supporting date arithmetic without using conversion functionsStore a loan period of up to 10 yearsBe used for calculating interest for the number of days the loan remains unpaidWhich data type ........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第7题)2021-03-29
  • Oracle OCP 19c 认证1Z0-082考试题库(第6题)-CUUG内部学员版082题库解析In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:LISTENER_1=(ADDRESS=(PROTOCOL=TCP)(HOST=host1.abc.com)(PORT=1521))Which statement is true?A. Dynamic service registration cannot be used for this database instanceB.........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第8题)2021-03-29
  • Oracle OCP 19c 认证1Z0-082考试题库(第8题)-CUUG内部学员版082题库解析Which three statements are true concerning logical and physical database structures? (Choose three.)A. All tablespaces may have one or more data filesB. The extents of a segment must always reside in the same datafileC. A smallfile tablespace might be bigger than a bigfile tablespaceD. A segment can span multiple data files in s........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第9题)2021-03-29
  • Oracle OCP 19c 认证1Z0-082考试题库(第9题)-CUUG内部学员版082题库解析9.Which two statements are true regarding a SAVEPOINT? (Choose two.)A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statementB. Rolling back to a SAVEPOINT can undo a TRUNCATE statementC. Only one SAVEPOINT may be issued in a transactionD. A SAVEPOINT does not issue a COMMITE. Rolling back to a SAVEPOINT can undo a DELETE s........详情
  • Oracle OCP 19c 认证1Z0-082考试题库(第10题)2021-03-29
  • Oracle OCP 19c 认证1Z0-082考试题库(第10题)-CUUG内部学员版082题库解析10.Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)A. writing inbound request to the common request queue from all shared server connectionsB. checking for outbound shared server responses on the common outbound response queueC. receiving inbound requests from processes us........详情