To implement Automatic Memory Management (AMM), you set the following parameters:When you try to start the database instance with these parameter settings, you receive the following error message:SQL ...
Choose three
Which three are true about the CREATE TABLE command?
A) It can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint.
B) The owner of the table ...
67、(25-8)choose the best answer:
View the Exhibit and examine the structure of CUSTOMERS table.
Evaluate the following query:
SQL>SELECT cust_id, cust_city
FROM customers
WHERE cust_first_name...
77、Which two statements are true about sequences created in a single instance database? (Choose two.)
A. When the MAXVALUElimit for the sequence is reached, you can increase the MAXVALUElimit by usi...
46、(10-4) choose two:
Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
----------------------
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
You want to ex...
73、Which statement correctly grants a system privilege?
A. GRANT CREATE VIEW
ON table1 TO
user1;
B. GRANT ALTER TABLE
TO PUBLIC;
C. GRANT CREATE TABLE
TO user1, user2;
D. GRANT CREATE SESSION...
49、(11-1) choose the best answer
Examine the structure of the SHIPMENTS table:
You want to generate a report that displays the PO_ID and the penalty amount to be paid(罚款数额) if the SHIPMENT_DA...
61、(18-6) choose the best answer:
View the Exhibit and examine the structure of the CUSTOMERS table.
You want to generate a report showing the last names and credit limits of all customers whose la...
50、(11-15)choose two
Examine the structure of the MARKS table:
Which two statements would execute successfully?
A) SELECT SUM(subjectl+subject2+subject3)
FROM marks
WHERE student_name IS NULL;...
76、View the exhibit and examine the description of the DEPARTMENTSand EMPLOYEEStables.
The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the following...
40、(8-7) choose two
Which two statements are true regarding views? (Choose two.)
A) A simple view in which column aliases have been used cannot be updated.
B) The OR REPLACE option is used to chan...
