• databases Online Quiz - 46
Back
0

databases Online Quiz - 46

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

Which SQL statement is used to extract data from a database?

technology databases

  1. FETCH

  2. EXTRACT

  3. GET

  4. SELECT

Show answer
Correct Option: D

Which SQL statement is used to delete data from a database table?

technology databases

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. REMOVE

Show answer
Correct Option: B

What is a trigger

technology databases

  1. A piece of logic written in PL/SQL

  2. Executed at the arrival of a SQL*FORMS event

  3. Both A & B

  4. None of the above

Show answer
Correct Option: C

RENAME command is a :

technology databases

  1. DCL command

  2. TCL command

  3. DDL command

  4. DML command

Show answer
Correct Option: C

Data Dictionary:

technology databases

  1. Is a collection of tables created and maintained by oracle server.

  2. Contain user information.

  3. Contain database information.

  4. Both a and c

  5. All

Show answer
Correct Option: E

A DML statement is executed when you:
technology databases

  1. Modify existing rows in a table.

  2. Add a new column in a table

  3. Both a & b

  4. None

Show answer
Correct Option: A

Select the correct order of evaluation for following operators: I.LIKE II.NOT III.AND IV.OR
technology databases

  1. I,III,IV,II

  2. I,II,III,IV

  3. IV,III,II,I

  4. IV,II,I,III

Show answer
Correct Option: B

Which SQL keyword is used to sort the result set:

technology databases

  1. ORDER

  2. SORT

  3. ORDER BY

  4. GROUP BY

Show answer
Correct Option: C

What will be the correct order of the below mentioned clauses in a SQL if select part of the query contains on group function and there is one filter condition. I.Where II.GROUP BY III.HAVING IV.ORDER BY
technology databases

  1. I,III,II,IV

  2. I,II,III,IV

  3. II,IV,III,I

  4. II,I,IV,III

Show answer
Correct Option: B

You can not add data through a view if the view includes:

technology databases

  1. FROM

  2. Columns defined by expression

  3. WHERE

  4. Both b & c

Show answer
Correct Option: B

Fast Load can load the duplicate record in a multiset table.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the following property is true about FAST LOAD.

technology databases

  1. No more than 1 data type conversion is allowed per column during the Fastload

  2. If an AMP is down FL cannot be restarted untill that AMP is back online

  3. only load 1 empty table with one fast load job

  4. Fast load assembles data in 64K blocks and then loads it using mutltiple sessions

  5. Fast load supports triggers.

Show answer
Correct Option: A,B,C

Which of the following utility is designed to allow OLTP trasactions to immediately load in Datawarehouse?

technology databases

  1. Fast Load

  2. Multi Load

  3. Tpump

  4. Fast Export

Show answer
Correct Option: C

For Fast load script to be restartable which of the following should hold true?

technology databases

  1. Target table should not be created in the script

  2. target table should be created in the script

  3. Error tables should not be dropped in the script

  4. Checkpoint should be declared in the script

  5. Target table should not be dropped in the script

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

select the properties of TPUMP

technology databases

  1. It is possible to stipulate how many updates may occur per minute

  2. It is possible to have tpump running in the background all the time and just control its flow rate

  3. It can load upto 60 tables at a time if using a single source

  4. It can be stopped any time and all locks dropped or released with no ill consequences.

  5. it uses macro to run the SQL statements

  6. It has more error tollerance than FL and ML

Show answer
Correct Option: A,B,C,D,E

Sub-queries can be nested in
technology databases

  1. DELETE statements only

  2. UPDATE, DELETE, INSERT and SELECT statements

  3. UPDATE statements only

  4. INSERT statements only

Show answer
Correct Option: B

Which SQL statement inserts data into a table called Projects?

technology databases

  1. INSERT Projects VALUES ('Content Development', 'Website content development project')

  2. SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

  3. INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

  4. INSERT Projects ('Content Development', 'Website content development project')

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand the syntax for the SQL INSERT statement. The correct statement to insert data into a table called Projects is:

C. INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

Let's go through each option to understand why it is correct or incorrect:

Option A) INSERT Projects VALUES ('Content Development', 'Website content development project') - This option is incorrect because it is missing the "INTO" keyword. The correct syntax is "INSERT INTO".

Option B) SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project') - This option is incorrect because the keyword "SAVE" is not a valid keyword in SQL. The correct keyword is "INSERT INTO".

Option C) INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project') - This option is correct. It uses the correct syntax for the INSERT statement and specifies the column names (ProjectName, ProjectDescription) and their corresponding values.

Option D) INSERT Projects ('Content Development', 'Website content development project') - This option is incorrect because it is missing the "INTO" keyword. The correct syntax is "INSERT INTO".

The correct answer is C. This option is correct because it uses the correct syntax for the SQL INSERT statement and specifies the column names and their corresponding values.

If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default:

technology databases

  1. ASC

  2. DESC

  3. No Default value

  4. Returns error

Show answer
Correct Option: A

AI Explanation

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

Option A) ASC - This option is correct because if you don't specify ASC or DESC after a SQL ORDER BY clause, ASC (ascending) is used by default. This means that the result will be sorted in ascending order.

Option B) DESC - This option is incorrect because if you don't specify ASC or DESC after a SQL ORDER BY clause, DESC (descending) is not used by default. ASC is used instead.

Option C) No Default value - This option is incorrect because there is a default value used if you don't specify ASC or DESC. The default value is ASC.

Option D) Returns error - This option is incorrect because not specifying ASC or DESC after a SQL ORDER BY clause does not result in an error. It will default to ASC.

The correct answer is A) ASC. This option is correct because if you don't specify ASC or DESC after a SQL ORDER BY clause, ASC (ascending) is used by default.

Which of the following SQL statements is correct?
technology databases

  1. SELECT FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

  2. SELECT * FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

  3. SELECT FROM Sales WHERE Date BETWEEN ('10/12/2005', '01/01/2006')

  4. All the above

Show answer
Correct Option: B

Which of the following SQL clauses is used to sort a result set

technology databases

  1. Order By

  2. Sort

  3. Arrange

  4. All the above

Show answer
Correct Option: A
- 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