0

databases Online Quiz - 86

Description: databases Online Quiz - 86
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

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

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error


Correct Option: C

Which character is used to continue a statement in SQL*Plus?

  1. *

  2. /

  3. -

  4. @


Correct Option: C

AI Explanation

To answer this question, you need to understand how statements are executed in SQL*Plus.

In SQL*Plus, a statement can be continued onto the next line by using the hyphen ("-") character. This is known as a line continuation character.

Option A) * - This character is not used to continue a statement in SQL*Plus. Option B) / - This character is used to execute a statement in SQL*Plus, but it is not used to continue a statement onto the next line. Option C) - This character is the correct answer. It is used to continue a statement onto the next line in SQL*Plus. Option D) @ - This character is used to run a script or a file in SQL*Plus, but it is not used to continue a statement onto the next line.

The correct answer is Option C) -. This character is used to continue a statement in SQL*Plus.

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

  1. 5

  2. 4

  3. 3

  4. There is no such criteria


Correct Option: C
  1. INSERT INTO r4r_team (id, username, exp) VALUES (1, ‘r4r01’, ‘2’);

  2. INSERT INTO r4r_team VALUES (1, ‘r4r01’, ‘2’);

  3. INSERT INTO r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);

  4. INSERT INTO table r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);


Correct Option: A

Choose true option

  1. BETWEEN -->>Used for range with in values

  2. LIKE -->>Used for Search a pattern

  3. IN -->>return east one of the columns in given set of values

  4. 1,2,3


Correct Option: D

Truncate is faster than delete

  1. True

  2. False


Correct Option: A
  1. having

  2. group by

  3. where

  4. both 1 and 2


Correct Option: D

If base table does not exists, can we create a view?

  1. True

  2. False


Correct Option: A

If the base table of a view is deleted and we give SQL Select command on view table name

  1. Gives the columns referred in select statement of view

  2. Reports a error

  3. Select only particular columns of view table

  4. Outputs the whole view table


Correct Option: B

Which of the following data types are used in SQL?

  1. Long

  2. Date

  3. rowid

  4. all above


Correct Option: D

Which of the following SQL statement create a sequence SE with starting value as 30 and in increments of 20?

  1. GENERATE SEQUENCE SE START WITH 30 ADD BY 20;

  2. CREATE SEQUENCE SE START WITH 30 ADD BY 20;

  3. CREATE SEQUENCE SE START WITH 30 INCREMENT BY 20;

  4. GENERATE SEQUENCE SE INITIATE WITH 30 INCREMENT BY 20;


Correct Option: C

Which of the following is TRUE about Primary Key?

  1. Same value of Primary Key can appear in more than one row in the table

  2. A Primary key defined column can be of type LONG

  3. A column that is defined as Primary Key cannot contain NULL value

  4. Both A. and B.


Correct Option: C

Which of the following is not allowed while creating a table using CRRATE TABLE in SQL?

  1. Table name can be an oracle reserved word

  2. Table names must begin with a letter

  3. Table names can contain in it numbers also

  4. None of the Above


Correct Option: A

With SQL, how can you return the number of records in the "Persons" table?

  1. SELECT COLUMNS(*) FROM Persons

  2. SELECT COUNT() FROM Persons

  3. SELECT COUNT(*) FROM Persons

  4. SELECT COLUMNS() FROM Persons


Correct Option: C

Which SQL keyword is used to sort the result-set?

  1. order

  2. sort

  3. order by

  4. sort by


Correct Option: C

Which SQL statement is used to return only different values?

  1. SELECT DIFFERENT

  2. SELECT DISTINCT

  3. SELECT UNIQUE

  4. SELECT PRIMARY


Correct Option: B
  1. SELECT * FROM Persons WHERE FirstName LIKE '%a'

  2. SELECT * FROM Persons WHERE FirstName='a'

  3. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

  4. SELECT * FROM Persons WHERE FirstName='%a%'


Correct Option: C
- Hide questions