• databases Online Quiz - 13
Back
0

databases Online Quiz - 13

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

With SQL, how can you insert a new record into the "Persons" table?

technology databases

  1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

  2. INSERT ('Jimmy', 'Jackson') INTO Persons

  3. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

  4. INSERT ('Jimmy', 'Jackson') INTO Persons

Show answer
Correct Option: A

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
technology databases

  1. INSERT ('Olsen') INTO Persons (LastName)

  2. INSERT INTO Persons (LastName) VALUES ('Olsen')

  3. INSERT INTO Persons ('Olsen') INTO LastName

  4. INSERT FROM Persons ('Olsen') INTO LastName

Show answer
Correct Option: B

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

technology databases

  1. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

  2. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

  3. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

  4. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Show answer
Correct Option: B

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

technology databases

  1. DELETE FROM Persons WHERE FirstName = 'Peter'

  2. DELETE FirstName='Peter' FROM Persons

  3. DELETE ROW FirstName='Peter' FROM Persons

  4. DELETE FROM Persons WHERE FirstName <> 'Peter'

Show answer
Correct Option: A

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

technology databases

  1. SELECT COUNT() FROM Persons

  2. SELECT COLUMNS() FROM Persons

  3. SELECT COLUMNS(*) FROM Persons

  4. SELECT COUNT(*) FROM Persons

Show answer
Correct Option: D

AI Explanation

To return the number of records in the "Persons" table using SQL, you can use the COUNT(*) function.

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

Option A) SELECT COUNT() FROM Persons - This option is incorrect because the COUNT() function requires an argument. The argument specifies the column or expression to count. Without the argument, the function will produce an error.

Option B) SELECT COLUMNS() FROM Persons - This option is incorrect because there is no COLUMNS() function in SQL. To select all columns from a table, you can use the * wildcard.

Option C) SELECT COLUMNS(*) FROM Persons - This option is incorrect because there is no COLUMNS() function in SQL. To select all columns from a table, you can use the * wildcard.

Option D) SELECT COUNT() FROM Persons - This option is correct because it uses the COUNT() function to count all records in the "Persons" table. The COUNT(*) function returns the number of rows in the specified table.

The correct answer is D. This option is correct because it uses the appropriate COUNT(*) function to return the number of records in the "Persons" table.

In how many ways the Funnel Stage can operate?

technology databases

  1. Four

  2. Three

  3. Two

  4. Only one

Show answer
Correct Option: B

Select statement in Sybase can include columns not specified in the GROUP BY clause

technology databases

  1. True

  2. False

Show answer
Correct Option: A

This tool compares two files and produces a detailed report on the mismatches and successful matches. Used extensively in data validation.

technology databases

  1. QUEST TOAD FOR ORACLE 9

  2. None

  3. SCOOTER SOFTWARE BEYOND COMPARE 3

  4. EMBARCADERO DB ARTISAN 8

Show answer
Correct Option: C

In Sybase we can not compare a date column with a varchar value.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Choose the data type not supported by SQL Server

technology databases

  1. varchar

  2. int

  3. text

  4. binary

  5. Image

Show answer
Correct Option: C,E

Tool(s) used for Sybase to oracle migration is/are:

technology databases

  1. SQL Developer

  2. SQLWays

  3. Both a and b

  4. Only a

Show answer
Correct Option: C

Sybase exodus is migration of Sybase to which of the following databases

technology databases

  1. MYSQL

  2. SQL Server

  3. DB2

  4. Oracle

  5. All of the above/ Any database suggested by client

Show answer
Correct Option: B,D

What is a child stored procedure?

technology databases

  1. A procedure that is very small

  2. A procedure being invoked by another procedure

  3. A procedure that is not used by application

  4. System stored procedures

Show answer
Correct Option: B

Choose the datatypes not supported by Oracle

technology databases

  1. timestamp

  2. varchar

  3. datetime

  4. number

  5. raw

Show answer
Correct Option: C

In Sybase what returns the number of row affected by the preceding query

technology databases

  1. @@trancount

  2. @@rowcount

  3. @@sqlstatus

  4. @@rescount

Show answer
Correct Option: B

Magic tables in Sybase are

technology databases

  1. inserted

  2. updated

  3. deleted

  4. created

Show answer
Correct Option: A,C

Identify the background process which, is responsible for writing data from buffer cache to the datafiles to make changes permanent

technology databases

  1. Checkpoint (CKPT)

  2. Database Writer (DBWR)

  3. Process Monitor (PMON)

  4. Log Writer (LGWR)

Show answer
Correct Option: B

Identify the parts of System Global Area. Choose all that apply.

technology databases

  1. Database Buffer Cache

  2. Shared Pool

  3. Data Dictionary

  4. Redolog Group

  5. Redolog Buffer

Show answer
Correct Option: A,B,E

Identify the physical components of the database. Choose all that apply

technology databases

  1. Database

  2. Controlfile

  3. Table

  4. Datafile

  5. Index

  6. Redolog Group

Show answer
Correct Option: B,D,F

Identify the physical component of the database, which stores the information about the database layout

technology databases

  1. Datafile

  2. Controlfile

  3. Redolog Group

  4. Archivelogs

  5. Password File

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