Q47. Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Q48. Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)

Q49. Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

Q50. Which is true about security rules on a compute node?

Q51. Which three statements are true about a self join? (Choose three.)

Q52. 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-03-06T12:15:17.183438+05:30
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.)

Q53. The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

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

Q55. Which two statements are true about the PMON background process? (Choose two.)

Q56. Which two statements are true about the DUAL table? (Choose two.)

Q57. You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

Q58. Which two tasks can be performed in the NOMOUNT state? (Choose two.)

Q59. A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

Q60. 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:

Exhibit 1.

Exhibit 2.

What will be the result?

Q61. In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

Q62. Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

Q63. Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

Q64. Which three failures do not require intervention for recovery? (Choose three.)

Q65. Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

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

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

Q68. You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON’), `dd “Monday for”
fmMonth rrrr’)
What is the result?

Q69. Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

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

Q71. Which two are true about the roles? (Choose two.)