1z0-071 無料問題集「Oracle Database SQL」

（A）Create a directory object for an external table.

（B）Create a directory object for a flat file.

（C）Read data from a table in the database and insert it into an external table.

（D）Read data from an external table and load it into a table in the database.

（E）Query data from an external table.

（F）Execute DML statements on an external table.

（A）The between condition always performs less well than using the >= and <= conditions.

（B）Table aliases can improve performance.

（C）The join syntax used makes no difference to performance.

（D）The between condition always performs better than using the >= and <= conditions.

（E）The Oracle join syntax performs better than the SQL: 1999 compliant ANSI join syntax.

（A）Date Manipulation Language (DML) can always be used on views.

（B）The WITH CHECK clause prevents certain rows from being displayed when querying the view.

（C）The WITH CHECK clause prevents certain rows from being updated or inserted.

（D）Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

（E）Tables in the defining query of a view must always exist in order to create the view.

（F）Views can be updated without the need to re-grant privileges on the view.

（G）Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

（A）COMMIT erases all the transaction's savepoints and releases its locks.

（B）ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.

（C）ROLLBACK to SAVEPOTNT undoes the transaction's changes made since the named savepoint and then ends the transaction.

（D）ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.

（E）ROLLBACK without the TO SAVEPOINT clause undoes alt the transaction's changes, releases its locks, and erases all its savepoints.

（F）COMMIT ends the transaction and makes all its changes permanent.

（A）they must be placed on the left side of the comparison operator or condition.

（B）THEY MUST BE PLACED ON THE RIGHT SIDE OF THE COMPARISON OPERATOR OR CONDITION.

（C）THEY CAN BE USED IN THE HAVING CLAUSE

（D）they must return a row to prevent errors in the SQL statement.

（E）THEY CAN BE USED in the where clause.

（F）A SQL STATEMENT MAY HAVE MULTIPLE SINGLE ROW SUBQUERY BLOCKS.

（A）A table can have only one primary key and one foreign key.

（B）A table can have only one primary key but multiple foreign keys.

（C）It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

（D）Only the primary key can be defined at the column and table level.

（E）The foreign key columns and parent table primary key columns must have the same names.

（F）Primary key and foreign key constraints can be defined at both the column and table level.

（G）It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.

（A）Add a new NOT NULL Column with a DEFAULT value.

（B）Increase the width of a numeric column.

（C）Change the default value of a column.

（D）Add a new column as the table's first column.

（E）Change a DATE Column containing data to a NUMBER data type.

（F）Define a default value that is automatically inserted into a column containing nulls.

（A）The ON clause can be used.

（B）The USING clause can be used.

（C）The Oracle join syntax can be used.

（D）Table aliases must be used.

（E）The SQL:1999 compliant ANSI join syntax must be used.

（A）SELECT "Hello! We're ready "FROM |DUAL;

（B）SELECT q'! Hello! We're ready! 'FROM DUAL;

（C）SELECT 'Hello! we\ re ready' ESCAPE'N'FROMDUAL:

（D）SELECT q'[Hello! We're ready]'FROM DUAL;

（E）SELECT 'Hello! We're ready' FROM DUAL;

（A）CREATE TABLE bookings ( bk_id NUMBER(4),
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT (end_date >= start_date));

（B）CREATE TABLE bookings (
bk_id NUMBER(4) NOT NULL PRIMARY KEY,
start_date DATE NOT NULL,
end_date DATE DEFAULT SYSDATE);

（C）CREATE TABLE bookings (
bk_id NUMBER(4) DEFAULT book_seq.NEXTVAL PRIMARY KEY,
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT SYSDATE NOT NULL);

（D）CREATE TABLE bookings (
bk_id NUMBER(4) DEFAULT book_seq.CURRVAL,
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT start date);

（E）CREATE TABLE bookings (
bk_id NUMBER(4) NOT NULL DEFAULT book_seq.CURRVAL,
start_date DATE NOT NULL,
end_date DATE DEFAULT SYSDATE);

（A）Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable.

（B）Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.

（C）Display the total number of products supplied by supplier 102 which have a product status of obsolete.

（D）Display the minimum PROD_LIST_PRICE for each product status.

（E）Display suppliers whose PROD_LIST_PRICE is less than 1000.

（A）Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

（B）IF sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.

（C）Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.

（D）Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.

（E）Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

（A）An update to a table can result in updates to any or all of the table's indexes.

（B）A SELECT statement can access one or more indices without accessing any tables.

（C）When a table is dropped and is moved to the RECYCLE BIN, all Indexes built on that table are permanently dropped.

（D）A UNIQUE index can be altered to be non-unique.

（E）An update to a table can result in no updates to any of the table's indexes.

（F）A table belonging to one user can have an index that belongs to a different user,