Question 1

Which constraint can be defined only at column level?

technology databases

unique
not null
check
primary key

Answer

Correct Option: B

Question 2

Which SELECT statement will get the result 'elloworld' from the string 'HelloWorld'?

technology databases

SELECT SUBSTR ('HelloWorld',1) FROM dual;
SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual
SELECT LOWER (SUBSTR('HellowWorld', 2,1) FROM dual
SELECT INITCAP(TRIM('HellowWorld', 1,1) FROM dual

Answer

Correct Option: B

Question 3

Which substitution variable would you use if you want to reuse the variable without prompting the user each time

technology databases

&
accept
prompt
&&

Answer

Correct Option: D

Question 4

CREATE USER sh IDENTIFIED BY sh; 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 sh WITH ADMIN OPTION; Which action the user SH cannot perform?

technology databases

Create and drop a materialized view
Grant and revoke the role to and from other users
Enable the role and exercise any privileges in the role's privilege domain
Select from a table

Answer

Correct Option: D

Question 5

Which type of index does this syntax create? CREATE INDEX hr.employees_last_name_idx ON hr.employees(last_name) PCTFREE 30 STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 0 MAXEXTENTS 50) TABLESPACE indx;

technology databases

Bitmap
B-Tree
Partitioned
Reverse key

Answer

Correct Option: B

Question 6

You need to create an index on the PASSPORT_RECORDS table. 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 type of index would be best for this type of table?

technology databases

Bitmap
Btree
Unique
partitioned

Answer

Correct Option: A

Question 7

Which statement about the shared pool is true?

technology databases

The shared pool CANNOT be dynamically resized.
The shared pool contains only fixed structures
The shared pool consists of the library cache and buffer cache.
The shared pool stores the most recently executed SQL statements and the most recently

Answer

Correct Option: D

Question 8

Which action will cause a log switch?

technology databases

A transaction completes.
The instance is started.
The instance is shut down
The current online redo log group is filled

Answer

Correct Option: D

Question 9

You examine the alert log file and notice that errors are being generated from a SQL*Plus session. Which files are best for providing you with more information about the nature of the problem?

technology databases

Control file
User trace files
Background trace files
Initialization parameter files

Answer

Correct Option: B

Question 10

Which is a valid CREATE TABLE statement?

technology databases

CREATE TABLE EMP9$# AS (empid number(2));
CREATE TABLE EMP*123 AS (empid number(2));
CREATE TABLE PACKAGE AS (packid number(2));
CREATE TABLE 1EMP_TEST AS (empid number(2));

Answer

Correct Option: C

Question 11

A SELECT statement can be to perform these three functions: -Choose rows from a table -Choose columns from a table -Bring together data that is stored in different tables by creating a link between them. Which set of keywords describe these capabilities?

technology databases

difference,projection,join
selection.projection,join
selection,intersection,join
intersection,projection,join
difference,projection,product

Answer

Correct Option: B

Question 12

Which four are types of functions available in SQL?

technology databases

string
character
integer
numeric
date
conversion

Answer

Correct Option: B,D,E,F

Question 13

Which object privileges can be granted on a VIEW?

technology databases

DELETE,INSERT,SELECT
ALTER,DELETE,INSERT,SELECT
DELETE,INSERT,SELECT,UPDATE
none

Answer

Correct Option: C

Question 14

Which iSQL*PLUS feature can be used to replace values in the WHERE clause?

technology databases

Substitution variables
Replacement variables
Prompt variables
Instead-of variables
This feature cannot be implemented through iSQL*PLUS

Answer

Correct Option: A

Question 15

You want to display the titles of books that meet these criteria: 1. Purchased before January 21,2001 2. Price is less than $500 and greater than $900 You want to sort the results by thier date of purchase, starting with the most recently bought book. Which statement should you use?

technology databases

SELECT book_title FROM books WHERE price between 500 and 900 AND puchase_date < '21-JAN-2001' ORDER BY purchase_date;
SELECT book_title FROM books WHERE price IN (500,900) AND puchase_date < '21-JAN-2001' ORDER BY purchase_date ASC;
SELECT book_title FROM books WHERE price <500 or >900 AND puchase_date < '21-JAN-2001' ORDER BY purchase_date DESC;
SELECT book_title FROM books WHERE (price<500 OR price>900) AND puchase_date < '21-JAN-2001' ORDER BY purchase_date DESC;

Answer

Correct Option: D

Question 16

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN('CREDIT','CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id,order_date)); For which column would an index be automatically created when you execute the above SQL statement?(Choose two)

technology databases

SER_NO
ORDER_ID
STATUS
PROD_ID
ORD_TOTAL
Composite index on ORDER_ID and ORDER_DATE

Answer

Correct Option: A,F

Question 17

In a SELECT statement that includes a WHERE clause, where is teh GROUP BY clause placed in the SELECT statement?

technology databases

Immediately after the SELECT clause
Before the WHERE clause
Before the FROM clause
After the ORDER BY clause
After the WHERE clause

Answer

Correct Option: E

Question 18

In which case would you use a FULL OUTER JOIN?

technology databases

Both tables have NULL values
You want all unmatched data from one table
You want all matched data from both tables
You want all unmatched data from both tables
One of the tables has more data than the other
You want all matched and unmatched data from only one table

Answer

Correct Option: D

Question 19

Which two statements accurately describes a role?(Choose two)

technology databases

A role can be given to a maximum of 1000 users
A user can have access to a maximum of 10 roles
A role can have a maximum of 100 privileges contained in it
Privileges are given to a role by using the CREATE ROLE statement
A role is a named group of related privileges that can be granted to the user
A user can have access to several roles, and several users can be assigned to the same role

Answer

Correct Option: D,F

Question 20

what are the three main components in Hibernate architecture?

technology databases

Connection Management
Bean Management
Transaction Management
Object relational mapping
Relational Management

Answer

Correct Option: A,C,D

Description: databases Online Quiz - 185
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 185

Find more quizzes from top tags