• databases Online Quiz - 35
Back
0

databases Online Quiz - 35

Description: databases Online Quiz - 35
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

What is a candidate key?

technology databases

  1. Used to uniquely identify a row

  2. Alias for primary key

  3. Used to identify a column

  4. Alias for foreign key

Show answer
Correct Option: A

Can I call a trigger directly called from an application?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

A view is nothing but a ________ table or a stored query

technology databases

  1. Dymanic

  2. Real

  3. Virtual

  4. Static

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to know about views in database management systems. A view is a virtual table that does not store any data but only displays data from one or more tables in the database.

Based on this information, the correct answer is:

The Answer is: C. Virtual

How can we get the number of records or rows in a table?

technology databases

  1. Using COUNT

  2. Using NUM

  3. Using NUMBER

  4. Both a and c above

Show answer
Correct Option: A

An outer join requires each record in the two joined tables to have a matching record.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

How do I find out all databases starting with ‘test to which I have access to?
technology databases

  1. SHOW DATABASES LIKE ‘%tech%’;

  2. SHOW DATABASES LIKE ‘%tech;

  3. SHOW DATABASES LIKE ‘'tech'%’;

  4. SHOW DATABASES LIKE ‘tech%’;

Show answer
Correct Option: D

Can I define multiple unique constraints on a table?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

When do we use a HAVING clause?
technology databases

  1. To limit the output of a query

  2. To limit the output of a query using an aggregate function only

  3. When GROUP by is used

  4. both b and c above

Show answer
Correct Option: B

USE keyword is used to select a ___________ .
technology databases

  1. Table

  2. Column

  3. Database

  4. All the above

Show answer
Correct Option: C

Enum values are stored accodring to their index numbers?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The execution plan of the SQL statement is stored in

technology databases

  1. A flat file called "plan_table.txt"

  2. Oracle Table called "plan_table"

  3. Oracle Table called "plan table"

  4. A flat file called "plan_table.tbl"

Show answer
Correct Option: B

What is TRUE about driving table?

technology databases

  1. It's advisable to choose the driving table with maximum number of records

  2. Number of records is NOT the criteria while selecting driving table

  3. It's advisable to choose the driving table with less number of records

  4. Driving table is always the last table accessed by the Optimizer

Show answer
Correct Option: C

Why one should NOT use expressions on the columns in the predicate?

technology databases

  1. Optimizer will return parse error if expressions are used on columns in the predicate

  2. Optimizer does not use index if expressions are used on the columns in the predicate, even if one exists

  3. It makes no difference with / without expressions on the columns in the predicate

  4. Using expressions on the columns in the predicate won't get benefits of using Table Alias

Show answer
Correct Option: B

What will be the output of- "Select 1 from dual UNION Select 'A' from dual"
technology databases

  1. 1,A

  2. A

  3. Error

  4. 1

Show answer
Correct Option: C

A table has the following data: [[5, Null, 10]].What will the average function return ?

technology databases

  1. Null

  2. 7.5

  3. 5

  4. 10

Show answer
Correct Option: B

If all the values from a cursor have been fetched and another fetch is issued,what the output will be?

technology databases

  1. Error

  2. Last record

  3. First record

  4. Can't be decided.

Show answer
Correct Option: B

How many rows will the following SQL return : "Select * from emp Where rownum = 10" ?

technology databases

  1. 10th row

  2. 1st row

  3. no rows returned

  4. First 10 rows

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to have basic knowledge of SQL and the concept of the rownum keyword in SQL.

The rownum keyword is used to assign a unique number to each row returned by a query in Oracle. It is often used to limit the number of rows returned by a query.

Now, let's go through each option and explain why it is right or wrong:

A. 10th row: This option is incorrect. The rownum keyword assigns a unique number to each row returned by a query. However, the where clause in the given SQL limits the result set to only the row where rownum equals 10. This means that the SQL query will only return one row, and that row will be the 10th row in the result set.

B. 1st row: This option is incorrect. The where clause in the given SQL limits the result set to only the row where rownum equals 10. This means that the SQL query will only return one row, and that row will be the 10th row in the result set.

C. no rows returned: This option is incorrect. The SQL query will return one row, which is the 10th row in the result set.

D. First 10 rows: This option is incorrect. The where clause in the given SQL limits the result set to only the row where rownum equals 10. This means that the SQL query will only return one row, and that row will be the 10th row in the result set.

The Answer is: C

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
technology databases

  1. System tablespace

  2. Default tablespace for the user

  3. Users tablespace

  4. Oracle will give an error

Show answer
Correct Option: B

Which of the following SQL functions can operate on any datatype?

technology databases

  1. TO_CHAR

  2. LOWER

  3. MAX

  4. CEIL

  5. LPAD

Show answer
Correct Option: C

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual?

technology databases

  1. 10-JUL-00

  2. 12-JUL-00

  3. 11-JUL-00

  4. 14-JUL-00

  5. 17-JUL-00

Show answer
Correct Option: E
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions