• databases Online Quiz - 190
Back
0

databases Online Quiz - 190

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

Which SELECT statement will the result 'ello world' from the string 'Hello World'?

technology databases

  1. SELECT SUBSTR ('Hello',) FROM dual;

  2. SELECT INITCAP (TRIM ('Hello World',1,1) FROM dual;

  3. SELECT LOWER (SUBSTR ('Hello World',1,1) FROM dual

  4. SELECT LOWER (SUBSTR ('Hello World',2,1) FROM dual;

  5. SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

Show answer
Correct Option: E

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) SELECT SUBSTR ('Hello',) FROM dual; This option is incorrect because the SUBSTR function requires three arguments: the string, the starting position, and the length. In this case, the starting position and length are not provided.

Option B) SELECT INITCAP (TRIM ('Hello World',1,1) FROM dual; This option is incorrect because the TRIM function is used to remove specified characters from the beginning and/or end of a string. In this case, the starting position and length are not provided correctly.

Option C) SELECT LOWER (SUBSTR ('Hello World',1,1) FROM dual This option is incorrect because the SUBSTR function is used to extract a substring from a string. In this case, it is extracting the first character 'H' and converting it to lowercase using the LOWER function. It does not provide the desired result 'ello world'.

Option D) SELECT LOWER (SUBSTR ('Hello World',2,1) FROM dual; This option is incorrect because the SUBSTR function is used to extract a substring from a string. In this case, it is extracting the second character 'e' and converting it to lowercase using the LOWER function. It does not provide the desired result 'ello world'.

Option E) SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual; This option is correct because it uses the TRIM function to remove the letter 'H' from the string 'Hello World'. It then converts the remaining string 'ello world' to lowercase using the LOWER function. This provides the desired result 'ello world'.

The correct answer is Option E.

SELECT* FROM order; You use this statement to retrieve data from a data table for __________.
technology databases

  1. Updating

  2. Viewing

  3. Deleting

  4. Inserting

  5. Truncating

Show answer
Correct Option: B,D

Which four statements correctly describe functions that are available in SQL? (Choose four)
technology databases

  1. INSTR returns the numeric position of a named character.

  2. NVL2 returns the first non-null expression in the expression list.

  3. DECODE translates an expression after comparing it to each search value

  4. TRIM trims the heading of trailing characters (or both) from a character string

  5. NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal

  6. NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal

Show answer
Correct Option: A,C,D,F

Which two tasks can your perform by using the TO_CHAR function? (Choose two)

technology databases

  1. Convert 10 to 'TEN'

  2. Convert '10' to 10

  3. Convert '10' to '10'

  4. Convert 'TEN' to 10

  5. Convert a date to a character expression

  6. Convert a character expression to a date

Show answer
Correct Option: C,E

AI Explanation

To answer this question, let's go through each option to understand which tasks can be performed using the TO_CHAR function:

Option A) Convert 10 to 'TEN' - The TO_CHAR function is used to convert a value to a character expression. It is not used to convert a numeric value to a string representation, so this option is incorrect.

Option B) Convert '10' to 10 - The TO_CHAR function is not used to convert a string representation of a number to a numeric value. This option is incorrect.

Option C) Convert '10' to '10' - The TO_CHAR function is used to convert a value to a character expression. In this case, it can be used to convert the string '10' to the string '10'. This option is correct.

Option D) Convert 'TEN' to 10 - The TO_CHAR function is not used to convert a string representation of a number to a numeric value. This option is incorrect.

Option E) Convert a date to a character expression - The TO_CHAR function can be used to convert a date to a character expression. This option is correct.

Option F) Convert a character expression to a date - The TO_CHAR function is used to convert a value to a character expression, not to convert a character expression to a date. This option is incorrect.

The correct answers are: C) Convert '10' to '10', and E) Convert a date to a character expression.

Which two statements are true regarding the ORDER BY clause? (Choose two)
technology databases

  1. The sort is in ascending by order by default

  2. The sort is in descending order by default

  3. The ORDER BY clause must precede the WHERE clause

  4. The ORDER BY clause is executed on the client side

  5. The ORDER BY clause comes last in the SELECT statement

  6. The ORDER BY clause is executed first in the query execution

Show answer
Correct Option: A,E

The UPDATE SQL clause can…
technology databases

  1. update more than one row at a time.

  2. delete more than one row at a time.

  3. update only one row at a time.

  4. delete only one row at a time.

Show answer
Correct Option: A

Which are DML statements? (Choose all that apply)

technology databases

  1. COMMIT

  2. MERGE

  3. UPDATE

  4. DELETE

  5. CREATE

  6. DROP

Show answer
Correct Option: B,C,D

AI Explanation

To answer this question, we need to understand what DML (Data Manipulation Language) statements are. DML statements are used to modify and manipulate data within a database.

Let's go through each option to determine if it is a DML statement:

Option A) COMMIT - This statement is not a DML statement. COMMIT is used to permanently save any changes made within a transaction.

Option B) MERGE - This statement is a DML statement. MERGE is used to combine data from two tables based on a specified condition.

Option C) UPDATE - This statement is a DML statement. UPDATE is used to modify existing data in a table.

Option D) DELETE - This statement is a DML statement. DELETE is used to remove data from a table.

Option E) CREATE - This statement is not a DML statement. CREATE is used to create new database objects, such as tables, indexes, or views.

Option F) DROP - This statement is not a DML statement. DROP is used to remove existing database objects.

Therefore, the correct answers are options B, C, and D.

Which of the following SQL clauses specifies a search condition?

technology databases

  1. FROM

  2. SEARCH

  3. WHERE

  4. while

Show answer
Correct Option: C

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) FROM - This option is incorrect because the FROM clause is used to specify the table or tables from which data will be retrieved.

Option B) SEARCH - This option is incorrect because there is no such SQL clause called SEARCH.

Option C) WHERE - This option is correct because the WHERE clause is used to specify a search condition to filter the rows returned by a SELECT statement.

Option D) WHILE - This option is incorrect because the WHILE clause is not used for specifying a search condition in SQL. It is typically used in programming languages like SQL Server's T-SQL to implement loops.

The correct answer is C) WHERE. This option is correct because the WHERE clause is used to specify a search condition in SQL.

Which of the following is the most serious type of redo log file failure?
technology databases

  1. The loss of an entire redo log file group, but no loss in any other group

  2. The loss of one member of each redo log file group

  3. The failure of the ARC0 background process

  4. The failure of the LGWR background process

Show answer
Correct Option: A

When the database is in ARCHIVELOG mode, database recovery is possible up to which event or time?

technology databases

  1. The last redo log file switch

  2. The last checkpoint position

  3. The last commit

  4. The last incremental backup using RMAN

Show answer
Correct Option: C

Which of the following commands places the database in ARCHIVELOG mode?

technology databases

  1. ALTER SYSTEM ARCHIVELOG;

  2. ALTER DATABASE ARCHIVELOG;

  3. ALTER SYSTEM SET ARCHIVELOG=TRUE;

  4. ALTER DATABASE ENABLE ARCHIVELOG MODE;

  5. ALTER DATABASE ARCHIVELOG MODE;

Show answer
Correct Option: B

To place the database into ARCHIVELOG mode, in which state must you start the database?

technology databases

  1. MOUNT

  2. NOMOUNT

  3. OPEN

  4. SHUTDOWN

  5. Any of the above

Show answer
Correct Option: A

What is the biggest advantage of having the control files on different disks?

technology databases

  1. Database performance

  2. Guards against failure

  3. Faster archiving

  4. Writes are concurrent, so having control files on different disks speeds up control file writes

Show answer
Correct Option: B
Explanation:

To answer this question, the user needs to have basic knowledge of database architecture and file systems.

The biggest advantage of having control files on different disks is to guard against failure. Option B is the correct answer.

Explanation for each option:

A. Database performance: Although disk performance can impact database performance, having control files on different disks does not necessarily improve database performance.

B. Guards against failure: When control files are located on separate disks, it provides redundancy and a safeguard against disk failure. If one disk fails, the other disk can still provide the necessary control files for the database.

C. Faster archiving: Control files are not directly related to archiving. Having control files on different disks does not necessarily speed up archiving.

D. Writes are concurrent, so having control files on different disks speeds up control file writes: While it is true that having control files on different disks can speed up control file writes, this is not the biggest advantage of having control files on different disks. The biggest advantage is the redundancy and safeguard against disk failure.

Therefore, the correct answer is:

The Answer is: B. Guards against failure.

Which statement adds a member /logs/redo22.log to redo log file group 2?
technology databases

  1. ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’ TO GROUP 2;

  2. ALTER DATABASE ADD LOGFILE MEMBER ‘/logs/redo22.log’ TO GROUP 2;

  3. ALTER DATABASE ADD MEMBER ‘/logs/redo22.log’ TO GROUP 2;

  4. ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’;

Show answer
Correct Option: B

Which initialization parameter contains the value used as the default for archived log file destination 10?

technology databases

  1. LOG_ARCHIVE_DEST

  2. STANDBY_ARCHIVE_DEST

  3. LOG_ARCHIVE_DUPLEX_DEST

  4. DB_RECOVERY_FILE_DEST

  5. USE_DB_RECOVERY_FILE_DEST

Show answer
Correct Option: D

Which file records all changes made to the database and is used only when recovering an instance?

technology databases

  1. Archive log file

  2. Redo log file

  3. Control file

  4. Alert log file

Show answer
Correct Option: B

Which data dictionary view shows that the database is in ARCHIVELOG mode?

technology databases

  1. V$INSTANCE

  2. V$LOG

  3. V$DATABASE

  4. V$THREAD

Show answer
Correct Option: C

Following is not a part of SQL.

technology databases

  1. Commit

  2. Cursors

  3. savepoint

  4. truncate

Show answer
Correct Option: B

Which of the following will automatically order the result.

technology databases

  1. Union All

  2. Distinct

  3. Unique

  4. Intersect

Show answer
Correct Option: D

Which one will get higher priority

technology databases

  1. Union

  2. Intersect

  3. Minus

  4. None of above

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions