Databases - Upwork

Question: Which of the following statements is/are wrong?
A
Both Primary key and Unique key enforce uniqueness

B
Primary keys create a clustered index by default

C
Both Primary key and Unique key don't allow NULL values

D
Unique keys create a non-clustered index by default

E
It is possible to have more than one Primary key in a table

Note: Not available
1. Report
Question: Which of the following is a database object?
A
Tables

B
Stored Procedures

C
Indexes

D
UDF(User Defined Functions)

E
All of these

Note: Not available
1. Report
Question: Which of the following statements is correct?
A
Modifications made in a table will be faster if the number of indexes is more

B
Modifications made in a table will be slower if the number of indexes is more

C
The number of indexes does not affect the modification process of a table

Note: Not available
1. Report
Question: Evaluate the following SQL: CREATE USER sam IDENTIFIED BY sam; GRANT CREATE ANY MATERIALIZED VIEW, CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE TO dw_manager WITH ADMIN OPTION; GRANT dw_manager TO sam WITH ADMIN OPTION; Which three actions among the following is the user SAM able to perform?
A
Select from a table

B
Create and drop a materialized view

C
Alter a materialized view that was created

D
Grant and revoke the role to and from other users

E
Enable the role and exercise any privileges in the role's privilege domain

Note: Not available
1. Report
Question: A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?
A
BLOCKS

B
PCT_FREE

C
NEXT_EXTENT

D
PCT_INCREASE

Note: Not available
1. Report
Question: Which of the following is a new initialization parameter for Oracle Database 10g?
A
UNDO_SUPPRESS_ERRORS

B
PARALLEL_AUTOMATIC_TUNING

C
RESUMABLE_TIMEOUT

D
SHARED_SERVER

Note: Not available
1. Report
Question: Consider this SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?
A
The server process places the commit record in the redo log buffer

B
Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files

C
The user process notifies the server process that the transaction is complete

D
The user process notifies the server process that the resource locks can be released

Note: Not available
1. Report
Question: For what purpose is the initialization parameter UNDO_RETENTION used?
A
To specify the length of time Oracle must retain undo data in the undo tablespace

B
To specify the length of time Oracle must retain undo data in the flash recovery area

C
To specify the length of time Oracle must retain undo data in the data files

D
To specify the length of time Oracle will retain undo data in the flashback database logs

Note: Not available
1. Report
Question: Which of the following initialization parameters would belong to the basic group of parameters?
A
SHARED_POOL

B
CURSOR_SPACE_FOR_TIME

C
DB_NAME

D
CURSOR_SHARING

Note: Not available
1. Report
Question: An index on the PASSPORT_RECORDS table has to be created. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator.Which of the following index will be used for this criteria?
A
Bitmap

B
Unique

C
Partitioned

D
Reverse key

Note: Not available
1. Report

First Prev 66 67 68 69 70 Next Last

Question: Which of the following statements is/are wrong?

Question: Which of the following is a database object?

Question: Which of the following statements is correct?

Question: A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?

Question: Which of the following is a new initialization parameter for Oracle Database 10g?

Question: Consider this SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?

Question: For what purpose is the initialization parameter UNDO_RETENTION used?

Question: Which of the following initialization parameters would belong to the basic group of parameters?