Oracle 19c OCP 1Z0-082认证考试题库（51-60）

51.View the Exhibit and examine the description of the tables You execute this SQL statementWhich three statements are true?A.The sales table has five foreign keysB.The statement will execute successfully and a new row will be inserted into the SALES tableC.A product can have a different unit price at different timesD.A customer can exist in many countries.E.The statement will fail if a row already exists in the SALES table for product 23F. The statement will fail because a subquery may not be contained in a VALUES clause答案： ABD52.View the Exhibits and examine the structure of the costs and PROMOTIONS tablesYou want to display prod_ids whose promotion cost is less than the highest cost prod_id in a promotion time intervalExamine this SQL statementWhat will be the result?A.It executes successfully and gives the required result.B.It gives an error because the GROUP BY clause is not valid C.It executes successfully but does not give the required result D.It gives an error because the ALL keyword is not valid答案： CProm_end_date-promo_begin_date不能保证产品在同一个时间段进行促销。53.You must create a tablespace of non-standard block size in a new file system and plan to  use this commandThe standard block size is 8k but other non-standard block sizes will also be used Which two are requirements for this command to succeed?A.DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA B.DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE C.DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZED.The operating system must use a 32k block sizeE.DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZEF. The /u02 file system must have at least 100g space for the datafile答案： AF54.Which two statements are true about single row functions?A.FLOOR: retums the smallest integer greater than or equal to a specified number B.CEIL: can be used for positive and negative numbersC.CONCAT: can be used to combine any number of values D.TRUNC: can be used only with NUMBER data types E.MOD: returns the remainder of a division operation答案： BEtrunc可以用于日期55.Examine the description of the PRODUCR STATUS tableThe STATUS column contains the values 'in stock' or 'OUT OF STOCK' for each row Which two queries will execute successfully?A.SELECT prod_id || q ' ('s not available.' from product status WHERE status = 'OUT OF STOCK'B.SELECT prod_id || q ' ('s not available.' "CURRENT AVAILABILITY"FROM product status WHERE status = 'OUT OF STOCK 'C.SELECT prod_id "CURRENT AVAILABILITY" || q ' ('s not availablE.'from product status WHERE status = 'OUT OF STOCK'D.SELECT prod_id || q('s not availablE.' 'current AVAILABILITY ' FROM product status WHERE status = 'OUT OF STOCK'E.SELECT prod_id q 's not available" FROM product status WHERE status ="OUT OF STOCK"F.SELECT prod_id || q" 's not available" FROM product_status WHERE status = 'OUT OF STOCK'答案： AB  ????56.Which two statements are true about Enterprise Manager(EM)Express?A.By default, EM Express is available for a database after database creation using DBCA B.You can shut down a database instance using EM Express.C.EM Express uses a separate repository database to store target database metadataD. You cannot start up a database instance using EM ExpressE.You can use a single instance of EM Express to manage multiple databases running on the same server答案： ADEM Express 简化版的 em，只要用存储过程设置了端口号就可以访问。57.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.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521on the same host as the database instancesB.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registrationC. LISTENER_1 must also be defined in the LISTENER. ORA file to enable dynamic service registrationD.The LREG process registers services dynamically with the LISTENER_1 listener E.Dynamic service registration cannot be used for this database instance答案： A local_listener时需要把定义增加到服务器端的tnsnames.ora中58.Which two statements are true about UNDO and REDO? A.The generation of UNDO generates REDO.B.DML, modifies Oracle database objects and generates UNDO and REDO C.DML modifies Oracle database objects and only generates UNDO. D.The generation of REDO generates UNDO.E.DML modifies Oracle database objects and only generates REDO答案： AB59.Examine the description of the CUSTOMERS table:You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000Examine this partial querySELECT cust_last_name, cust_credit_limit FROM customers Which two WHERE conditions give the required result?A.WHERE(INITCAP(cust_last_name) LIKE 'A%' OR INITCAP(cust_last_name) LIKE 'B%') AND cust_credit_limit < 1000B.WHERE UPPER(cust_1ast_name IN ('A%', 'B%' ) AND cust_credit_limit < 1000C.WHERE (UPPER(cust_last_name LIKE INITCAP('A') OR UPPER(cust -Last-namE.LIKE INITCAP('B'))AND ROUND(cust_credit_limit)< ROUND(1000)；D.WHERE( UPPER(cust_1ast_namE.LIKE 'A% OR UPPER(Cust_1ast_namE.LINK ‘B%’AND ROUND(cust_credit_limit)< 1000E.WHERE UPPER(cust_last_name) BETWEEN UPPER ('A%' AND 'B%' )AND ROUND(cust_credit_limit)< 1000答案： AD60.Which two statements are true about the tools used to configure Oracle Net Services?A.The lsnrctrl utility requires a listener. ora file to exist before it is startedB.The Oracle Net Configuration Assistant is only used when running the Oracle installer. C.Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.D.Oracle Net Manager can be used to centrally configure listeners on any database server target. E.Oracle Net Manager can be used to locally configure naming methods on a database server.答案： C E