Tag: databases

Questions Related to databases

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

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