20:00

PDF|

Guide for Oracle Database Administration I

Quiz Oracle Database Administration I

Free Test
/ 10

Quiz

1/10
Which statement is true about the INTERSECT operator used in compound queries?
Select the answer
1 correct answer
A.
Multiple INTERSECT operators are not possible in the same SQL statement
B.
It processes NULLs in the selected columns
C.
INTERSECT is of lower precedence than UNION or UNION ALL
D.
It ignores NULLs

Quiz

2/10
You execute this command: Certification Exam Oracle Database Administration I Oracle Oracle-1z0-082 2-807650995 Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace? (Choose two.)
Select the answer
2 correct answers
A.
AUTOEXTEND is possible for the datafile
B.
It must be bigger than the largest SMALLFILE tablespace
C.
Additional data files may not be added
D.
It will be a dictionary-managed tablespace by default
E.
It will always have a 32K blocksize

Quiz

3/10
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
Select the answer
3 correct answers
A.
Connect Time Failover requires the use of Transparent Application Failover (TAF)
B.
Source Routing requires the use of a name server
C.
Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
D.
Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
E.
Load Balancing requires the use of a name server
F.
Connect Time Failover requires the connect string to have two or more listener addresses configured

Quiz

4/10
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
Select the answer
2 correct answers
A.
CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
B.
SYSDATE can be queried only from the DUAL table
C.
CURRENT_DATE returns the current date and time as per the session time zone
D.
SYSDATE can be used in expressions only if the default date format is DD-MON-RR
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

Quiz

5/10
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?
Select the answer
1 correct answer
A.
in the undo tablespace
B.
in the SYSAUX tablespace
C.
in the SGA
D.
in the PGA
E.
in the temporary tablespace

Quiz

6/10
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?
Select the answer
1 correct answer
A.
INTERVAL YEAR TO MONTH
B.
INTERVAL DAY TO SECOND
C.
TIMESTAMP WITH LOCAL TIMEZONE
D.
TIMESTAMP
E.
TIMESTAMP WITH TIMEZONE

Quiz

7/10
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: Certification Exam Oracle Database Administration I Oracle Oracle-1z0-082 3-3208235893 Which statement is true?
Select the answer
1 correct answer
A.
Dynamic service registration cannot be used for this database instance
B.
The LREG process registers services dynamically with the LISTENER_1 listener
C.
LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
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

Quiz

8/10
Which three statements are true concerning logical and physical database structures? (Choose three.)
Select the answer
3 correct answers
A.
All tablespaces may have one or more data files
B.
The extents of a segment must always reside in the same datafile
C.
A smallfile tablespace might be bigger than a bigfile tablespace
D.
A segment can span multiple data files in some tablespaces
E.
A segment’s blocks can be of different sizes
F.
A segment might have only one extent
G.
Segments can span multiple tablespaces

Quiz

9/10
Which two statements are true regarding a SAVEPOINT? (Choose two.)
Select the answer
2 correct answers
A.
Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
B.
Rolling back to a SAVEPOINT can undo a TRUNCATE statement
C.
Only one SAVEPOINT may be issued in a transaction
D.
A SAVEPOINT does not issue a COMMIT
E.
Rolling back to a SAVEPOINT can undo a DELETE statement

Quiz

10/10
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
Select the answer
3 correct answers
A.
writing inbound request to the common request queue from all shared server connections
B.
checking for outbound shared server responses on the common outbound response queue
C.
receiving inbound requests from processes using shared server connections
D.
sending each connection input request to the appropriate shared server input queue
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
Looking for more questions?Buy now

Oracle Database Administration I Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Oracle Database Administration I practice test! Further deepen your knowledge on Oracle Simulator; by unlocking the full version of our Oracle Database Administration I Simulator you will be able to take tests with over 142 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 142 questions.

BUY NOW

What to expect from our Oracle Database Administration I practice tests and how to prepare for any exam?

The Oracle Database Administration I Simulator Practice Tests are part of the Oracle Database and are the best way to prepare for any Oracle Database Administration I exam. The Oracle Database Administration I practice tests consist of 142 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Oracle Database Administration I database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Oracle Database Administration I Simulator will also give you an idea of the time it will take to complete each section of the Oracle Database Administration I practice test . It is important to note that the Oracle Database Administration I Simulator does not replace the classic Oracle Database Administration I study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Oracle Database Administration I exam.

BUY NOW

Oracle Database Administration I Practice test therefore represents an excellent tool to prepare for the actual exam together with our Oracle practice test . Our Oracle Database Administration I Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Oracle Database Administration I Simulator and how our unique Oracle Database Administration I Database made up of real questions:

Info quiz:

  • Quiz name:Oracle Database Administration I
  • Total number of questions:142
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Oracle Database Administration I exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Oracle Database Administration I Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Oracle Database Administration I Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Oracle Database Administration I practice tests which consist of 142 questions and also provide study material to pass the final Oracle Database Administration I exam with guaranteed success. Our Oracle Database Administration I database contain hundreds of questions and Oracle Tests related to Oracle Database Administration I Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW