[Feb-2022] 1Z0-082 Exam Dumps, 1Z0-082 Practice Test Questions
Attested 1Z0-082 Dumps PDF Resource [2022]
NEW QUESTION 44
Which two functions are performed by a listener?
- A. verifying the service name in an incoming user request
- B. returning the results of processing from the server process to the user process
- C. verifying a user's authentication credentials
- D. connecting a user process to a server process
- E. maintaining the connection to a client's user process until the user request is completed
- F. creating a user session in the System Global Area (SGA)
Answer: B,D
NEW QUESTION 45
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
- A. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
- B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
- C. The Oracle join syntax supports natural joins
- D. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax
- E. The Oracle join syntax only supports right outer joins
- F. The Oracle join syntax supports creation of a Cartesian product of two tables
- G. The SQL:1999 compliant ANSI join syntax supports natural joins
Answer: A,F,G
Explanation:
https://oracle-base.com/articles/9i/ansi-iso-sql-support
NEW QUESTION 46
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
- A. Free space is managed using freelists
- B. It uses the database default blocksize
- C. It is a locally managed tablespace
- D. It must be smaller than the smallest BIGFILE tablespace
- E. Any data files added to the tablespace must have a size of 5 gigabytes
Answer: B,C
NEW QUESTION 47
Which two statements are true about views used for viewing tablespace and datafile information?
(Choose two.)
- A. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
- B. V$TABLESPACE displays information that is contained in the controlfile about tablespaces
- C. Tablespace free space can be viewed in DBA_TABLESPACES
- D. V$TABLESPACE displays information about tablespaces contained in the data dictionary
- E. Tablespace free space can be viewed in V$TABLESPACE
Answer: A,B
NEW QUESTION 48
Your database instance is started with a PFILE.
Examine these parameters:
You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?
- A. It fails because the SCOPE clause is missing
- B. The value is changed for the current instance and in the PFILE
- C. Change is applied to the current instance, but does not persist after instance restart
- D. The value is changed only in the PFILE and takes effect at the next instance startup
Answer: C
Explanation:
Reference:
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
NEW QUESTION 49
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:
Exhibit 1.
Exhibit 2.
What will be the result?
- A. It executes successfully and gives the required result
- B. It gives an error because the GROUP BY clause is not valid
- C. It executes successfully but does not give the required result
- D. It gives an error because the ALL keyword is not valid
Answer: A
NEW QUESTION 50
Which three statements are true about the DESCRIBE command? (Choose three.)
- A. It can be used from SQL Developer
- B. It can be used to display the structure of an existing view
- C. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
- D. It displays the NOT NULL constraint for any columns that have that constraint
- E. It can be used only from SQL *Plus
- F. It displays all constraints that are defined for each column
Answer: B,D,E
NEW QUESTION 51
Your database instance is started with a PFILE.
Examine these parameters:
You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?
- A. It fails because the SCOPE clause is missing
- B. The value is changed for the current instance and in the PFILE
- C. Change is applied to the current instance, but does not persist after instance restart
- D. The value is changed only in the PFILE and takes effect at the next instance startup
Answer: C
NEW QUESTION 52
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?
- A. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
- B. It succeeds and the generated undo is stored in SYSTEM.
- C. It succeeds and the generated undo is stored in SYSAUX.
- D. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
'UNDOTBS1' ". - E. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
Answer: E
Explanation:
Explanation
NEW QUESTION 53
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
- A. A table that is truncated will always have its segment removed
- B. An index that is altered to be UNUSABLE will retain its segment
- C. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
- D. An index created with the UNUSABLE attribute has no segment
- E. Private Temporary Tables (PTTS) store metadata in memory only
Answer: C,D
NEW QUESTION 54
Which two statements are true about single row functions? (Choose two.)
- A. TRUNC : can be used to combine any number of values
- B. FLOOR : returns the smallest integer greater than or equal to a specified number
- C. MOD : returns the quotient of a division operation
- D. CONCAT : can be used to combine any number of values
- E. CEIL : can be used for positive and negative numbers
Answer: A,C
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row- Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C
NEW QUESTION 55
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. SELECT &col1, &col2
FROM &&table
WHERE &condition; - B. SELECT &col1, &col2
FROM "&table"
WHERE &condition; - C. SELECT &&col1, &&col2
FROM &table
WHERE &&condition; - D. SELECT `&&col1', `&&col2'
FROM &table
WHERE `&&condition' = `&cond'; - E. SELECT &&col1, &&col2
FROM &table
WHERE &&condition = &&cond;
Answer: A
NEW QUESTION 56
Which three statements are true regarding indexes? (Choose three.)
- A. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
- B. A SELECT statement can access one or more indices without accessing any tables
- C. A table belonging to one user can have an index that belongs to a different user
- D. An update to a table can result in no updates to any of the table's indexes
- E. A UNIQUE index can be altered to be non-unique
- F. An update to a table can result in updates to any or all of the table's indexes
Answer: A,E,F
NEW QUESTION 57
Which three statements are true about the Oracle Data Dictionary? (Choose three.)
- A. Usernames of all users including database administrators are stored in the data dictionary
- B. The data dictionary is created and maintained by the database administrator
- C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
- D. Base tables can be queried directly
- E. It is owned by the SYSTEM user
- F. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
Answer: A,C,D
NEW QUESTION 58
Examine this description of the TRANSACTIONS table:
Which two SQL statements execute successfully? (Choose two.)
- A. SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;
- B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
- C. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
- D. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
"DUES AMOUNT" FROM transactions; - E. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
Answer: C,E
NEW QUESTION 59
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? (Choose two.)
- A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
- B. Add the AUTOEXTEND ON clause with NEXT set to 100M.
- C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
- D. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
- E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
Answer: C,D
NEW QUESTION 60
Which three statements are true concerning logical and physical database structures? (Choose three.)
- A. A segment's blocks can be of different sizes
- B. A segment can span multiple data files in some tablespaces
- C. A smallfile tablespace might be bigger than a bigfile tablespace
- D. Segments can span multiple tablespaces
- E. The extents of a segment must always reside in the same datafile
- F. All tablespaces may have one or more data files
- G. A segment might have only one extent
Answer: C,E,G
NEW QUESTION 61
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
- A. The same port number can be used for Database Express configurations for databases on different hosts
- B. It can be used to perform database recovery
- C. It can be used to switch a database into ARCHIVELOGMODE
- D. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
- E. It is available only when the database is open
Answer: A,E
Explanation:
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/getting-started-with-database-administration.html#GUID-EB851101-07BE-4038-BB9D-06E01CC7F5D5
NEW QUESTION 62
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:
Exhibit 1.
Exhibit 2.
What will be the result?
- A. It executes successfully and gives the required result
- B. It gives an error because the GROUP BY clause is not valid
- C. It executes successfully but does not give the required result
- D. It gives an error because the ALL keyword is not valid
Answer: A
NEW QUESTION 63
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?
- A. TIMESTAMP
- B. TIMESTAMP WITH TIMEZONE
- C. INTERVAL YEAR TO MONTH
- D. INTERVAL DAY TO SECOND
- E. TIMESTAMP WITH LOCAL TIMEZONE
Answer: D
NEW QUESTION 64
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Configure incremental backups for a new database
- B. Change the standard block size of an existing database
- C. Register a new database with an available Enterprise Manager Management server
- D. Enable flashback database for an existing database
- E. Configure a nonstandard block size for a new database
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm
NEW QUESTION 65
Which three statements are true about inner and outer joins? (Choose three.)
- A. A full outer join returns matched and unmatched rows
- B. A full outer join must use Oracle syntax
- C. A left or right outer join returns only unmatched rows
- D. Outer joins can be used when there are multiple join conditions on two tables
- E. Outer joins can only be used between two tables per query
- F. An inner join returns matched rows
Answer: A,D,F
NEW QUESTION 66
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. TIMESTAMP
- B. TIMESTAMP WITH TIMEZONE
- C. INTERVAL YEAR TO MONTH
- D. INTERVAL DAY TO SECOND
- E. TIMESTAMP WITH LOCAL TIMEZONE
Answer: D
NEW QUESTION 67
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. Dynamic service registration cannot be used for this database instance
- B. The LREG process registers services dynamically with the LISTENER_1 listener
- C. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
- D. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
- E. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
Answer: E
NEW QUESTION 68
......
Latest 1Z0-082 Actual Free Exam Questions Updated 118 Questions: https://prepaway.testkingpass.com/1Z0-082-testking-dumps.html