databases Online Quiz - 72 Online Test

0

databases Online Quiz - 72

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

Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL 1 Paul Jones DBA 2 2 George Baker MGR 1 3 Roger Melvin CLERK 3 4 Jim Smith MGR 1 5 Kevin Street CLERK 3 6 Chris Eaton MGR 1 If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1

technology databases

0
1
3
6

Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?

technology databases

INSERT INTO tab1 SELECT cx, cy FROM tab2
INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)

Given the following table and XML data stored in the CONTACTINFO column: CREATE TABLE clients( id INT PRIMARY KEY NOT NULL, name VARCHAR(50), status VARCHAR(10), contactinfo XML ) 25 EastCreek Toronto OntarioM8X-3T6 4165551358 9051112222 9051112222 by fax What is the result of the following XQuery expression? for $y in db2-fn:xmlcolumn('CLIENTS.CONTACTINFO')/Client//fax return $y

technology databases

4165551358
9051112222
No results because there is no child element
No results because the XQuery expression is not a valid FLWOR expression

Given the following query: SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40 Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?

technology databases

SORT BY age ASC, last_name
SORT BY age DESC, last_name
ORDER BY age DESC, last_name
ORDER BY age ASC, last_name

Given the table, Customer contain the following data Customer Table: Product-ID Quantity 1 5 2 3 3 4 The following sequence of statement performed at the single unit of work: UPDATE Customer SET Quantity = 3 WHERE Product-ID = 1; SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE Customer SET Quantity = 5 WHERE Product-ID = 3; INSERT INTO Customer VALUES (5, 20); SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS; INSERT INTO Customer VALUES (4, 10); ROLLBACK TO SAVEPOINT s1; INSERT INTO Customer VALUES (6, 10); INSERT INTO Customer VALUES (7, 15); COMMIT;

technology databases

1-5, 2-3, 3-5, 4-10, 5-20, 6-10, 7-15
1-3, 2-3, 3-4, 6-10, 7-15
1-3, 2-3, 3-4, 4-10, 5-20, 6-10, 7-15
1-3, 2-3, 3-4

Given the following table and XML data stored in the EMPDETAILS column: CREATE TABLE employees (Emp-id INT PRIMARY KEY NOT NULL, Emp-name VARCHAR (20), Empdetails XML) The data in the EMPDETAILS are ProjectManager Chennai 987654 What is the result of the following XQuery Expression? For $y in db2-fn:xmlcolumn(EMPLOYEES. EMPDETAILS’)/Employee/designation return $y

technology databases

ProjectManager
ProjectManager
chennai
987654

In which situation is shredding XML data recommended?

technology databases

When the data is naturally tabular
When the number of nodes are volatile
When the data by nature has sparse attributes
When the data is of low volume and requires a complex star-schema topology

Which of the following supports the XML data type?

technology databases

A unique index
.A composite index
A check constraint
.A generated column

Review the following SQL, and choose the most appropriate option.

technology databases

The statement will show the number of jobs in each department
The statement will show the number of employees in each department.
The statement will generate an error.
The statement will work if the GROUP BY clause is removed.

Which datatype stores data outside Oracle Database?

technology databases

UROWID
BFILE
BLOB
NCLOB

The DEPT table has the following data

technology databases

The INSERT statement is invalid; a valid table name is missing.
50 is not a valid DEPTNO value, since the subquery limits DEPTNO to 10.
The statement will work without error.
A subquery and a VALUES clause cannot appear together.

The following statements are executed: create sequence my_seq; select my_seq.nextval from dual; select my_seq.nextval from dual; rollback; select my_seq.nextval from dual;

technology databases

0
1
2
3

The current time in Dubai is 04-APR-2008 08:50:00, and the time in Dallas is 03-APR-2008 23:50:00. A user from Dubai is connected to a session in the database located on a server in Dallas. What will be the result of his query?

technology databases

04?APR?2008 08:50:00
03?APR?2008 23:50:00
03?APR?2008 2324:50:00
None of the above

I/O operations on the data warehouse is expensive ?

technology databases

True
False

SYS_CONTEXT can be used to know details about a session running the code?

technology databases

True
False

Which are appropriate scheduling tools for use in EIP database?

technology databases

CONTROL M
DBMS_JOB
DBMS_SCHEDULER
All

What can be used to optimize the performance of simple SQL?

technology databases

DYNAMIC PARALLELISM
HINTS
STORED OUTLINES
ALL

COMPLETE REFRESH by default will _________________all rows in an mview before inserting new rows

technology databases

Create
Delete
Append
Do Nothing

If the number of leaf blocks of index , scanned is less than 5000 then degree of parallelismis 2?

technology databases

True
False

In which version release of Oracle the UTL_FILE package was released?

technology databases

7.2
7.3.6
7.3.4
7.3.1
None of the above

- Hide questions