Q123 You want to display details of all customers who reside in cities starting with the letter D
...
Thẻ: ocp
Q122 Which two actions can you perform using DBCA for an existing database?
...
Q121 The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully?
...
Q120 Which two statements are true about trace files produced by the Oracle Database server?
...
Q119 Which two statements are true about the DUAL table?
...
Q118 In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties
...
Q117 The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER
...
Q116 Examine the description of the PROMOTIONS table
...
Q115 Which two statements are true about space-saving features in an Oracle Database?
...
Q114 You want to write a query that prompts for two column names
...
Q113 Which two statements are true concerning logical and physical database structure
...
Q112 Which three statements are true concerning logical and physical database structures?
...
Q111 Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION?
...
Q110 Which three statements are true about the tools used to configure Oracle Net Services?
...
Q109 Which two statements are true about the tools used to configure Oracle Net Services
...
Q108 In one of your databases, you create a user, HR, and then execute this command
...
Q107 View the Exhibit and examine the description of the tables
...
Q106 In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1
...
Q105 You start your database instance in NOMOUNT state. Which two actions are performed?
...
Q104 Which statement is true about the INTERSECT operator used in compound queries?
...
Q103 Which two statements are true about date/time functions in a session
...
Q102 Which two statements are true about the BIG_TBS tablespace?
...
Q101 Which compression option is best suited for this?
...
Q100 Which three statements are true about Deferred Segment Creation in Oracle databases?
...
Q99 Which three files are used by conventional path SQL*Loader when the TABLE option is not specified?
...
