1Z1-082テスト問題練習試そう！2022年に更新された145問あります [Q19-Q41]

19、Which is true about roles?

20、Which two tasks can you perform using DBCA for databases? (Choose two.)

21、Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

22、Which two statements are true about Enterprise Manager Database Express? (Choose two.)

23、In which three situations does a new transaction always start? (Choose three.)

24、Which three statements are true concerning logical and physical database structures? (Choose three.)

25、What two are benefits of Data Pump? (Choose two.)

26、Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

27、You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

28、Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

29、Examine the description of the PRODUCT_STATUS table:

The status column contains the values ‘in stock’ or ‘out of stock’ for each row.
Which two queries will execute successfully?

30、Which two statements are true about the rules of precedence for operators? (Choose two.)

31、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 functions
* Store a loan period of up to 10 years
* Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

32、Which two statements are true about interval data types?

33、Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

34、Which three are true about the Oracle Optimizer? (Choose three.)

35、Which three statements are true about sequences in a single instance Oracle database?

36、Which three statements are true about single-row functions? (Choose three.)

37、The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17
statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA-01536: space quota exceeded for tablespace ‘DATA’ Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

38、Which statement is true about aggregate functions?

39、Which two statements are true about single row functions? (Choose two.)

40、Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

41、Examine the description of the employees table:

Which query requires explicit data type conversion?