1.Which
three functions are performed by dispatchers in a shared server configuration?
(Choose three.)
• 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
2. As
the DBA, you execute this command:
GRANT
CREATE VIEW TO usr1 WITH ADMIN OPTION;
USR1
then executes this command:
GRANT
CREATE VIEW TO usr2 WITH ADMIN OPTION;
USR2
then executes this command:
GRANT
CREATE VIEW TO usr3;
Which
statement is true?
• When
USR1 revokes the CREATE VIEW Privilege from USR2, it is revoked from USR3.
• The DBA can revoke only ADMIN OPTION from USR1
• When
the DEA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2
but not USR3.
• When
the DBA revokes the CREATE VIEW Privilege from USR1, it is neither revoked from
USR2 nor USR.3.
• USRI
can revoke the CREATE VIEW privilege from USR3
• When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 and USR3.
3. Which three statements are true about multiple row subqueries?
• A. They can contain GROUP BY clauses.
• B. They can return multiple columns.
• C. Two or more values are always returned from the subquery.
• D. They can contain HAVING clauses. E. They cannot contain
a subquery.
4. Which three files are used by conventional path SQL*Loader when
the TABLE option is not specified? (Choose three.)
• A. dump files
• B. control files
• C. password files
• D. bad files
• E. input files
5. Which
two statements are true about segment types in an Oracle Database?
• Table
segments always have two or more extents. Index segments always have two or
more extents.
• Undo
segments are only stored in an undo tablespace.
• Temporary segments are only stored in a temporary tablespace.
• Cluster segments may contain data from multiple tables.
6. 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?
• A. WHERE borrowed_date = SYSDATE AND (transaction_type =
"˜RM' OR member_id IN ("˜A101', "˜A102'));
• B. WHERE (borrowed_date = SYSDATE AND transaction_type = "˜RM')
OR member_id IN ("˜A101', "˜A102');
• C. WHERE borrowed_date = SYSDATE AND (transaction_type =
"˜RM' AND
(member_id
= A101' OR member_id = "˜A102'));
D.
WHERE borrowed_date = SYSDATE AND transaction_type = "˜RM' OR member_id IN
("˜A101', "˜A102');
• E. WHERE borrowed_date = SYSDATE AND (transaction_type =
"˜RM' AND member_id = "˜A101' OR member_id = "˜A102'); 7.
Which two statements are true about Oracle
synonyms?
• A. A synonym can have a synonym.
• B. All private synonym names must be unique in the database.
• C. Any user can create a PUBLIC synonym.
• D. A synonym can be created on an object in a package. E. A synonym has an object number.
8. 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.
• A
view must only refer to tables in its defining query.
• Views can be updated without the need to re-grant privileges on the
view.
• Views
can be indexed.
9.
Which two statements
are true about INTERVAL data types?
• A. The YEAR field in an INTERVAL YEAR TO MONTH column must be a
positive value.
• B. INTERVAL DAY TO SECOND columns support fractions of seconds.
• C. INTERVAL YEAR TO MONTH columns only support monthly intervals
within a single year.
• D. INTERVAL YEAR TO MONTH columns support yearly intervals.
• E. INTERVAL YEAR TO MONTH columns only support monthly intervals
within a range of years.
• F. The value in an INTERVAL DAY TO SECOND column can be copied
into an INTERVAL YEAR TO MONTH column.
10.
What is true about
non-equijoin statement performance?
• A. The BETWEEN condition always performs less well than using
the >= and <= conditions.
• B. The join syntax used makes no difference to performance.
• C. Table aliases can improve performance.
D.
The BETWEEN condition always performs better than using the >= and <=
conditions.
• E. The Oracle join syntax performs better than the SQL:1999
compliant ANSI join syntax.
11.
Which two statements
are true about single-row functions? (Choose two.)
• A. CEIL: can be used for positive and negative numbers
• B. FLOOR: returns the smallest integer greater than or equal to
a specified number
• C. TRUNC: can be used with NUMBER and DATE values
• D. CONCAT: can be used to combine any number of values
• E. MOD: returns the quotient of a division operation
12.
Which three statements
are true about a self join? (Choose three.)
• A. The ON clause must be used
• B. The query must use two different aliases for the table
• C. It must be an equijoin
• D. It must be an inner join
• E. The ON clause can be used
• F. It can be an outer join
13.
Which two statements
are true about a self join?
• A. It can be a left outer join.
• B. It must be a full outer jolin.
• C. It can be an inner join.
• D. It must be an equijoin.
• E. The join key column must have an index.
14. Which
two statements are true about GLOBAL TEMPORARY TABLES?
• A GLOBAL TEMPORARY TABLE'S definition is available to multiple
sessions.
• GLOBAL
TEMPORARY TABLE space allocation occurs at session start.
• A
DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• 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.
15.
Which two statements
are true about the DUAL table? (Choose two.)
• A. It can be accessed only by the SYS user
B.
It consists of a single row and single column of VARCHAR2 data type
• C. It can display multiple rows but only a single column
• D. It can be used to display only constants or pseudo columns
• E. It can be accessed by any user who has the SELECT privilege in
any schema
• F. It can display multiple rows and columns
16. In one of your databases, you create a user, HR, and then
execute this command:
GRANT
CREATE SESSION TO hr WITH ADMIN OPTION;
Which
three actions can HR perform? (Choose three.)
• A. Revoke the CREATE SESSION privilege from other users
• B. Revoke the CREATE SESSION privilege from user HR
• C.
Log in to the database instance
• D. Grant the CREATE SESSION privilege with ADMIN OPTION to other
users
• E. Execute DDL statements in the HR schema F. Execute DML
statements in the HR schema
17. You
start your database instance in NOMOUNT state.
Which
two actions are performed?
• The
control files are opened.
• The
consistency of the database is checked.
• Memory is allocated for the sea.
• Sys
can access the database.
• All required background processes are started.
18.
Which three statements
are true about the DESCRIBE command? (Choose three.)
• A. It can be used to display the structure of an existing view
• B. It can be used only from SQL*Plus
• C. It displays the PRIMARY KEY constraint for any column or
columns that have that constraint
• D. It can be used from SQL Developer
• E. It displays all constraints that are defined for each column
• F. It displays the NOT NULL constraint for any columns that have
that constraint
.
19. Which
two are benefits of external tables?
• They can be queried, transformed, and joined with other tables
without having to load the data first.
• They support UPDATES which transparently updates records in the file
system as if they were table rows.
• The
results of a complex join or aggregating function or both can be unloaded to a
file for transportation to another database.
• They
support DELETES which transparently deletes records in the file system as if
they were table rows. They can be queried while the database is in the Mouse
state like dynamic performance views.
20. Examine the description of the EMPLOYEES table:
Which
query requires explicit data type conversion?
• A. SELECT join_date FROM employees WHERE join_date >
'10-02-2018';
• B. SELECT salary + "˜120.50' FROM employees;
• C. SELECT SUBSTR(join_date, 1, 2) "" 10 FROM
employees;
• D. SELECT join_date + "˜20' FROM employees; E. SELECT join_date || "˜ "˜ || salary FROM employees;
21. You execute this command:
During
the export operation, you detach from the job by using CTRL+C and then execute
this command:
Export>
STOP_JOB=immediate -
Are
you sure you wish to stop the job ([yes]/no): yes
Which
two statements are true about the job? (Choose two.)
• A. You can no longer monitor it
• B. You can reattach to it and monitor it
• C. It is paused and can be resumed
• D. It continues to run in the background
• E. It terminates
22. Which three are types of segments in an Oracle Database? (Choose
three.)
• A. undo
• B. index
• C. stored procedures
• D. sequences
• E. tables
• F. clusters
23. Examine the description of the PRODUCT_DETAILS table:
Which
two statements are true?
• A. PRODUCT_PRICE contains the value zero by default if no value
is assigned to it.
• B. PRODUCT_PRICE can be used in an arithmetic expression even if it
has no value stored in it.
• C. EXPIRY_DATE cannot be used in arithmetic expressions.
• D. PRODUCT_ID can be assigned the PRIMARY KEY constraint.
• E. EXPIRY_DATE contains the SYSDATE by default if no date is
assigned to it.
• F. PRODUCT_NAME cannot contain duplicate values
24. 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?
• A. Statement 1 returns only one row of output.
• B. Statement 2 returns only one row of output.
• C. Both statements will return NULL if either UNIT_PRICE or
QUANTITY contains NULL.
• D. Both the statements give the same output.
• E. Statement 2 may return multiple rows of output.
25. Which three statements are true about data block storage in an
Oracle Database?
A.
An index block can contain row data
B.A
data block header is of a fixed length
C.A
table block must always contain row data
D.A
block header contains a row directory pointing to all rows in the block. E.Row data is stored starting at the end of the
block
26. 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? (Choose two.)
• A. SELECT TO_CHAR(SYSDATE, "˜DD-MON-YYYY') ""
'01-JAN-2019' FROM DUAL;
• B. SELECT ROUND(SYSDATE "" '01-JAN-2019') FROM DUAL;
• C. SELECT ROUND(SYSDATE ""
TO_DATE("˜01/JANUARY/2019')) FROM DUAL; D. SELECT TO_DATE(SYSDATE, "˜DD/MONTH/YYYY') ""
"˜01/JANUARY/2019' FROM DUAL;
• E. SELECT SYSDATE "" TO_DATE('01-JANUARY-2019') FROM DUAL;
27. Which
two statements are true about undo segments and the use of undo by transactions
in an Oracle database instance?
• Undo
segments can be stored in the SYSAUX tablespace:
• Undo
segments can be stored in the SYSTEM tablespace.
• A
single transaction may use multiple undo segments simultaneously.
• Undo segments can extend when a transaction fills the last extent of
the undo segment.
• Undo segments can wrap around to the first extent when a transaction
fills the last extend of the undo segment.
28. Which
two queries execute successfully?
• SELECT
NULLIF (100, 100) FROM DUAL;
• SELECT COALESCE (100, NULL, 200) FROM DUAD;
• SELECT NULLIF (100, 'A') FROM DUAL;
• SELECT
NULLIF (NULL, 100) FROM DUAL;
• SELECT
COALESCE (100, 'A') FROM DUAL;
29. 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?
(Choose two.)
• A. WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'
• B. WHERE order_date > TO_DATE('JUL 10 2018', 'MON DD YYYY')
• C. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6), 'MON DD
YYYY')
• D. WHERE order_date > TO_DATE(ADD_MONTHS(SYSDATE,6), 'MON DD
YYYY')
• E. WHERE order_date IN (TO_DATE('OCT 21 2018', 'Mon DD YYYY'),
TO_CHAR('Nov 21 2018', 'Mon DD YYYY'))
30. Which three statements are true about inner and outer joins?
(Choose three.)
• A. A full outer join must use Oracle syntax
• B. An inner join returns matched rows
• C. A left or right outer join returns only unmatched rows
• D. A full outer join returns matched and unmatched rows
• E. Outer joins can only be used between two per query
• F. Outer joins can be used when there are multiple join conditions
on two tables
31.Which
two statements are true about UNDO and UNDO tablespaces? A) UNDO segments are
owned by SYSBACKUP.
B) There
can be only one UNDO tablespace created in a database.
C) An instance will crash if the active undo tablespace is lost.
D) UNDO
segments are owned by SYSTEL.
E) An UNDO tablespace may be owned by only one instance.
32. Which
compression method is recommended for Direct-Path Insert operations?
• COLUMN
STORE COMPRESS ADVANCED
• ROW
STORE COMPRESS BASIC
• COLUMN
STORE COMPRESS BASIC
• ROW STORE COMPRESS ADVANCED
33. Which
three statements are true regarding single row subqueries?
• They
must be placed on the left side of the comparison operator or condition.
• They
can be used in the HAVING clause.
• They can be used in the WHERE clause.
• They must return a row to prevent errors in the SQL statement.
• A
SQL statement may have multiple single row subquery blocks.
• They must be placed on the right side of the comparison operator or
condition.
34. Examine the description of the SALES1 table:
SALES2
is a table with the same description as SALES1.
Some
sales data is duplicated in both tables.
You
want to display the rows from the SALES1 table which are not present in the
SALES2 table. Which set operator generates the required output?
• A. SUBTRACT
• B. INTERSECT C. UNION ALL D. UNION
• E. MINUS
35. 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 SELECE of the compound query. the first column in the first SELECT of the compound query.
• the
first column in the last SELECT of the compound query
• the
first NUMBER or VARCHAR2 column in the last SELECT of the compound query
• the
first VARCHAR2 column in the first SELECT of the compound query
36. Which
two statements are true about User Authentication in an Oracle Database?
• REMOTE_LOGIN_PASSWORDFIDE must be set to exclusive to permit
password changes for system privileged administrative users.
• Password File authentication must be used for system-privileged
administrative users.
• Password
authentication must be used for system-privileged administrative users.
• Password
File authentication is supported for any type of database user.
• Operating
System authentication may be used for system privileged administrative users.
37. Which three statements are true about Deferred Segment Creation
in Oracle databases? A.It is the default
behavior for tables and indexes.
B.It
is supported for sys-owned tables contained in locally managed tablespaces
C.Sessions
may dynamically switch back and forth from DEFERRED to IMMEDIATE segment
creation.
D.Indexes
inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent
table
E.It
is supported for Index Organized Tables(IOTs) contained in locally managed
tablespaces.
38. Which two statements are true about the PMON background process?
(Choose two.)
• A. It registers database services with all local and remote
listeners known to the database instance
• B. It frees resources held by abnormally terminated processes
• C. It records checkpoint information in the control file
• D. It frees unused temporary segments E. It kills sessions that
exceed idle time
39. Examine the description of the SALES table:
The
SALES table has 55,000 rows.
Examine
this statement:
Which
two statements are true?
• A. SALES1 has NOT NULL constraints on any selected columns which had
those constraints in the SALES table.
• B. SALES1 is created with 55,000 rows.
• C. SALES1 has PRIMARY KEY and UNIQUE constraints on any selected
columns which had those constraints in the SALES table.
• D. SALES1 is created with no rows. E.
SALES1 is created with 1 row.
40. Which two statements are true about the SET VERIFY ON command?
(Choose two.)
• A. It can be used only in SQL*Plus
• B. It displays values for variables used only in the WHERE
clause of a query
• C. It can be used in SQL Developer and SQL*Plus
• D. It displays values for variables created by the DEFINE
command
• E. It displays values for variables prefixed with &&
41. Which two statements are true about the configuration and use of
UNDO RETENTION with no GUARANTEED RETENTION?
A.Unexpired
UNDO is always retained
B.UNDO
RETENTION specifies for how long Oracle attempts to keep unexpired UNDO C.UNDO_RETENTION
specifies for how long Oracle attempts to keep expired and unexpired UNDO.
D.UNDO
RETENTION specifies how long all types of UNDO are retained E.Active UNDO is always retained
42. Which
three statements are true about using SQL*Plus?
• It
can run scripts passed to it by a shell script.
• It can run scripts entered at the SQL prompt.
• It
must be downloaded from the Oracle Technology Network (OTN).
• It
can run Recovery Manager (RMAN) commands.
• It has both command-line and graphical user interfaces (GUI), It has its own commands that are separate from any SQL statements.
43. Examine this command
SQL>
ALTER TABLE ORDERS SHRINK SPACE COMPACT
Which
two statements are true?
A.Queries
and DML statements are allowed on ORDERs while the SHRINK is executing
B.Dependent
indexes become UNUSABLE
C.The
SHRINK operation causes rows to be moved to empty space starting toward the end
of the
ORDERs
segment
D.The
SHRINK operation causes rows to be moved to empty space starting from the
beginning of the ORDERs segment.
E.Only
queries are allowed on ORDERs while the SHRINK is executing
F.The
high-water mark(HWM)of ORDERs is adjusted
44. Which two tasks can you perform using DBCA for databases?
(Choose two.)
• A. Configure a nonstandard block size for a new database
• B. Register a new database with an available Enterprise Manager
Management server
• C. Change the standard block size of an existing database
• D. Configure incremental backups for a new database
• E. Enable flashback database for an existing database
45.
You must create a
tablespace of non-standard block size in a new file 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?
A.DB_32K_CACHE_SIZE
must be set to a value that can be accommodated in the SGA
B.DB_32K_CACHE_SIZE
should be set to a value greater than DB_CACHE_SIZE
C.DB_32K_CACHE_SIZE
must be less than DB_CACHE_SIZE
D.The
operating system must use a 32k block size
E.DB_CACHE_SIZE
must be set to a size that is smaller than DB_32K_CACHE_SIZE F. The /u02 file system must have at least 100g space for the
datafile
46.
Which two are true
about a SQL statement using SET operators such as UNION?
• A. The number, but not names, of columns must be identical for all
SELECT statements in the query.
• B. 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.
• C. The data type group of each column returned by the second query
must match the data type group of the corresponding column returned by the
first query.
• D. The names and number of columns must be identical for all
SELECT statements in the query.
• E. 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.
47. Which
two Oracle database space management features require the use of locally
managed tablespaces?
• Server-generated
tablespace space alerts
• Free
space management with bitmaps
• Automatic data file extension (AUTOEXTEND)
• Online
segment shrink
• Oracle Managed Files (OMf)
48.
Answer
A
49.
Answer
A and C
50. 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
first row and Aus for the second?
• A. SELECT REPLACE (TRIM(TRAILING "˜son' FROM
cust_last_name), "˜An', "˜O') FROM customers; B. SELECT INITCAP (REPLACE(TRIM("˜son' FROM
cust_last_name), "˜An', "˜O')) FROM customers;
• C. SELECT REPLACE (SUBSTR(cust_last_name, -3), "˜An',
"˜O') FROM customers; D. SELECT REPLACE (REPLACE(cust_last_name, "˜son', "˜'),
"˜An', "˜O') FROM customers;
51. Which
two statements are true regarding indexes?
• The
RECYCLE BIN never contains indexes.
• A table belonging to one user cannot have an index that belongs to a
different user.
• An update to a table can result in no updates to any of the
table's indexes An update to a table can result in updates to any or all of the
table's indexes. A
non-unique index can be altered to be unique.
52.
Which two statements
are true about Enterprise Manager (EM) Express?
• A. You can use a single instance of EM Express to manage
multiple database running on the same server.
• B. EM Express uses a separate repository database to store
target database metadata. C. By default, EM express
is available for a database after database creation using
DBCA.
• D. You can shut down a database instance using EM Express.
• E. You cannot start up a database instance using EM Express
53.
Which two statements
are true about UNDO and REDO? (Choose two.)
• A. The generation of UNDO generates REDO
• B. DML modifies Oracle database objects and only generates UNDO
• C. The generation of REDO generates UNDO
• D. DML modifies Oracle database objects and only generates REDO
• E. DML modifies Oracle database objects and generates UNDO and REDO
54. 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 that can be done using the DBMS_PRIVILEGE_CAPTURE package?
• analysis
of all privileges used by the sys user.
• analysis
of privileges that a user has on other schema's objects
• analysis of privileges granted directly to a role that are then used
by a user who has been granted that role
• Lanalysis of privileges granted indirectly to a role that are then
used by a user who has been granted that role
• analysis
of privileges that a user has on their own schema objects
55. 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 a
query?
• A. PROMO_BEGIN_DATE "" 5 will return a date.
• B. PROMO_BEGIN_DATE "" SYSDATE will return a number.
• C. TO_NUMBER(PROMO_BEGIN_DATE) "" 5 will return a
number. D. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.
• E. PROMO_BEGIN_DATE "" SYSDATE will return an error
56. Your database instance is started with an SPFILE.
A
PEILE is also available.
You execute this command:
ALTER
SYSTEM SET DB_CACHE_SIZE=100K;
Where is the value changed?
• only
in memory
• in
the SPFILE and FFILE
• only
in the SPEILE
• in
the SPEIDE and in memory
• in the SPFILE, PEILE, and memory
57. 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?
A.
B.
C.
D.
E.
F.
Answer
B and C
58.
Which two statements
are true about substitution variables? (Choose two.)
• A. A substitution variable can be used with any clause in a SELECT
statement
• B. A substitution variable used to prompt for a column name must
be enclosed in a single quotation marks
• C. A substitution variable prefixed with & always prompts
only once for a value in a session
• D. A substitution variable can be used only in a SELECT
statement
• E. A substitution variable used to prompt for a column name must
be enclosed in double quotation marks
• F. A substitution variable prefixed with && prompts only
once for a value in a session unless it is set to undefined in the session
59. 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. 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 registratio
60. 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:
What
will be the result?
• A. It gives an error because the ALL keyword is not valid
• 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 executes successfully and gives the required resul
61. 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. Specify a path in the DATAFILE clause of the command specifying a
location with at least 100M of available space.
• C. Ensure that DB_CREATE_FILE_DEST specifies a location with at
least 100 Mb of available space.
• D. Add the AUTOEXTEND ON clause with NEXT set to 100M.
• E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST
each specify locations with at least 50 Mb of available space.
62. Which
two statements are true about the Oracle join and ANSI join syntax?
• The
Oracle join syntax lacks the ability to do outer joins.
• The
Oracle join syntax performs better than the SQL:1999 compliant ANSI join
syntax.
• The
Oracle join syntax performs less well than the so:1999 compliant ANSI join
syntax.
• 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
63. Examine these statements executed in a single
Oracle session:
Which three statements are true?
• A. The code for pen is 1.
• B. There is no row containing pencil.
• C. The code for fountain pen is 3.
• D. The code for pen is 10.
• E. There is no row containing fountain pen. F. There is no row containing pen.
64. Which
two statements are true about the Oracle Data Dictionary?
• All
data dictionary view join base tables to dynamic performance views.
• It is owned by the SYS user.
• Data dictionary base tables can be queried directly.
• Data
dictionary views are always created with queries that join two or more base
tables. It
is owned by the SYSTEM USER.
65. 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" FROM transactions;
• B. SELECT customer_id AS "CUSTOMER-ID", transaction_date
AS "DATE", amount + 100 DUES FROM transactions;
• C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS
TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;
• D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount +
100 DUES FROM transactions;
• E. SELECT customer_id AS "˜CUSTOMER-ID', transaction_date
AS DATE, amount +
100 "˜DUES AMOUNT' FROM transactions;
66. Which
statement is true about database links?
• A
public database link can be created only by sys
• 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 database link can be created only between two Oracle databases.
• Private
database link creation requires the same user to exist in both the local and
the remote databases.
67. Which three statements are true about sequences in a single
instance Oracle database? (Choose three.)
• A. A sequence can issue duplicate values
• B. A sequence's unallocated cached value are lost if the instance
shuts down
• C. Sequences can always have gaps
• D. Two or more tables cannot have keys generated from the same
sequence
• E. A sequence can only be dropped by a DBA
• F. A sequence number that was allocated can be rolled back if a
transaction fails
68. Which three statements are true about the naming methods and
their features supported by Oracle database used to resolve connection
information?
A.Directory
Naming can be used if Connect-Time Failover is required
B.Local
Naming requires setting the TNS_ADMIN environment variable on the client side
C.Local
naming can be used if Connect-Time Failover is required
D.Directory
Naming requires setting the TNS_ADMIN environment variable on the client side E.A client can connect to an Oracle database instance even if no
client side network admin has been configure
F.Easy
Connect supports TCP/IP and SSL
69. 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:
Which two WHERE conditions give the required
result?
A.
B.
C.
D.
E.
Answer
A and D
70.
The SALES table has
columns PROD_ID and QUANTITY_SOLD of data type NUMBER. Which two queries
execute successfully?
• A. SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY
prod_id HAVING COUNT(*) >10;
• B. SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND
COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) >10;
• C. SELECT COUNT (prod_id) FROM sales WHERE quantity_sold > 55000
GROUP BY prod_id;
• D. SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND
COUNT(*) > 10 GROUP BY COUNT(*) >10;
• E. SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE
quantity_sold > 55000;
71. Which three statements are true about connection strings and
service names used to connect to an Oracle database instance?
A.A
connection string must include the SID of a database instance.
B.A
single connection string can refer to multiple database instances
C.A
connection string including a service name must be defined in the tnsnames.ora
file
D.A
service name is created by a listener
E.Different
connection strings in the same tnsnames. ora file can contain the same service
name host and port parameters
F.
A single database instance can support connections for multiple service names answer ：BEF.
72.Which three statements are true about the Automatic Diagnostic Repository (ADR)?
A.It
is a file-based repository held outside any database
B.The
ADR base is specified in the DIAGNOSTIC DEST database parameter
C.It
is only used for Oracle Database diagnostic information
D.It
is held inside an Oracle database schema
E.It can be used for problem diagnosis of a database when that database’s instance is down Updated Questions:
1.
Which two statements are true about single row functions? A) MOD : returns the remainder of a division operation.
B)
CONCAT : can be used
to combine any number of values.
C)
TRUNC : can be used
only with NUMBER data types.
D)
FLOOR: returns the
smallest integer greater than or equal to a specified number.
E)
CEIL : can be used for
positive and negative numbers.
Answer:AE
2.The
EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of
data type DATE.
You
want to display the date of the first Monday after the completion of six months
since hiring.
The
NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday
is the first day on the week.
Which
query can be used?
A.
SELECT emp_id,
ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;
B.
SELECT emp_id,
NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;
C.
SELECT emp_id,
NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
D.
SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM
employees
3.Which
two statements are true regarding the count function?
A.
The count function can
be used only for CHAR, VARCHAR2, and NUMBER data types.
B.
Count (*) returns the
number of rows including duplicate rows and rows containing null value in any
of the colu2.mns.
C.
Count (cust_id)
returns the number of rows including rows with duplicate customer IDs and NULL
value in the CUST_ID column.
D.
Count (distinct inv_amt)
returns the number of rows excluding rows containing duplicates and NULL values
in the INV_AMT column.
E.
A select statement
using the COUNT function with a DISTINCT keyword cannot have a where clause.
Website không bao giờ chứa bất kỳ quảng cáo nào, mọi đóng góp để duy trì phát triển cho website (donation) xin vui lòng gửi về STK 90.2142.8888 - Ngân hàng Vietcombank Thăng Long - TRAN VAN BINH
=============================
Nếu bạn muốn tiết kiệm 3-5 NĂM trên con đường trở thành DBA chuyên nghiệp thì hãy đăng ký ngay KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE, được Coaching trực tiếp từ tôi với toàn bộ kinh nghiệm, thủ tục, quy trình, bí kíp thực chiến mà bạn sẽ KHÔNG THỂ tìm kiếm trên Internet/Google giúp bạn dễ dàng quản trị mọi hệ thống Core tại Việt Nam và trên thế giới, đỗ OCP.
- CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
- Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
2 khóa học online qua video giúp bạn nhanh chóng có những kiến thức nền tảng về Linux, Oracle, học mọi nơi, chỉ cần có Internet/4G:
- Oracle cơ bản: https://bit.ly/admin1_1200
- Linux: https://bit.ly/linux_1200
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile/Zalo: 0902912888
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: https://www.youtube.com/@binhguru
👨 Tiktok: https://www.tiktok.com/@binhguru
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhguru
👨 Podcast: https://www.podbean.com/pu/pbblog-eskre-5f82d6
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội
=============================
oracle tutorial, học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,sql tutorial, khóa học pl/sql tutorial, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail,oracle RAC, ASM, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle oca, oracle ocp, oracle ocm , oracle weblogic, postgresql tutorial, mysql tutorial, mariadb tutorial, ms sql server tutorial, nosql, mongodb tutorial, oci, cloud, middleware tutorial, hoc solaris tutorial, hoc linux tutorial, hoc aix tutorial, unix tutorial, securecrt, xshell, mobaxterm, putty
