Ask a Question

The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints

in Education by
The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints (a) 6789 (b) 2345 (c) 1234 (d) 456789 This question was posed to me in an interview. My doubt stems from A Simple Transaction Model in division Transactions of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Correct choice is (b) 2345 The explanation is: SUBSTR are used to match the particular characters in a string.

Related questions

0 votes
Q: What is the difference between SUBSTR and CHARINDEX in the SQL Server?
    What is the difference between SUBSTR and CHARINDEX in the SQL Server?...
asked Nov 9, 2020 in Technology by Editorial Staff
0 votes
Q: Write a function that interchange and prints the value of two integers A and B without using
    Write a function that interchange and prints the value of two integers A and B without using any extra variable in php. Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance
0 votes
Q: The SQL query to create a new database COMPANY *a) SELECT DATABASE COMPANY;b) CREATE DATABASE COMPANY;c) CREATE DATABSE NAME COMPANY;
    The SQL query to create a new database COMPANY * a) SELECT DATABASE COMPANY; b) CREATE DATABASE COMPANY; c) ... All of the above Select the correct answer from above options...
asked Dec 31, 2021 in Education by JackTerrance
0 votes
Q: Select right statement to insert values in the table CUSTOMERS *a) INSERT VALUES INTO CUSTOMERS….b) INSERT INTO CUSTOMERS VALUES …..c) INSERT CUSTOMERS VALUES …..
    Select right statement to insert values in the table CUSTOMERS * a) INSERT VALUES INTO CUSTOMERS . b) INSERT INTO ... NONE OF THE ABOV Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
Q: In your choice of language, write a program that prints the numbers ranging from one to 50.
    In your choice of language, write a program that prints the numbers ranging from one to 50....
asked Apr 26, 2021 in Technology by JackTerrance
0 votes
Q: SQL performance for select from where result of table
    I would like to ask for performance of SQL. This is my query: Select A.code ,A.name ,(Select B. ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 20, 2022 in Education by JackTerrance
0 votes
Q: How do I UPDATE from a SELECT in SQL Server?
    In SQL Server, it's possible to insert into a table using a SELECT statement: INSERT INTO Table (col1, col2, ... .id = other_table.id Select the correct answer from above options...
asked Jan 26, 2022 in Education by JackTerrance
0 votes
Q: using substr to limit characters inside of an element
    I am paginating users and in my view I have: I want to limit li.profile to 200 characters ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 11, 2022 in Education by JackTerrance
0 votes
Q: Return list of emp # NOT in a query, Access 2007
    have a table of the list of problems people can have. These people are id'd by a number. These ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 26, 2022 in Education by JackTerrance
0 votes
Q: Return list of emp # NOT in a query, Access 2007
    have a table of the list of problems people can have. These people are id'd by a number. These ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 25, 2022 in Education by JackTerrance
0 votes
Q: Program that prints an ASCII pyramid
    I have written the following program in C# to display an ASCII pyramid. public static void method1() { int k; int kCond = 5; int i; int inc = 0; for (int p = 0; p...
asked Apr 21, 2022 in Education by JackTerrance
0 votes
Q: __________ prints out the function call stack after an error occurs.
    __________ prints out the function call stack after an error occurs. (a) trace() (b) traceback() (c) ... Debugging of R Programming Select the correct answer from above options...
asked Feb 12, 2022 in Education by JackTerrance
0 votes
Q: How to get prints of shared object memory maps or heap memory maps for a given process?
    How to get prints of shared object memory maps or heap memory maps for a given process? (a) jmap ... programming questions and answers pdf, java interview questions for beginners...
asked Oct 26, 2021 in Education by JackTerrance
0 votes
Q: Python equivalent of select * from a where account_id in (select account_id from b)
    I am from an SQL background was looking for the best way of doing this. c = a.account_id.isin(b. ... above method efficient way? Select the correct answer from above options...
asked Jan 18, 2022 in Education by JackTerrance
0 votes
Q: A and B play a game where each is asked to select a number from 1 to 25. If the two numbers match, both of them wins a prize.The probability that they
    A and B play a game where each is asked to select a number from 1 to 25. If the two numbers match, both of ... 2/25 D. none of these Select the correct answer from above options...
asked Nov 15, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...