Oracle 19c OCP 1Z0-082認證考試題庫（51-60）

51.View the Exhibit and examine the description of the tables You execute this SQL statement

Which three statements are true?

A.The sales table has five foreign keys

B.The statement will execute successfully and a new row will be inserted into the SALES table

C.A product can have a different unit price at different times

D.A customer can exist in many countries.

E.The statement will fail if a row already exists in the SALES table for product 23

F. The statement will fail because a subquery may not be contained in a VALUES clause

答案： ABD

52.View the Exhibits and examine the structure of the costs and PROMOTIONS tables

You want to display prod_ids whose promotion cost is less than the highest cost prod_id in a promotion time interval

Examine this SQL statement

What 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

答案： C

Prom_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 command

The 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_SIZE

D.The operating system must use a 32k block size

E.DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE

F. The /u02 file system must have at least 100g space for the datafile

答案： AF

54.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 numbers

C.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

答案： BE

trunc可以用於日期

55.Examine the description of the PRODUCR STATUS table

The 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 metadata

D. You cannot start up a database instance using EM Express

E.You can use a single instance of EM Express to manage multiple databases running on the same server

答案： AD

EM 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 instances

B.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

C. LISTENER_1 must also be defined in the LISTENER. ORA file to enable dynamic service registration

D.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

答案： AB

59.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 1000

Examine this partial query

SELECT 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 < 1000

B.WHERE UPPER(cust_1ast_name IN ('A%', 'B%' ) AND cust_credit_limit < 1000

C.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)< 1000

E.WHERE UPPER(cust_last_name) BETWEEN UPPER ('A%' AND 'B%' )

AND ROUND(cust_credit_limit)< 1000

答案： AD

60.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 started

B.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