心の哲学と人間の存在に関するテスト pt2

51. Which three statements are true about GLOBAL TEMPORARY TABLES?. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table. GLOBAL TEMPORARY TABLE space allocation occurs at session start. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

52. Which two statements are true about trace files produced by the Oracle Database server?. They can be written by server processes. Trace files are written to the Fast Recovery Area (FRA). They can be written by background processes. All trace files contain error information that require contacting Oracle Support. Trace file names are based on the database name concatenated with a sequential number.

53. st You need to calculate the number of days from 1 January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output?. SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') €" '01-JAN-2019' FROM DUAL;. SELECT ROUND(SYSDATE €" '01-JAN-2019') FROM DUAL;. SELECT ROUND(SYSDATE €" TO_DATE('01/JANUARY/2019')) FROM DUAL;. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') €" '01/JANUARY/2019' FROM DUAL;. SELECT SYSDATE €" TO_DATE('01-JANUARY-2019') FROM DUAL;.

54. Which two statements are true about the DUAL table?. It can be accessed only by the SYS user. It consists of a single row and single column of VARCHAR2 data type. It can display multiple rows but only a single column. It can be used to display only constants or pseudo columns. It can be accessed by any user who has the SELECT privilege in any schema. It can display multiple rows and columns.

55. Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data?. A table can have only one primary key but multiple foreign keys. A table can have only one primary key and one foreign key. The foreign key columns and parent table primary key columns must have the same names. 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. 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. Only the primary key can be defined at the column and table level. Primary key and foreign key constraints can be defined at both the column and table level.

56. Examine the description of the EMPLOYEES table Which query is valid?. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;.

57. What is true about non-equijoin statement performance?. Table aliases can improve performance. The BETWEEN condition always performs better than using the >= and <= conditions. The join syntax used makes no difference to performance. The BETWEEN condition always performs less well than using the >= and <= conditions. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

58. 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?. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space. Add the AUTOEXTEND ON clause with NEXT set to 100M. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

59. Examine this command and some partial output: Why does the DB01.abc.com service show unknown status?. The service DB01.abc.com is dynamically registered. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1. The service DB01.abc.com is statically registered. The listener is not listening on the default port 1521. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file.

60. Which three statements are true about the tools used to configure Oracle Net Services?. The Oracle Net Configuration Assistant is only used when running the Oracle installer. Oracle Net Manager can be used to centrally configure listeners on any database server target. The lsnrctl utility requires a listener.ora file to exist before it is started. Oracle Net Manager can be used to locally configure naming methods on a database server. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

61. Which two statements are true regarding the UNION and UNION ALL operators?. Duplicates are eliminated automatically by the UNION ALL operator. The number of columns selected in each SELECT statement must be identical. The names of columns selected in each SELECT statement must be identical. The output is sorted by the UNION ALL operator. NULLS are not ignored during duplicate checking.

62. Which two statements are true about the Automatic Diagnostic Repository (ADR)?. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set. It supports diagnostics for Automatic Storage Management (ASM). It supports diagnostics for Oracle Clusterware. It is held inside an Oracle database schema.

63. You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?. analysis of all privileges used by all users including administrative users in the database. analysis of all privileges used by all users but excluding administrative users in the database. analysis of privileges that a user has on their own schema objects that they did not use. analysis of privileges that a user has on their own schema objects that they did use. analysis of privileges granted directly to a role that are then used by a user who has been granted that role. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.

64. Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance?. An undo segment may be used by multiple transactions simultaneously. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment. Undo segments have a minimum of three extents. Undo segments can extend when a transaction fills the last extent of the undo segment. A single transaction may use multiple undo segments simultaneously. Undo segments must be stored in a BIGFILE tablespace. Undo segments must be stored in a SMALLFILE tablespace.

65. Which two statements are true about Enterprise Manager Database Express?. It is available only when the database is open. It can be used to perform database recovery. The same port number can be used for Database Express configurations for databases on different hosts. It can be used to switch a database into ARCHIVELOGMODE. The same port number can be used for multiple Database Express configurations for multiple databases on the same host.

66. 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?. Employee 100 will have SALARY set to the same value as the SALARY of employee 200. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100. Employee 200 will have SALARY set to the same value as the SALARY of employee 100. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200. Employees 100 and 200 will have the same JOB_ID as before the update command. Employees 100 and 200 will have the same SALARY as before the update command.

67. Which two are true about a SQL statement using SET operators such as UNION?. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query. The number, but not names, of columns must be identical for all SELECT statements in the query. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query. The names and number of columns must be identical for all SELECT statements in the query. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

68. Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?. The CURRENT_TIMESTAMP function returns data without time zone information. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row. A TIMESTAMP data type column contains information about year, month, and day. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC). The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC).

69. Which three statements are true about inner and outer joins?. A full outer join returns matched and unmatched rows. An inner join returns matched rows. Outer joins can only be used between two tables per query. A full outer join must use Oracle syntax. Outer joins can be used when there are multiple join conditions on two tables. A left or right outer join returns only unmatched rows.

70. Examine this description of the TRANSACTIONS table: Which two SQL statements execute successfully?. SELECT customer_id AS €CUSTOMER-ID €, transaction_date AS DATE, amount + 100 €DUES€ FROM transactions;. SELECT customer_id AS €CUSTOMER-ID€, transaction_date AS DATE €, amount + 100 DUES FROM transactions;. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 €DUES AMOUNT€ FROM transactions;. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;. SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;.

71. The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully?. SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;. SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;. SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;. SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;.

72. Which statement is true about aggregate functions?. Aggregate functions can be nested to any number of levels. The AVG function implicitly converts NULLS to zero. Aggregate functions can be used in any clause of a SELECT statement. The MAX and MIN functions can be used on columns with character data types.

73. Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command: ALTER DATABASE MOUNT; Which two actions are performed?. The online redo logs are opened. The online data files are opened. The alert log records the execution details. The Oracle background processes are started. The initialization parameter file is read. The control file is read.

74. Which two are true about shrinking a segment online?. It is not possible to shrink either indexes or Index Organized Tables (IOTs). It always eliminates all migrated rows if any exist in the table. To shrink a table it must have a PRIMARY KEY constraint. To shrink a table it must have a UNIQUE KEY constraint. To shrink a table it must have row movement enabled. It must be in a tablespace that uses Automatic Segment Space Management (ASSM).

75. Examine these command: Which two statements are true about the sqldr execution?. It overwrites data in EMP with data in EMP.DAT. It uses the database buffer cache to load data. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations. It generates a sql script that it uses to load data from EMP.DAT to EMP. It appends data from EMP.DAT to EMP.

76. A script abc.sql must be executed to perform a job. A database user HR, who is defined in this database, executes this command: $ sqlplus hr/hr@orcl @abc.sql What will happen upon execution?. The command succeeds and HR will be connected to the orcl and abc.sql databases. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed. The command fails because the script must refer to the full path name Questions& Answers PDF P-35. The command fails and reports an error because @ is used twice.

77. Which three statements are true regarding indexes?. A UNIQUE index can be altered to be non-unique. A SELECT statement can access one or more indices without accessing any tables. A table belonging to one user can have an index that belongs to a different user. An update to a table can result in updates to any or all of the table's indexes. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped. An update to a table can result in no updates to any of the table's indexes.

78. Which three statements are true about Oracle synonyms?. A synonym cannot be created for a PL/SQL package. A synonym can be available to all users. A SEQUENCE can have a synonym. A synonym created by one user can refer to an object belonging to another user. Any user can drop a PUBLIC synonym.

79.View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries?. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE. Display suppliers whose PROD_LIST_PRICE is less than 1000. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable. Display the total number of products supplied by supplier 102 which have a product status of obsolete. Display the minimum PROD_LIST_PRICE for each product status.

80. The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace. Segment creation is not deferred. You execute this command: Which three statements must be true so that the SALES user can create tables in SALES_Q1?. The sales user must have a quota on the TEMP tablespace. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema. The sales user must have been granted the CREATE SESSION privilege. The sales user must have their quota on the users tablespace removed. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema. The sales user must have been granted the CREATE TABLE privilege.

81. Which three statements are true about table data storage in an Oracle Database?. Data block headers contain their own Data Block Address (DBA). A table row piece can be chained across several database blocks. Multiple row pieces from the same row may be stored in different database blocks. Multiple row pieces from the same row may be stored in the same block. Data block free space is always contiguous in the middle of the block. Index block free space is always contiguous in the middle of the block.

82. 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?. The second ROLLBACK command does nothing. The second ROLLBACK command replays the delete. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed. The second ROLLBACK command undoes the insert. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row.

83. Which three statements are true about external tables in Oracle 18c and later releases?. External table files can be used for other external tables in a different database. The ORACLE_LOADER access driver can be used to unload data from a database into an external table. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table. They cannot be partitioned. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table. They support UPDATEs but not INSERTs and DELETEs.

84. Which three statements are true about the Oracle join and ANSI join syntax?. The Oracle join syntax supports creation of a Cartesian product of two tables. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax. The SQL:1999 compliant ANSI join syntax supports natural joins. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables. The Oracle join syntax only supports right outer joins. The Oracle join syntax supports natural joins. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.

85. Which two tasks can you perform using DBCA for databases?. Configure a nonstandard block size for a new database. Register a new database with an available Enterprise Manager Management server. Change the standard block size of an existing database. Configure incremental backups for a new database. Enable flashback database for an existing database.

86. You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr') What is the result?. It executes successfully but does not return any result. It returns the date for the first Monday of the next month. It generates an error. It returns the date for the last Monday of the current month.

87. Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE 'undotbs_01.dbf' SIZE 100M - AUTOEXTEND ON; Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace?. Add the SEGMENT SPACE MANAGEMENT AUTO clause. Set UNDO_TABLESPACE to UNDOTBS01. Add the NOLOGGING clause. Make certain that the database operates in automatic undo management mode. Add the ONLINE clause.

88. Which three statements are true about views in an Oracle database?. Views can be updated without the need to re-grant privileges on the view. Tables in the defining query of a view must always exist in order to create the view. The WITH CHECK clause prevents certain rows from being displayed when querying the view. Data Manipulation Language (DML) can always be used on views. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error. The WITH CHECK clause prevents certain rows from being updated or inserted.

89. You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf SIZE 5G - SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?. It must be smaller than the smallest BIGFILE tablespace. Free space is managed using freelists. Any data files added to the tablespace must have a size of 5 gigabytes. It uses the database default blocksize. It is a locally managed tablespace.

90. In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB); Which segment or segments, if any, are created as a result of executing the command?. T1, an index segment for the primary key, a LOB segment, and a lobindex segment. no segments are created. T1 only. T1 and an index segment created for the primary key only. T1, an index segment for the primary key, and a LOB segment only.

91. Which three activities are recorded in the database alert log?. Data Definition Language (DDL) statements. non-default database parameters. block corruption errors. deadlock errors. session logins and logouts.

92. Which two statements are true about Enterprise Manager (EM) Express?. You can use a single instance of EM Express to manage multiple database running on the same server. EM Express uses a separate repository database to store target database metadata. By default, EM express is available for a database after database creation using DBCA. You can shut down a database instance using EM Express. You cannot start up a database instance using EM Express.

93. Examine this SQL statement: SELECT cust_id, cust_last_name `Last Name` FROM customers - WHERE country_id = 10 - UNION - SELECT cust_id CUST_NO, cust_last_name FROM customers - WHERE country_id = 30 - Identify three ORDER BY clauses, any one of which can complete the query successfully. ORDER BY € Last Name. ORDER BY 2, 1. ORDER BY 2, cust_id. ORDER BY CUST_NO. ORDER BY €CUST_NO€.

94. Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION?. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO. UNDO_RETENTION specifies how long all types of UNDO are retained. Unexpired UNDO is always retained. Active UNDO is always retained. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

95. Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these SQL statements: Statement 1: SELECT MAX(unit_price * quantity) `Maximum Order` FROM order_items; Statement 2: SELECT MAX(unit_price * quantity) `Maximum Order` FROM order_items - GROUP BY order_id; Which two statements are true?. Statement 1 returns only one row of output. Statement 2 returns only one row of output. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL. Both the statements give the same output. Statement 2 may return multiple rows of output.

96. Which three files are used by conventional path SQL*Loader when the TABLE option is not specified?. dump files. control files. password files. bad files. input files.

97. Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection?. Local Naming requires setting the TNS_ADMIN environment variable on the client side. A client can connect to an Oracle database instance even if no client side network admin has been configured. Directory Naming can be used if Connect-Time Failover is required. Easy Connect supports TCP/IP and SSL. Local naming can be used if Connect-Time Failover is required. Directory Naming requires setting the TNS_ADMIN environment variable on the client side.

98.Which two statements are true about User Authentication in an Oracle Database?. Password authentication must be used for system-privileged administrative users. Password File authentication must be used for system-privileged administrative users. Operating System authentication may be used for system-privileged administrative users. Password File authentication is supported for any type of database user. REMOTE_LOGIN_PASSWORDFILE must be set to exclusive to permit password changes for system-privileged administrative users.

99. Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?. the first NUMBER column in the first SELECT of the compound query. the first NUMBER or VARCHAR2 column in the last SELECT of the compound query. the first column in the last SELECT of the compound query. the first column in the first SELECT of the compound query. the first VARCHAR2 column in the first SELECT of the compound query.

100. 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?. SELECT prod_id "CURRENT AVAILABILITY" || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id q's not available"' FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id || q'('s not available)' 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id || q"'s not available"' FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id || q'('s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK';.