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?
You have been tasked to create a table for a banking application. One of the columns must meet three requirements: Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?
A. It is available only when the database is open
A. INTERVAL YEAR TO MONTH
B. It can be used to perform database recovery
B. INTERVAL DAY TO SECOND
C. The same port number can be used for Database Express configurations for databases on different hosts
C. TIMESTAMP WITH LOCAL TIMEZONE
D. It can be used to switch a database into ARCHIVELOGMODE
D. TIMESTAMP
E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
E. TIMESTAMP WITH TIMEZONE
Answer:
B
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
0/ 1000
Question 7
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:
Which statement is true?
A. It gives an error because the ALL keyword is not valid
A. Dynamic service registration cannot be used for this database instance
B. It gives an error because the GROUP BY clause is not valid
B. The LREG process registers services dynamically with the LISTENER_1 listener
C. It executes successfully but does not give the required result
C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
D. It executes successfully and gives the required result
D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
Answer:
B
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
Explanation: The listener forwards client requests to supported services. These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file. Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292 Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
Discussions
0/ 1000
Question 8
Which three statements are true concerning logical and physical database structures? (Choose three.)
A. External table files can be used for other external tables in a different database
A. All tablespaces may have one or more data files
B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table
B. The extents of a segment must always reside in the same datafile
C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
C. A smallfile tablespace might be bigger than a bigfile tablespace
D. They cannot be partitioned
D. A segment can span multiple data files in some tablespaces
E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
E. A segment’s blocks can be of different sizes
F. They support UPDATEs but not INSERTs and DELETEs
F. A segment might have only one extent
G. Segments can span multiple tablespaces
Answer:
BCF
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%
G
50%
Discussions
0/ 1000
Question 9
Which two statements are true regarding a SAVEPOINT? (Choose two.)
A. It can be used only in SQL*Plus
A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
B. It displays values for variables used only in the WHERE clause of a query
B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
C. It can be used in SQL Developer and SQL*Plus
C. Only one SAVEPOINT may be issued in a transaction
D. It displays values for variables created by the DEFINE command
D. A SAVEPOINT does not issue a COMMIT
E. It displays values for variables prefixed with &&
E. Rolling back to a SAVEPOINT can undo a DELETE statement
Answer:
D,E
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
0/ 1000
Question 10
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
A. You can no longer monitor it
A. writing inbound request to the common request queue from all shared server connections
B. You can reattach to it and monitor it
B. checking for outbound shared server responses on the common outbound response queue
C. It is paused and can be resumed
C. receiving inbound requests from processes using shared server connections
D. It continues to run in the background
D. sending each connection input request to the appropriate shared server input queue
E. It terminates
E. broadcasting shared server session responses back to requesters on all connections
F. sending shared server session responses back to requesters on the appropriate connection
Which two statements are true about the SET VERIFY ON command? (Choose two.)
A. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
A. It can be used only in SQL*Plus
B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
B. It displays values for variables used only in the WHERE clause of a query
C. The HAVING clause can be used with aggregating functions in subqueries
C. It can be used in SQL Developer and SQL*Plus
D. The WHERE clause can be used to exclude rows before dividing them into groups
D. It displays values for variables created by the DEFINE command
E. The WHERE clause can be used to exclude rows after dividing them into groups
E. It displays values for variables prefixed with &&
Answer:
CE
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
0/ 1000
Question 12
Which three statements are true about a self join? (Choose three.)
A. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
A. The ON clause must be used
B. SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;
B. The query must use two different aliases for the table
C. SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;
C. It must be an equijoin
D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
D. It must be an inner join
E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
E. The ON clause can be used
F. It can be an outer join
Answer:
B, E, F
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
0/ 1000
Question 13
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed. The variables used in your query are never undefined in your session. Which query can be used?
A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
B. It can be used from SQL Developer
B. SELECT &col1, &col2FROM &&tableWHERE &condition;
C. It displays the NOT NULL constraint for any columns that have that constraint
C. SELECT &col1, &col2FROM “&table”WHERE &condition;
D. It can be used to display the structure of an existing view
D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;
E. It displays all constraints that are defined for each column
E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;
F. It can be used only from SQL*Plus
Answer:
B
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
0/ 1000
Question 14
Examine the description of the CUSTOMERS table:
You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Which query can be used?
A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
A. SELECT * FROM customers WHERE city LIKE ‘D_%’;
B. SYSDATE can be queried only from the DUAL table
B. SELECT * FROM customers WHERE city = ‘%D_’;
C. CURRENT_DATE returns the current date and time as per the session time zone
C. SELECT * FROM customers WHERE city LIKE ‘D_’;
D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
D. SELECT * FROM customers WHERE city = ‘D_%’;
E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
Answer:
A
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
F
50%
Discussions
0/ 1000
Question 15
Examine this command:
Which two statements are true? (Choose two.)
A. The command succeeds and HR will be connected to the orcl and abc.sql databases
A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
B. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
C. The command fails because the script must refer to the full path name
C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
D. The command fails and reports an error because @ is used twice
D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
E. The file is renamed and stored in the same location