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

101. Which two statements are true about UNDO and UNDO tablespaces?. There can be only one UNDO tablespace created in a database. UNDO segments are owned by SYSTEM. UNDO segments are owned by SYSBACKUP. An UNDO tablespace may be owned by only one instance. An instance will crash if the active undo tablespace is lost.

102. You must create a tablespace of non-standard block size in a new le system and plan to use this command: The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed?. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE. The /u02 le system must have at least 100g space for the data le. The operating system must use a 32k block size. DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE.

103. Examine the description of the PRODUCTS table: Which query is valid?. SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id;. SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date;. SELECT prod_id, AVG(MAX(cost)) FROM products GROUP BY prod_id;. SELECT prod_id, MAX(AVG(cost)) FROM products GROUP BY prod_id;.

104. Which two statements are true about the Oracle Data Dictionary?. All data dictionary view join base tables to dynamic performance views. Data dictionary base tables can be queried directly. It is owned by the SYS user. It is owned by the SYSTEM user. Data dictionary views are always created with queries that join two or more base tables.

105. Which two Oracle database space management features require the use of locally managed tablespaces?. Automatic data le extension (AUTOEXTEND). Server-generated tablespace space alerts. Online segment shrink. Free space management with bitmaps. Oracle Managed Files (OMF).

106. Which three statements are true about connection strings and service names used to connect to an Oracle database instance?. A connection string must include the SID of a database instance. A connection string including a service name must be de ned in the tnsnames.ora le. A single database instance can support connections for multiple service names. A single connection string can refer to multiple database instances. A service name is created by a listener. Different connection strings in the same tnsnames.ora le can contain the same service name, host and port parameters.

107. Which three statements are true about using SQL*Plus?. It has both command-line and graphical user interfaces (GUI). It must be downloaded from the Oracle Technology Network (OTN). It can run Recovery Manager (RMAN) commands. It has its own commands that are separate from any SQL statements. It can run scripts entered at the SQL prompt. It can run scripts passed to it by a shell script.

108. The orders table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR. Which two WHERE conditions demonstrate the correct usage of conversion functions?. WHERE order_date > TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY'). WHERE order dare > TO DATE('JUL 10 2018', 'MON DD YYYY'). WHERE TO_CHAR(order date, 'MON DD YYYY') = 'JAN 20 2019'. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY'). WHERE order_date IN (TO_DATE('Oct 21 2018', 'Mon DD YYYY'), TO_CHAR('Nov 21 2018', 'Mon DD YYYY')).

109. Which three statements are true about the Automatic Diagnostic Repository (ADR)?. It can be used for problem diagnosis of a database when that database's instance is down. The ADR base is speci ed in the DIAGNIOSTIC_DEST database parameter. It is held inside an Oracle database schema. It is a le-based repository held outside any database. It is only used for Oracle Database diagnostic information.

110. Which two statements are true about a self join?. It can be an inner join. It can be a left outer join. It must be an equijoin. The join key column must have an index. It must be a full outer join.

111. Which statement is true about database links?. Private database link creation requires the same user to exist in both the local and the remote databases. A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance. A public database link can be created only by SYS. A database link can be created only between two Oracle databases.

112. Which two queries execute successfully?. SELECT NULLIF(NULL, 100) FROM DUAL;. SELECT NULLIF(100, 'A') FROM DUAL;. SELECT COALESCE(100, 'A') FROM DUAL;. SELECT COALESCE(100, NULL, 200) FROM DUAL;. SELECT NULLIF(100, 100) FROM DUAL;.

113. Which three statements are true about data block storage in an Oracle Database?. An index block can contain row data. A data block header is of a xed length. Row data is stored starting at the end of the block. A table block must always contain row data. A block header contains a row directory pointing to all rows in the block.

114. Which two are bene ts of external tables?. They support DELETES which transparently deletes records in the le system as if they were table rows. They can be queried, transformed, and joined with other tables without having to load the data rst. They support UPDATES which transparently updates records in the le system as if they were table rows. The results of a complex join or aggregating function or both can be unloaded to a le for transportation to another database. They can be queried while the database is in the MOUNT state like dynamic performance views.

115. Examine the description of the MEMBERS table: Examine the partial query: SELECT city, last_name LNAME 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?. ORDER BY 1, 2. WHERE city = '%AN%'. WHERE city LIKE '%AN%'. ORDER BY last_name DESC, city ASC. WHERE city IN ('%AN%'). ORDER BY 1, LNAME DESC.

116. Which three statements are true about sequences in a single instance Oracle database?. Sequences can always have gaps. Two or more tables cannot have keys generated from the same sequence. A sequence's unallocated cached values are lost if the instance shuts down. A sequence can issue duplicate values. A sequence can only be dropped by a DBA. A sequence number that was allocated can be rolled back if a transaction fails.

117. Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where is the value changed?. in the SPFILE, PFILE, and memory. in the SPFILE and in memory. only in the SPFILE. only in memory. in the SPFILE and PFILE.

118. 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 two are types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?. analysis of privileges that a user has on other schema’s objects. analysis of privileges that a user has on their own schema objects. analysis of all privileges used by the sys user. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role. analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

119. Examine the description of the SALES table: The SALES table has 55,000 rows. Examine this statement: CREATE TABLE sales1 (prod_id, cust_id, quantity_sold, price) AS SELECT product_id, customer_id, quantity_sold, price FROM sales WHERE 1 = 1; Which two statements are true?. SALES1 is created with l row. SALES1 is created with no rows. SALES1 has primary KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table. SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table. SALES1 is created with 55,000 rows.

120. Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers de ned?. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the de ning query of the view. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view. Delete statements can always be done on a table through a view. Views cannot be used to add or modify rows in an underlying table if the de ning query of the view contains the DISTINCT keyword. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the de ning query of the view. Insert statements can always be done on a table through a view.

121. Which three statements are true about indexes and their administration in an Oracle database?. An index can be created as part of a CREATE TABLE statement. If a query lters on an indexed column, then it will always be used during execution of the query. A descending index is a type of function-based index. A DROP INDEX statement always prevents updates to the table during the drop operation. A UNIQUE and non-unique index can be created on the same table column. An INVINSIBLE INDEX is not maintained when Data Manipulation Language (DML) is performed on its underlying table.

122. Which three actions are ways to apply the principle of least privilege?. setting the O7_DICTIONARY_ACCESSIBILITY parameter to true. setting the REMOTE_OS_AUTHENT parameter to true. revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the SYSTEM user. enabling Uni ed Auditing. using Access Control Lists (ACLs). revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the public user.

123. The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which WHERE clause can be used?. WHERE ADD_MONTHS(start_date, 25) <= SYSDATE. WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <=25. WHERE TO_NUMBER(start date - SYSDATE) <= 25.

124. Examine the description of the BOOKS_TRANSACTIONS table: Examine this partial SQL statement: SELECT * FROM books_transactions Which two WHERE conditions give the same result?. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR menber_id IN ('A101', 'A102'));. WHERE (borrowed_date = SYSDATE AND transaction_type - 'RM') OR member_id IN ('A101', VA102');.

125. Which two statements are true about views?. The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view. The WITH CHECK clause prevents certain rows from being displayed when querying the view. Views can be updated without the need to re-grant privileges on the view. A view must only refer to tables in its de ning query. Views can be indexed.

126. Which compression method is recommended for Direct-Path Insert operations?. ROW STORE COMPRESS BASIC. ROW STORE COMPRESS ADVANCED. COLUMN STORE COMPRESS ADVANCED. COLUMN STORE COMPRESS BASIC.

127. Which three statements are true about Deferred Segment Creation in Oracle databases?. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces. It is the default behavior for tables and indexes. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation. Indexes inherit the DEFERRED to IMMEDIATE segment creation attribute from their parent table. It is supported for SYS-owned tables contained in locally managed tablespaces.

128. Examine these statements executed in a single Oracle session: Which three statements are true?. The code for pen is 10. There is no row containing fountain pen. There is no row containing pen. The code for fountain pen is 3. The code for pen is l. There is no row containing pencil.

129. Examine the description of the SALES1 table: SALES2 is a table with the same description as SALES1. Some sales data is contained erroneously in both tables. You must display rows from SALES1 and SALES2 and wish to see the duplicates too. Which set operator generates the required output?. UNION ALL. SUBTRACT. MINUS. UNION. INTERSECT.

130. In the promotions table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR. Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query?. TO_NUMBER(PROMO_BEGIN_DATE) - 5 will return a number. PROMO_BEGIN_DATE - SYSDATE will return an error. PROMO_BEGIN_DATE - SYSDATE will return a number. PROMO_BEGIN_DATE - 5 will return a date. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.

131. Which two statements are true regarding indexes?. A non-unique index can be altered to be unique. An update to a table can result in no updates to any of the table's indexes. The RECYCLE BIN never contains indexes. An update to a table can result in updates to any or all of the table's indexes. A table belonging to one user cannot have an index that belongs to a different user.

132. Which three statements are true regarding single row subqueries?. A SQL statement may have multiple single row subquery blocks. They can be used in the WHERE clause. They must be placed on the left side of the comparison operator or condition. They can be used in the HAVING clause. They must be placed on the right side of the comparison operator or condition. They must return a row to prevent errors in the SQL statement.

133. Which two statements are true about Oracle synonyms?. Any user can create a public synonym. A synonym has an object number. A synonym can be created on an object in a package. All private synonym names must be unique in the database. A synonym can have a synonym.

134. Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true?. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment. Queries and DML statements are allowed on ORDERS while the SHRINK is executing. Dependent indexes become UNUSABLE. Only queries are allowed on ORDERS while the shrink is executing. The high-water mark (HWM) of ORDERS is adjusted. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

135. The sales table has columns PROD_ID and QUANTITY_SOLD of data type number. Which two queries execute successfully?. SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;. SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;. SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY COUNT(*) > 10;. SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY proa_id HAVING COUNT(*) > 10;. SELECT prcd_id FROM sales WHERE quantity_sold > 55000 AND COUNT (*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;.

136. Examine the description of the PRODUCT_DETAILS table: Which two statements are true?. PRODUCT_ID can be assigned the PRIMARY KEY constraint. EXPIRY_DATE cannot be used in arithmetic expressions. PRODUCT_NAME cannot contain duplicate values. EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it. PRODUCT_PRICE contains the value zero by default if no value is assigned to it.

137.Which two statements are true about INTERVAL data types?. INTERVAL DAY TO SECOND columns support fractions of seconds. The YEAR eld in an INTERVAL YEAR TO MONTH column must be a positive value. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year. INTERVAL YEAR TO MONTH support yearly intervals.

138. Examine the description of the EMPLOYEES table: NLS_DATE_FORMAT is set to DD-MON-YY. Which query requires explicit data type conversion?. SELECT join_date FROM employees WHERE join_date > '10-02-2018';. SELECT join_date + '20' FROM employees;. SELECT salary + '120.50' FROM employees;. SELECT SUBSTR(join_date, 1, 2) - 10 FROM employees;. SELECT join_date || ' ' || salary FROM employees.

139. You start your database instance in NOMOUNT state. Which two actions are performed?. SYS can access the database. The consistency of the database is checked. The control les are opened. All required background processes are started. Memory is allocated for the SGA.

140. Which two statements are true about the PMON background process?. It registers database services with all local and remote listeners known to the database instance. It frees unused temporary segments. It rolls back transactions when a process fails. It records checkpoint information in the control le. It frees resources held by abnormally terminated processes.

141. Which two statements are true about the Oracle join and ANSI join syntax?. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax. The Oracle join syntax lacks the ability to do outer joins. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables. 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.

142. Which two statements are true about single row functions?. CEIL : can be used for positive and negative numbers. MOD : returns the remainder of a division operation. CONCAT : can be used to combine any number of values. FLOOR : returns the smallest integer greater than or equal to a speci ed number. TRUNC : can be used only with NUMBER data types.

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

144. Examine the description of the CUSTOMERS table: You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000. Examine this partial query: SELECT cust_last_name, cust_credit_limit FROM customers Which two WHERE conditions give the required result?. WHERE (UPPER(cust_last_name) LIKE 'A%' OR UPPER(cust_last_name) LIKE 'B%') AND ROUND(cust_credit_limit) < 1000;. WHERE (INITCAP(cust_last_name) LIKE 'A%' OR INITCAP(cust_last_name) LIKE 'B%') AND cust_credit_limit < 1000;. WHERE UPPER(cust_last_name) IN ('A%', 'B%') AND cust_credit_limit < 1000;. WHERE (UPPER(cust_last_name) LIKE INITCAP('A') OR UPPER(cust_last_name) LIKE INITCAP('B')) AND ROUND(cust_credit_limit) < ROUND(1000);. WHERE UPPER(cust_last_name) BETWEEN UPPER('A%') AND 'B%' AND ROUND(cust_credit_limit) < 1000;.

145. Which two statements are true about substitution variables?. A substitution variable can be used with any clause in a SELECT statement. A substitution variable used to prompt for a column name must be enclosed in double quotation marks. A substitution variable used to prompt for a column name must be enclosed in single quotation marks. A substitution variable pre xed with & always prompts only once for a value in a session. A substitution variable can be used only in a SELECT statement. A substitution variable pre xed with && prompts only once for a value in a session unless it is set to unde ned in the session.

146. The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson. Which query produces output for CUST_LAST_NAME containing Oder for the rst row and Aus for the second?. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;. SELECT REPLACE(TRIM(TRAILING 'son' FROM cust_last_name), 'An', 'O') FROM customers;. SELECT INITCAP(REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O')) FROM customers;. SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O') FROM customers;.

147. Which two statements are true about GLOBAL TEMPORARY TABLES?. GLOBAL TEMPORARY TABLE space allocation occurs at session start. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table. A TRUNCATE command issued in a session causes all news in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted. A GLOBAL TEMPORARY TABLE 's de nition is available to multiple sessions. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

148. Which three statements are true about Resumable Space Allocation in Oracle databases?. A user's session may be suspended and resumed multiple times. The AFTER SUSPEND event trigger can itself be suspended due to space conditions. All sessions must have the same timeout value when waiting for resumable space allocations. Resumable space allocation is only possible with locally managed tablespaces. A user's session may be suspended even if the user has the UNLTMTTED TABLESPACE system privilege. Resumable space allocation may be enabled for some sessions and not others.

149. Examine the description of the PRODUCT_INFORMATION table: Which query retrieves the number of products with a null list price?. SELECT COUNT(list_price) FROM product_information WHERE list_price IS NULL;. SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;. SELECT COUNT(DISTINCT list price) FROM product_information WHERE list_price IS NULL;. SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL.

150.Examine the description of the CUSTOMERS table: Which two methods can you use to get the required result?. subquery. self join. LEFT OUTER JOIN with self join. RIGHT OUTER JOIN With self join. FULL OUTER JOIN with self join.