Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

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?

Control file
User trace files
Background trace files
Initialization parameter files

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which is a valid CREATE TABLE statement?

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));

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which four are types of functions available in SQL?

string
character
integer
numeric
date
conversion

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which object privileges can be granted on a VIEW?

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

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;

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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)

SER_NO
ORDER_ID
STATUS
PROD_ID
ORD_TOTAL
Composite index on ORDER_ID and ORDER_DATE

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

In which case would you use a FULL OUTER JOIN?

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

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
114
115
116
117
118
119
120
121
122
…
486
487
Next →