Tag: technology

Questions Related to technology

When you pass a table via LINKAGE, which of the following makes you a good programmer?

technology mainframe

  1. Subscript

  2. Index

  3. Either

  4. Author should learn COBOL

Show answer
Correct Option: D

A job can run continuously in mainframe for

technology mainframe

  1. 1440 Minutes

  2. 248 Days

  3. Forever

  4. Till Mainframe server is down

Show answer
Correct Option: B

How to retrieve runtime property of an object?

technology testing

  1. GetToProperty

  2. GetProperty

  3. GetRoProperty

  4. ObjectProperty

Show answer
Correct Option: C

What does SQL stand for?

technology databases

  1. Strong Question Language

  2. Structured Query Language

  3. Structured Question Language

  4. Strong Query Language

Show answer
Correct Option: B

With SQL, how do you select all the columns from a table named "Persons"?

technology databases

  1. SELECT * FROM Persons

  2. SELECT [all] FROM Persons

  3. SELECT Persons

  4. SELECT FROM Persons

Show answer
Correct Option: A

Which SQL statement is used to return only different values?

technology databases

  1. SELECT DIFFERENT

  2. SELECT UNIQUE

  3. SELECT DISTINCT

  4. SELECT EXACT

Show answer
Correct Option: C

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

technology databases

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

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

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

  4. INSERT VALUES ('Jimmy', 'Jackson')

Show answer
Correct Option: A

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

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

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

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

  4. INSERT INTO Persons ('Olsen')

Show answer
Correct Option: A

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

technology databases

  1. DELETE ROW FirstName='Peter' FROM Persons

  2. DELETE FROM Persons WHERE FirstName = 'Peter'

  3. DELETE FirstName='Peter' FROM Persons

  4. REMOVE FROM Persons WHERE FirstName = 'Peter'

Show answer
Correct Option: B

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

technology databases

  1. DELETE

  2. COLLAPSE

  3. REMOVE

  4. ERASE

Show answer
Correct Option: A